RE: Datawarehouse suggestions?

>-From: Thater, William

I'm glad you are back "Shrek"!!

Dave

-----Original Message-----
Sent: Sunday, September 02, 2001 9:45 AM To: Multiple recipients of list ORACLE-L

Rachel Carmichael wrote:

> Okay, first the rant.... they want me to build a new database to hold
> logs of every time someone hits a page on our website or uses one of
> the functions on the site. Without a new server or disk, on a box
> that currently holds the OLTP database, on a disk array that is RAID 5
> and that EMC wants to take BACK disks from. In other words, they want
> magic. Where did I leave that rabbit and hat?

OK this is just plain stupid, but it's what you have to live with.

>
> Oh yeah, did I mention that they want this to be a reporting database
> for external customers (read revenue stream) and want these external
> people to be able to query on any combination of columns -- so they
> want indexes on EVERY column.

one thing about data warehouses is that your decrease your level of normalization, and expect redundant data. if you can figure out in advance what MOST of the queries will be like, try to lay out the tables so that there is no or little joining for them.. yes that means fields will be repeated. and i can't wee where indexing every column will help, but far be it from me to disagree.

and like you don't know what i just said? but then i always did have the talent for pointing out the obvious.;-)

and where are you doing the data scrubbing?

>
>
> I will have a nightly maintenance window for loads of prior day's
> data. I'm thinking to do a shutdown, change the init.ora to tune for
> heavy batch, startup, drop indexes, load data, recreate indexes,
> shutdown, backup, startup with init.ora tuned for querying.

sounds like a plan to me.

-- 
--
Bill "Shrek" Thater              ORACLE DBA
Telergy,Inc.                   thaterw_at_telergy.net
------------------------------------------------------------------------
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
------------------------------------------------------------------------
Every program is either trivial or it contains at least one bug.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.com

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