List,
Doing some reading on Normalization today. We actually have the opportunity
to create a database and app, and it's been so long since I've done this on a real
project, a refresher was in order.
I have the annoying habit of knowing what to do with normalization, based on past
education and
r.
When I searched the TinyURL site for "normalization" hits,
this is what I came up with.
Thanks,
Melanie
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Monday, November 03, 2003 1:34
PMTo: Multiple recipients of list ORACLE
: 2003/11/03 Mon PM 01:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Database Normalization
List,
Doing some reading on Normalization today. We actually have the
opportunity
to create a database and app, and it's been so long since I've done this
on a real
change the url to www.tinyurl.com/th7i
--- Melanie Caffrey [EMAIL PROTECTED] wrote:
Hi Jared,
Just so I'm clear which one to avoid, are you referring to the one
that
links to the excerpt from this book?
Sams Teach Yourself SQL in 21 Days, Second Edition
The reason I'm asking
Jared - The book that has helped me the most is The Data Modeling Handbook
by Reingruber and Gregory. Their approach is to develop a best practice for
each modeling situation.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, November 03, 2003
Jared, I'm sure that the three of you can easily do it. Good luck.
On 11/03/2003 01:34:26 PM, [EMAIL PROTECTED] wrote:
List,
Doing some reading on Normalization today. We actually have the
opportunity
to create a database and app, and it's been so long since I've done this
on a real
Thanks, Rachel.
Obvious answers like the below elude my overworked and sleep-deprived
brain right now :)
Long work weekend and all that ...
Guess I'll leave poor Sams alone, then.
-Original Message-
Rachel Carmichael
Sent: Monday, November 03, 2003 2:15 PM
To: Multiple recipients
To: Multiple recipients of list ORACLE-L
Subject:Re: Database Normalization
File: reply ive seen tom kyte say the same thing. normalize unless
its bad for design and/or hurts performance.
which is similiar to normalize until its inconvenient.
you could have some real fun and try
-L [EMAIL PROTECTED]
cc:
Subject:RE: Database Normalization
Jared - The book that has helped me the most is The Data Modeling Handbook
by Reingruber and Gregory. Their approach is to develop a best practice for
each modeling situation.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL
]
cc:
Subject:RE: Database Normalization
Jared - The book that has helped me the most is The Data Modeling Handbook
by Reingruber and Gregory. Their approach is to develop a best practice for
each modeling situation.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED
More than enough. :)
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/03/2003 12:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Database Normalization
Jared - Sounds fine. Do you feel
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
Monkey Mama
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database Normalization
[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
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
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
.
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
29 matches
Mail list logo
