Snowflake Data Model

This shows a Snowflake Datawarehouse design for a Financial Transaction,
where a Dimension can have a higher-level 'Super Dimension' ...

Star and Snowflake Data Models are typically used to support Data Warehouses or Data Marts.
These designs are characterised by a central Table, holding the 'FACTS', with a number of 'DIMENSIONS' tables radiating outwards, just to one level.
A Snowflake Design is similar, except that there are many levels radiating outwards.
A Star Design is often a de-normalised Snowflake and is preferred for performance reasons, which can be a critical issue in Data Warehouses.

[ Home Page | Ask me a Question | Email | FAQs | Search