|
Star schema
|
Snowflake Schema
|
|
1.
De-Normalized Data Structure
2.
Category wise Single Dimension Table
3.
More data dependency and redundancy
4.
No need to use complicated join
5.
Query Results Faster
6.
No Parent Table
7.
Simple DB Structure
|
1.
Normalized Data Structure
2.
Dimension table split into many pieces
3.
less data dependency and No redundancy
4.
Complicated Join
5.
Some delay in Query Processing
6.
It May contain Parent Table
7.
Complicated DB Structure
|
Sunday 22 April 2012
Difference Between Star schema and Snowflake Schema
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment