Database Answers Header

Kasbah du Toubkal Hotel, Morocco
Snowflake Transaction
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
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

    © IceBreaker WebDesigns 2001