Ok. Since we are telling old stories around the
campfire and at the risk of extending this thread even
more, here are my 2bit stories :)
Absolutely positively you must have RI on any
tranactional system critial to your bussiness. If
someone recommends otherwise, politely disagree then
run if
Lisa R. Clary wrote:
Hi all,
I sort of come from an old school where you should normalize data where you
can (typically 3rd or 2nd) so that you get the efficiency of normalization
but not the difficulty of data extraction. Additionally, I always thought
that putting RI on tables was
Title: RE: Database Normalization-Outdated?
I Admin'ed a vendor app that was built similar to this (and the UI was in Designer - made me not think kindly of Oracle duh-velopment environments). Except that they had more tables to contain all the CODES. I always referred to this nightmare
Just wanted to extend my appreciation for all of your responses to this
topic. I liked the fact that even though overall, it was obvious old school
still holds, that many of you were able to show that it could be
advantageous in certain circumstances (not ours). This will make it much
easier to
PROTECTED]@SUNGARD On Behalf Of Stephane Faroult
[EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 4:28 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Database Normalization-Outdated?
Lisa R. Clary wrote:
Hi all,
I sort of come from an old school where you
[EMAIL PROTECTED]
Sent by: rootcc:
Subject: RE: Database
Normalization-Outdated
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
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
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
.
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
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
:Database Normalization-Outdated?
Hi all,
I sort of come from an old school where you should normalize data where
you
can (typically 3rd or 2nd) so that you get the efficiency of normalization
but not the difficulty of data extraction. Additionally, I always thought
that putting RI
I would be *extremely* interested in knowing the author's name. Especially
if it's a he and his initials are DK...
Back in 1992-93, I was working for Oracle and was asked to assist a company
who had done exactly what you suggested in this email thread -- data-pair
combinations and metadata
Hi all,
I sort of come from an old school where you should normalize data where you
can (typically 3rd or 2nd) so that you get the efficiency of normalization
but not the difficulty of data extraction. Additionally, I always thought
that putting RI on tables was fairly important (prevention of
PROTECTED]
To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject : Database Normalization-Outdated?
Date : Tue, 30 Apr 2002 11:48:37 -0800
Hi all,
I sort of come from an old school where you should normalize data where you
can (typically 3rd or 2nd) so that you get the efficiency
Lisa - not sure i follow the specific example, but i say RI is still a
wonderful feature of an RDBMS and should not be thrown out. Many package
apps have not implemented RI because they run on many RDBMS platforms, and
each handles RI differently. So put the RI in the app they say - right!
Not
If this concept is so simple (simplistic?),
why does it take a whole book to elaborate on it?
Lisa R. Clary wrote:
[...snip...]
Recently, a consultant who has published a book about
SQL is now telling me that there is a better model--that of value pair
combinations (e.g. variable, value) to
]
04/30/2002 12:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Database Normalization-Outdated?
Hi all,
I sort of come from an old school where you should normalize data where
you
can (typically 3rd
18 matches
Mail list logo