RE: Database Normalization-Outdated?

Normalization process should be done at the logical level, but it can be denormalized at the physical level to support "must have" transaction processings.

-----Original Message-----
Sent: Wednesday, May 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wong, Bing
  INET: bing.wong_at_IngramMicro.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).