Re: Normalization

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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------