Tutorial Home > Storage and Networking > Storage and Drives > Data Warehousing > The Snowflake Schema

The Snowflake Schema
A Snowflake Schema is a design where data is stored in a large central table, referred to as a "FACT" table, linked to and surrounded by smaller tables, called "Dimension" tables. This schema is similar to a Star schema. A Snowflake Schema provides faster response (retrieval of data) time and an improved update time (compared to a Star Schema). This series discusses Dimensions, FACT(s), surrogate keys, granularity, and qualitative and quantitative measures.

  Tutorials
  Dimensions
  Time Dimension
  Surrogate Keys
  Levels of Summarization
  FACT(s)
  Quantitative Measures
  Qualitative Measures
  Lookup Tables