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