Peter Robson wrote: > Outrageous! And this person TAUGHT??? > > In line... > > > > > PB> Q: What are the basic guidelines one should keep in mind while > PB> designing a database? Is denormalization always good? > > PB> A: I used to teach database design in graduate school, and your > PB> question is excellent! The main purpose of high normalization was the > PB> reduction of disk space, back when it mattered in the 1970s. > > Absolute utter rubbish - doesn't understand what normalisation is. > Doesn't understand what a 'data model' is. > > PB> Today, I always introduce redundancy into the model whenever it can > PB> eliminate an SQL join, but not always. I make my decision based on two > PB> criteria: > > PB> 1 ? The size of the redundant item > > PB> 2 ? The volatility of the item (e.g. how often do I need to duplicate > PB> updates) > > Oh please - cannot cope with any more of this nonsense.... > > > Hmmm, it might be interesting to know who it was - then perhaps > ignorance is bliss... > > > > peter > edinburgh > Easy enough to figure out. It's an old _friend_ of Richard and Howard's. Google one of his phrases..... ;) -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Online Demo: https://www.presinet.com/secure/login _______________________________________________________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than the intended recipient is unauthorized. If you have received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------