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: [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: Seefelt, Beth 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).
