topic Re: data warehouse set-up in Operating System - HP-UX

data warehouse set-up

Edgar_8 — Fri, 09 Jan 2004 07:36:44 GMT

Hi,

Does anyone know where we could get documentation on setting up a data warehouse; optimizing the set-up
; how best to load(pl/sql procedures/triggers; sqlldr scripts etc) the data etc. We have set-up a DB with 1 large fact table (approx. 700GB)
using unix/sql loader scripts to load data. But we looking to optimize the load process & also
ensuring that queries are fast by enabling indexes.
Any ideas; material would be most appreciated.

Thanks in advance!

Re: data warehouse set-up

Yogeeraj_1 — Fri, 09 Jan 2004 08:30:56 GMT

hi,

Tim Gorman's book, Oracle 8i Essential Datawarehousing is a very good starting
point for beginners.

regards
Yogeeraj

Re: data warehouse set-up

Mark Greene_1 — Fri, 09 Jan 2004 08:31:10 GMT

What database? Oracle, Sybase, DB2, Informix, or something else?

If you truly have 700GB in one table, you need to start there and make sure you've normalized the data. Chances are very high that you can break this down into more tables, apply some indexing, and do a few other things with the topology of the data to get better performance.

mark

Re: data warehouse set-up

Yogeeraj_1 — Fri, 09 Jan 2004 08:36:56 GMT

hi again,

another interesting white paper on large scale datawarehousing...

see attachment.

regards
Yogeeraj