Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Creating a model of a bad database

by EdwardG (Vicar)
on Dec 13, 2006 at 13:51 UTC ( #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!

 


Comment on Re: Creating a model of a bad database

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (11)
As of 2014-09-17 11:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (72 votes), past polls