To speak to that point; we are the state tax department. We received and send mail, hundreds of pieces. Our original tax appliation required us to go to at least10 tables to get an address because it was completely normalized. When we go the new and improved version this was denormalized for the sake of design and speed. Storage is cheap now, but bad coding can take more resources than you have.
Just my $.02, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 12:08 PM > List- > > My Opinion: > > The purpose of Normalization is to reduce redundant storage. It is a trade > off between affording redundancy(as far as you can?)and avoiding to many > joins later. It can not be true accross the board. Designers should go by > the merit/requirements of the application. If database is normalized as and > where it is possible(i.e. up to Boyce-Codd Normal Form); it might become a > nightmare while trying to run BUSINESS OBJECTS/COGNOS/etc against it. As > Hanna just mentioned joining 17 tables. AT my present work place I am > dealing with a db which is so poorly designed. Now to be able to support > BUSINESS OBJECT the developers are kind of taking band aid approach - asking > for denormalizing the db tables with so called "WORK TABLES" - It is serving > two purposes, saving them from "coding nightmares" and improving apps > performance. > > As far as RI is concerned I have seen in places they do not use RI rather > loves to maintain data integrity by using triggers. My opinion on this - > This is more of a preference than to do with any technicality. > I am for RI. > > Shaibal > > > >From: [EMAIL PROTECTED] > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Database Normalization-Outdated? > >Date: Wed, 01 May 2002 04:03:29 -0800 > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shaibal Talukder > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).