9.08.2012

Star Schema vs Snowflake Schema

Difference Between Star Schema and Snowflake Schema

S.No
Star 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:
Sample:

No comments:

Post a Comment