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.
|
|||||||||||||||||||||||||