This shows a Snowflake Datawarehouse design for a Financial Transaction,
where a Dimension can have a higher-level 'Super Dimension' ...
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.
© IceBreaker WebDesigns 2001