Re:Oracle Vs Tera Data

On Mon, 5 Feb 2001,dgoulet_at_vicr.com scribbled on the wall in glitter crayon:

-> There are two basic problems with data warehouses that I've seen & it should
->be noted that I'm in the middle of specing a re-wtite of ours. 1) people create
->then in a normalized manner, not in the idea of a series of stars. COnsequently
->you end up with too much data in a single table making that table a real bear to
->manage. 2) end users have this ungodly desire for speed. My GOD, if your
->searching through 2 or 3 billion rows of data of course it's going to take a
->while.

i'm currently fighting with damagement over the same issues. "no datawrehousing is not the same as creating a production database." "no i can't get the warehouse to run as fast as the production database and do it right."

repeat the above two statments several times a day.;-)

--
Bill Thater             Certified ORACLE DBA
Telergy, Inc.            thaterw_at_telergy.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"We are different, in essence from other men.
If you want to will something run 100m.
If you want to experience something run a marathon"
Emil Zatopek
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
How do I love thee?  My accumulator overflows.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: thaterw_at_telergy.net

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