Re: Star Schemas ! What are they ??

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Tue, 26 Oct 1999 16:55:04 +0100
Message-ID: <940953455.4539.0.nnrp-06.c2de6f3d@news.demon.co.uk>

Star schemas are a design tool used primarily for Data Warehouse/Marts and are based on the premise that a Fact Table (a table that holds the measurable - sales or tonnes or elephants) has a direct relationship with many Dimension tables (tables that hold Customers or Products). If you place a fact table in the middle a relationship can be drawn (literally in all of the Data Warehousing books you're likely to read) directly to 4 or 5 Dimension tables creating a 'star' effect. Then theres snowflaking and all that 'flaky' stuff !

Best get a Data Warehousing book .. sorry I can't recommend one ...

Tapan Trivedi wrote in message <3816666B.C151D4AB_at_abbnm.com>...
>Hi Guys,
>Some of my managers are telling me that there is a growing demand in the
>industry for people with experience with STAR Schemas. Does any body
>know what they are ? Any documentation anywhere ??
>
> Tapan
Received on Tue Oct 26 1999 - 10:55:04 CDT