Data Modelling in Dataware house

In Data warehouse dimension modelling is used. Dimension model is designed using fact and dimensions.

There are 3 types of schemas used in dimension modelling.

1. Star schema
2. Snowflake schema
3. Galaxy schema

1. Star schema:

In star schema center of the star is fact table and corners are dimension tables. In star schema dimension tables don't have parent tables. In star schema dimension tables are denormalized. It is efficient in query processing.

Star Schema
Star Schema

2. Snowflake schema:

In snowflake schema dimension tables have one or more parent tables. Snowflake schema efficient in transaction processing.

Snowflake Schema
Snoflake Schema

3. Galaxy schema:

Multiple facts tables connected with multiple dimension tables. Also referred as multi star schema.

Galaxy Schema
Galaxy Schema

No comments:

Post a Comment