Difference between star schema and snowflake schema

Difference Between Star Schema and Snowflake Schema

1. Difference Between Star Schema and Snowflake Schema
S.NoStar Schema Snowflake Schema
1 Data Structure:
De-Normalized Data Structure
Data Structure:
Normalized Data Structure
2 Dimension:
Category wise Single Dimension
Table
Dimension:
Dimension table split into many pieces
3 Data dependency &
redundancy:
More data dependency and
redundancy
Data dependency & redundancy:
Less data dependency and No
redundancy
4 Join:
No need to use complicated join
Join:
Complicated Join
5 Query Result:
Query Results Faster
Query Result:
Some delay in Query Processing
6 Parent Table:
No Parent Table
Parent Table:
It may contain Parent Table
7 DB Structure:
Simple DB Structure
DB Structure:
Complicated DB Structure
8 Sample:
http://blog-
mstechnology.blogspot.in/2010/06
/bi-dimensional-model-star-
schema.html
Sample:
http://blog-
mstechnology.blogspot.in/2010/06/bi-
dimensional-model-snowflake-
schema.html
And, further updates on difference between questions and answers, please visit my blog @
http://onlydifferencefaqs.blogspot.in/