Overview
The Snowflake Schema is a variation of the star schema where dimension tables are normalized into multiple related tables. This results in a more complex structure that resembles a snowflake.
Comparison with Star Schema
- Normalization: Snowflake is more normalized.
- Storage: Snowflake uses less storage space.
- Performance: Star schema generally has better query performance due to fewer joins.