Perl-Sensitive Sunglasses | |
PerlMonks |
Re: Creating a model of a bad databaseby EdwardG (Vicar) |
on Dec 13, 2006 at 13:51 UTC ( [id://589582]=note: print w/replies, xml ) | Need Help?? |
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!
In Section
Seekers of Perl Wisdom
|
|