Scribd
Upload
9 views25 pages

Notes DM

The document discusses the differences between Star Schema and Snowflake Schema in data modeling, highlighting performance, query complexity, database size, and normalization. It notes that Star Schema has higher performance due to fewer joins and less complexity, while Snowflake Schema is more normalized but has lower performance. Additionally, it mentions the concept of Slowly Changing Dimensions (SCD1) as a technique for optimizing information storage within an organization.

Uploaded by

Nitesh Sree
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views25 pages

Notes DM

The document discusses the differences between Star Schema and Snowflake Schema in data modeling, highlighting performance, query complexity, database size, and normalization. It notes that Star Schema has higher performance due to fewer joins and less complexity, while Snowflake Schema is more normalized but has lower performance. Additionally, it mentions the concept of Slowly Changing Dimensions (SCD1) as a technique for optimizing information storage within an organization.

Uploaded by

Nitesh Sree
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

power designer

HR & Finance -> redundant – so we can combine these too

Data sub spec -> taking business decision based on datamart will be difficult.

 Top down & Bottom up



Difference between Star Schema and Snowflake schema

Feature Star Schema Snowflake schema

As there is no relationship
between dimensions to other Due to multiple links
dimensions the performance between dimensions the
Performance will be high. performance will be low.

The number of joins will be less The number of joins will be


Query which makes query complexity more which makes query
complexity low complexity high

Consider the Project dimension


mentioned in above example it The role information is
has Role column where the separately stored in a
Role name value will be stored table and the reference
against for each project in case will be linked in Project
of start schema, the size of the dimension, it reduces the
Database size table will be high table size

Data will be stored in de- Data will be stored in more


normalized format in dimension normalized format in
Normalization table dimension tables

SCD1:
 Is a technique and at optimizing the way that the information stored and used with in an org.

You might also like