On Mon, 5 Feb 2001,[EMAIL PROTECTED] 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. [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).