Manage revenue with Impact: Page 5


You Can't Detect What You Can't See: Illuminating the Entire Kill Chain

On-Demand Webinar

Posted September 1, 1999

Kevin Strehlo

(Page 5 of 7)

Star and snowflake schemas. A star schema features a single fact table, with detail and summary data. The primary key has only one key column per dimension. Each key is generated, and each dimension is a single table.

The benefit of such a schema is that it offers hierarchies that are easy to understand and easy to define. As a result, you find a reduced number of physical joins, simple metadata, and a low-maintenance data mart. On the other hand, the summary data in the fact table yields poorer performance for summary levels. And huge dimension tables can present a problem.

The snowflake schema offers no level in dimension tables. The tables are normalized by decomposing at the attribute level. Each dimension table has one key for each level of the dimension's hierarchy. The lowest level key joins the dimension table to both the fact table and the lower level attribute table.

So how does it work? The best way is for the query to be built by understanding which summary levels exist, finding the proper snowflaked attribute tables, constraining keys, then selecting from the fact table.

Page 5 of 7

Previous Page
1 2 3 4 5 6 7
Next Page

0 Comments (click to add your comment)
Comment and Contribute


(Maximum characters: 1200). You have characters left.



IT Management Daily
Don't miss an article. Subscribe to our newsletter below.

By submitting your information, you agree that datamation.com may send you Datamation offers via email, phone and text message, as well as email offers about other products and services that Datamation believes may be of interest to you. Datamation will process your information in accordance with the Quinstreet Privacy Policy.