Re: Index based database?

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Fri, 15 Dec 2006 09:05:05 +1100
Message-ID: <MPG.1fec759c641be8d09898c1@news.readfreenews.net>

Junk_at_webthere.com says...
> DA Morgan wrote:
> >
> > Is is a "real" warehouse designed as one or just a copy of an OLTP schema?
> > Are they being used?
> > What index type?
>
> 1. Kimbal Based Warehouse no legacy OLTP and no ODS, designed for
> warehouse/reporting
>
> 2. Indexes being used: not always - but that's another issue.
>
> 3. Index type = B*Tree, all B*Tree

It is often common for indexes in a DW to be bitmap rather than b-tree.

Good book by Bert Scalzo specifically on Oracle/DW/star schemas is worth a read.

GM Received on Thu Dec 14 2006 - 16:05:05 CST