Re: To Denormalise or not to Denormalise

The key phrase is "efficiently implemented"!! Any database can be efficiently implemented in 3NF, but that does not guarantee efficent performance. Performance can always be improved via denormalization, but the cost is increased data maintenance headaches. Its a tradeoff, like so many things are.

"Lawrence" <lsimela_at_mahalini.prestel.co.uk> wrote in message news:8e58ks$4lh$1_at_phys-ma.sol.co.uk...
> Hi All
>
> I wonder if any of you folk out there can help settle an argument with a
> colleague who passionately believes that one should never have to
> denormalise any part of a well designed database. He believes that a
 'well
> designed' database should be in 3NF or higher and can be efficiently
> implemented without denormalising any part of it.
>
> Thanks in advance for any comments
>
> Lawrence
>
>
Received on Tue Apr 25 2000 - 00:00:00 CDT