RE: Large databases

I think the thing that maybe hasn't been stated is that "normalization" of data was developed because.....
storage space was extremely expensive. Eliminating redundant data was THE driving factor in data modeling. In a typical system you could save tens of thousands if not 100K if you could eliminate redundant data. Speed and performance was not as important as data integrity and cost. In those days...many "users" were not "users" until these systems were created. They went from a paper world to a green screen and they rejoiced and said it was good.

Now we want real time access, instant queries against huge production databases that store millions of rows of data on the price change of a bunch of nuts sitting in a bin halfway across the world.

The users now feel the need for accessibility and performance as storage is cheap...they want the data. So design for speed and accessibility and to deliver the data without bringing down the database with big ugly nasty adhoc queries.

Brad O.

"I want a goose that lays golden eggs daddy...and I want it now!" Veruka - WW&CF

-----Original Message-----
Sent: Wednesday, April 16, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L

>
> 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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.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).