Saturday, 7 June 2014

Star Schema with Diagram

Star Schema
·   In Star Schema all dimensional tables are related with One Fact table.
·   The dimension table contains the set of attributes. Each Dimension table has a one to many relationship with Fact table.
·   Simple Star Schema contains only one Fact Table where as a complex star schema contains more than one Fact table.
·   Star schemas are denormalized that reason it retrieve data faster than highly normalized schemas.

     The above diagram explains Simple Star Schema. There is a fact table at the center of location and it contains the keys to four dimensions.

No comments:

Post a Comment