Re: Design question
From: <matthias.hoys_at_gmail.com>
Date: Wed, 18 Feb 2009 00:34:36 -0800 (PST)
Message-ID: <2afc1ce7-173a-45be-a224-96f6d79bf2c8_at_m42g2000yqb.googlegroups.com>
Date: Wed, 18 Feb 2009 00:34:36 -0800 (PST)
Message-ID: <2afc1ce7-173a-45be-a224-96f6d79bf2c8_at_m42g2000yqb.googlegroups.com>
>
> Use lots of Bitmap indexes. Set the instance parameters for star schema
> transformation.
>
> In addition of the Kimball book already mentioned, there's a good Oracle-
> specific data warehouse book (can't put hands on my copy to check the
> title) by Bert Scalzo.
>
> Be pragmatic in your design. I use elements of both the Kimball and Inman
> approaches. There is no one "right way".
>
> Geoff M
I see that the Scalzo book is from 2003 - is that still relevant ? It only covers Oracle 8i and 9g. Are there any good recent DWH books for Oracle ? Received on Wed Feb 18 2009 - 02:34:36 CST