Re: Where can I find real-life-examples about ORACLE

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Mon, 23 Apr 2001 10:05:35 -0700
Message-ID: <F001.002EF4F2.20010423101529@fatcity.com>

I'd be curious to see your definitions of "un-normalized" and "de-normalized"...

>>> PierceED_at_csus.edu 04/23/01 01:55PM >>>

On 20 Apr 2001, at 19:15, Jared Still wrote:

Date sent:              Fri, 20 Apr 2001 19:15:20 -0800
To:                     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>



> >

> > Well, why would you *not* want to denormalize during design? It seems

> > to me that (theoretically) ***if*** you are doing "structured"

> > denormalization correctly, that is exactly when you would want to do
> > it, no?
>
> Unless you detect a performance problem, why denormalize at all?
>
> We always have folks that want to denormalize because they *think*
> there will be a performance problem. This usually occurs because
> they think that joining 3 or 4 tables will be too slow.

I guess I've been under the impression that a good design process would be done with proper methods, including having (legitimately tested) performance metrics.

Are you saying that is an overly idealistic approach for most "real world" situations? :)

...

> ... Only one table was highly denormalized, and
> that was nobody could figure out a reasonable way to normalize it. Not sure
> if I could yet. :)

Well, as i said before, my understanding is that it was "unnormalized", which is different from "denormalized".

>
> This may be different for really large OLTP databases with a very high number
> of users, but I've never had the privilege of working on one that big.
> e.g. Amazon.com, etc.

ok. cool. last time I really paid any attention to this topic was around Oracle v6. :)

I'll be migrating a departmental database to Oracle8/9 on NT over the next 6 months or so. It is in severe need of normalization. I'll start with a highly normalized model, and see how it goes.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu 

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: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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 Mon Apr 23 2001 - 12:05:35 CDT