Title: Message
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 is I entered your URL below but
received a "Page Not Found" error.
When I
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 to explan the boyce-codd normal form from an
academic text book :)
From: [EMAIL PROTECTED]
Date:
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
Lisa,
Any chance of getting the name of both the consultant and the book?
Jared
Lisa R. Clary [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/30/2002 12:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
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
Lisa,
Before you go about abandoning the entire phylosophy of database modeling,
let me say this:
This 2 table (actually 3 table), meta-modeling is not the wave of the
future. It could be the wave of the past. In fact, Oracle designer was
like this, with just 2 tables SDD_ELEMENTS and
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
Too funny!
The first problem that comes to mind is duhvelopers:
There are a lot of developers that would simply be incapable
of dealing with Meta Data for every day queries. We tried to
use some very flexible meta data in a DW, and it turned out
to be too hard for the developers to grasp, many
27 matches
Mail list logo