Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news.maxwell.syr.edu!newsgate.netvigator.com!imsp212.netvigator.com!not-for-mail
From: Reid Lai <reidlai@netvigator.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Star Transformation
Date: Wed, 10 Oct 2001 19:29:29 +0800
Organization: IMS Netvigator
Lines: 31
Message-ID: <3BC43118.27F6D9A4@netvigator.com>
References: <kpp8stcfndgasufbgo5n677aurgbqo2ols@4ax.com>
NNTP-Posting-Host: pcd409003.netvigator.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.76 [en] (Win98; U)
X-Accept-Language: en
To: Dino Hsu <dino1.nospam@ms1.hinet.net>
Xref: easynews comp.databases.oracle.server:120850
X-Received-Date: Wed, 10 Oct 2001 11:11:44 MST (news.easynews.com)

Dino,

Bitmap index may not help depending on volumn and cofiguration.  If you
want to test and try star schema, try DIMENSION and MATERIALIZED_VIEW.
Hope this can help you.

Reid

Dino Hsu wrote:

> Dear all,
>
> I've just read Chapter 16 Schmeas, Oracle8i Data warehousing Guide
> Release 2 (8.1.6), I found star transformation to be very interesting.
> I want to confirm my understanding about how star transformation
> works:
> 1.The initialization parameter STAR_TRANSFORMATION_ENABLED set to
> true.
> 2.Bitmap indexes created for all foreign keys of the fact table.
> 3.Bitmap indexes created for primary keys of the fact table and for
> large dimension tables. (full table scan is fine for small dimension
> tables)
> 4.Remote small dimension tables are allowed, but not the fact
> table.(not sure)
> 5.Star transformation is general enough to include both star schema
> and snowflake schema. In my idea, star schema is a special case of the
> more general snowflake schema.
>
> Thanks,
> Dino