| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Normalization-Outdated?
I agree whole-heartedly. Besides, what that consultant is describing is just the logical view of x.500, LDAP or something like it. Its how you logically view that type of database. If you look at most LDAP products, the internal structure of the database is relational and highly normalized. That logical view is presented through rigid RI, triggers and stored procedures to make data retrieval very fast and simple for a very specific type of application.
-----Original Message-----
Sent: Wednesday, May 01, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L
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
>
-- 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: Seefelt, Beth INET: Beth.Seefelt_at_TetleyUSA.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).Received on Wed May 01 2002 - 11:58:31 CDT
 |
 |