Database Answers Header Kyomizu Dera, Japan
Conceptual Star Data Model for Teaching Schedule
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

You can check out the FACTs or Business Rules which the Data Model must comply with,
and a Physical Data Model has been produced.

Data Model for Star Classes

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

    Barry Williams
    Principal Consultant
    Database Answers

    [ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

    © IceBreaker WebDesigns 2001