0 votes
by (98.9k points)
What are the key differences between a star schema and a snowflake schema in data modeling

1 Answer

0 votes
by (98.9k points)
Best answer
Aspect Star Schema Snowflake Schema
Structure Central fact table surrounded by dimension tables. Dimension tables are further normalized into sub-dimensions or sub-levels.
Data Redundancy Dimension tables often contain some data redundancy (denormalized). Dimension tables are more normalized, resulting in less data redundancy.
Complexity Generally simpler and easier to understand due to fewer tables and relationships. More complex due to additional sub-dimensions and relationships, potentially more tables.
Storage Space May require more storage space due to data redundancy. Requires less storage space compared to star schema due to normalization.
Query Performance Often offers better query performance, as denormalized tables reduce the need for joins. Query performance may be slightly impacted due to the need for more joins.

Related questions

0 votes
1 answer 35 views
0 votes
1 answer 43 views
0 votes
1 answer 39 views
0 votes
0 answers 29 views
+1 vote
0 answers 32 views

Doubtly is an online community for engineering students, offering:

  • Free viva questions PDFs
  • Previous year question papers (PYQs)
  • Academic doubt solutions
  • Expert-guided solutions

Get the pro version for free by logging in!

5.7k questions

5.1k answers


504 users