Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Normalization-Outdated?
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" <ORACLE-L_at_fatcity.com>
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: johanna.doran_at_sungard.com
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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: shaibal_talukder_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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: rgramolini_at_tax.state.vt.us 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: ListGuru_at_fatcity.com (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).Received on Wed May 01 2002 - 11:48:23 CDT
![]() |
![]() |