data warehouse set-up

[Edgar_8]

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!

[Yogeeraj_1]

hi,

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


regards
Yogeeraj

[Mark Greene_1]

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

[Yogeeraj_1]

hi again,

another interesting white paper on large scale datawarehousing...

see attachment.

regards
Yogeeraj