RE: Large databases

From: Chris Berry <compjma_at_hotmail.com>
Date: Wed, 16 Apr 2003 13:39:16 -0800
Message-ID: <F001.00583638.20030416133916@fatcity.com>

>From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
> > Question to all you practical DBA's out there: Is is slower or faster
> > to normalize or not?
>---------------------------
>
>From an Oracle tuning book (I don't recall the title, but it was from
>Oracle
>Press):
>
>"Store the data the way you intend to query the data."
>
>(I might add: "if possible")
>
>There was also a quote, the gist of which (I don't recall it exactly), was
>something like: No large, fully normalized database can perform worth
>diddly.
>
>(Maybe a little extreme, but probably as a reaction to those who insist
>that
>all databases MUST be fully normalized.)
>
>I don't debate this kind of stuff, since it is religion. But, if you are
>counting votes, I tend to agree.

I use the following principal as a guide:

"Normalize till it hurts, then de-normalize till it works."

Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates

"Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides

---

MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Berry
  INET: compjma_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Wed Apr 16 2003 - 16:39:16 CDT