Wiki Home

Snowflake Schema

Namespace: WIN_COM_API
The snowflake schema is used in Data Warehouse applications and is essentially an extended Star Schema where each point of the star branches to more points. In the snowflake schema, the star schema dimension tables are more normalized.

The advantages of the snowflake schema are
  • improvements in query performance due to minimized disk storage for the data, and
  • improved performance by joining smaller normalized tables, rather than large denormalized ones.
    The snowflake schema also increases the flexibility of the application because the normalization lowers the granularity of the dimensions. However, since the snowflake schema has more tables, it also increases the complexities of some of the queries that need to be mapped.

    Category Data Warehousing Category Data Modeling
  • ( Topic last updated: 2000.02.18 11:57:28 AM )