CODEWITHSUNDEEP
data-warehousestar-schemasnowflake-schema
AdrianAndrews
AdrianAndrews

Reputation: 33

Data Warehousing - Snowflake Schema Normalization

To start, I am trying to differentiate from Star Schema and Snowflake Schema by illustrating them. But am having trouble trying to normalizing the table to create the snowflake schema. The attached image is the Star Schema enter image description here

I tried creating another dim table for dimcustomer, but am not sure what I could name the table. Please, any help would be appreciated.

Snowflake Schema enter image description here

Upvotes: 0

Views: 601

Answers (1)

RADO
RADO

Reputation: 8148

Your star schema is good, don't normilize it into a snowflake schema.

This is a typical mistake made by people with strong background in relational databases. They often perceive denormalized dimensions as "inefficient" and try to "fix" them by normalizing. What they miss is that dimensional models and OLTP databases have different efficiency criteria (query speed vs storage efficiency).

Snowflake schema is usually non-necessary and counter-productive. It will complicate your design and negatively impact your model performance. Practically speaking, I only use snowflake structure when I have to share a dimension between fact tables with different granularities.

Upvotes: 1

Related Questions