The different Data Warehousing schemas are as follows:
Star Schema:Definition: The star schema is the simplest data warehouse schema. It is called a star schema because the diagram resembles a star, with points radiating from a center.
A single Fact table (center of the star) surrounded by multiple dimensional tables(the points of the star).
Advantages:- Simplest DW schema (EDIT)
- Easy to understand
- Easy to Navigate between the tables due to less number of joins.
- Most suitable for Query processing (EDIT)
Disadvantages:- Occupies more space
- Highly Denormalized (EDIT)
Snowflake schema:Definition: A Snowflake schema is a Data warehouse Schema which consists of a single Fact table and multiple dimensional tables. These Dimensional tables are normalized.
Advantages: - These tables are easier to maintain
- Saves the storage space.
Disadvantages:- Due to large number of joins, it is complex to navigate
Constellation Schema:Definition:A Constellation Schema in which one dimension table is accessed by one more than one Fact table.
In this type of schema, there may be one or more than one number of Fact tables and also Dimension Tables.
It sometimes also called as
Galaxy Schema.