Snowflake Schema: When one fact is surrounded by a chain of more than one dimension, it is called snowflake. It is also called an extension of star schema by adding more dimensions.
In snowflake schema the table are normalized.
If you do not understand the basic concepts of data warehousing, please visit my previous article.
If we consider the data warehousing scenario detailed here, below is how a snowflake schema would look like.
Click here to compare the same design with star schema.
Characteristics of Snowflake schema:
In snowflake schema the table are normalized.
If you do not understand the basic concepts of data warehousing, please visit my previous article.
If we consider the data warehousing scenario detailed here, below is how a snowflake schema would look like.
Characteristics of Snowflake schema:
- Less storage requirement because of normalized dimensions
- Less time to load as compared to star schema.
- Better slicing and dicing
- Join complexity increase
- Time to Query may increase a little depending on the scenario.
No comments:
Post a Comment