Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Creating a model of a bad database

by EdwardG (Vicar)
on Dec 13, 2006 at 13:51 UTC ( [id://589582]=note: print w/replies, xml ) Need Help??


in reply to Creating a model of a bad database

Hi Ovid

You don't give an example of the awful database design, but assuming its similar to some of my experiences I would offer these few words of caution;

Difficulties arising from ambiguities in the database design should not be underestimated. Columns (attributes) that are semantically overloaded or poorly defined will continue being problematic regardless of abstraction.

Lack of normalisation, and the accompanying risk of data corruption, is easy to overlook when building an object-relational mapping or a phrasebook. Can you afford to aim for 3NF? (Can you afford to not?)

And finally some rhetoric which may or may not be helpful; Poor foundations will sabotage anything built on top.

Cheers, and good luck!

 

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://589582]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2024-03-19 09:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found