Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

data warehouse set-up

Edgar_8
Regular Advisor

data warehouse set-up

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!
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: data warehouse set-up

hi,

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


regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Mark Greene_1
Honored Contributor

Re: data warehouse set-up

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
the future will be a lot like now, only later
Yogeeraj_1
Honored Contributor

Re: data warehouse set-up

hi again,

another interesting white paper on large scale datawarehousing...

see attachment.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)