Re: DataWarehousing
From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Tue, 6 Jan 2009 23:01:10 +1100
Message-ID: <MPG.23cdeca8b183a5639896de_at_news.x-privat.org>
raja says...
Date: Tue, 6 Jan 2009 23:01:10 +1100
Message-ID: <MPG.23cdeca8b183a5639896de_at_news.x-privat.org>
raja says...
> I got a oracle 10g database for datawarehousing.
> I dont know about datawarehousing concepts and the ways to performing
> tuning techniques applied in it.
>
> Please clarify me the following questions :
> For performance tuning and to know about the details of that
> database : In a datawarehouse database,
> 1. what are all the information should i get from the database ?
> 2. what are all the performance tuning techniques are applied ?
There's a good book on it by Bert Scalzo (spelling?) which deals with things like star schema optimization, parameter settings, etc.
Plus, of course, the doco/manuals.
Read lots.
GM Received on Tue Jan 06 2009 - 06:01:10 CST