Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

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!


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://589582]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (3)
As of 2018-03-18 08:55 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (229 votes). Check out past polls.