RE: Large databases

You keep saying storage is cheep. Have you bought any expansion drives from EMC lately? Oh yeah, you need to buy them in triplicate to get the R1, Mirror, and BCV. Remember EMC is the only vendor you can buy from since they void the warranty if you put any "cheap" drives in there. Storage is not cheap. On SAN devices it can be very expensive. Desktop storage, and server internal drives may be cheap, but they don't fit the bill for enterprise databases. Unless of course that "enterprise database" is written in Access and running on w2k. ;-)

Rodd Holman

On Wed, 2003-04-16 at 16:54, Odland, Brad wrote:
> 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

-- 
Rodd Holman <roddholman_at_hotpop.com>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  INET: roddholman_at_hotpop.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).