Monday, June 28, 2010

Difference Between Star Schema and Snowflake Schema

Star Schema
Snowflake Schema
De-Normalized Data Structure
Normalized Data Structure
Category wise Single Dimension Table
Dimension table split into many pieces
More data dependency and redundancy
less data dependency and No redundancy
No need to use complicated join
Complicated Join
Query Results Faster
Some delay in Query Processing
No Parent Table
It May contain Parent Table
Simple DB Structure
Complicated DB Structure

1 comment:

  1. To learn .net, C#, Java, J2EE, Silverlight, Visual Basic, Asp .net with advanced concepts, you can visit