in reply to OT: benefits of database normalization
This is supposed to be a dictionary. The most common query that you'll have is to give me the definition of a name. Try to write that query with each schema. Keep in mind that over time if you allow A to be an alias to B, then some day someone is going to make B be an alias to C.
Any schema where you cannot write that query easily, and have it work after obvious data manipulations potentially mess you up, should be rejected in favour of a schema where common stuff is simple. And that holds for other design problems. When you're handed a design, say to yourself, "What do I think that I'll need to do, and how will I do it with this design?" If common operations turn into messes, the design should be viewed with suspicion.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: OT: benefits of database normalization
by revdiablo (Prior) on Oct 09, 2004 at 20:08 UTC | |
by tilly (Archbishop) on Oct 10, 2004 at 01:56 UTC |