 |
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.
An Access Database is available on demand.
The Specifications for the Data Model were provided in a question to Database Answers.
We might also design a Data Mart, which is very useful for providng data for Reports and Business Intelligence.
We would be glad to have
your comments.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
January 3rd. 2013
|
© DataBase Answers Ltd. 2013
|
Printer-friendly version