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 |
Search this blog
Monday, June 28, 2010
Difference Between Star Schema and Snowflake Schema
Subscribe to:
Post Comments (Atom)
To learn .net, C#, Java, J2EE, Silverlight, Visual Basic, Asp .net with advanced concepts, you can visit http://advanceddotnettutorial.blogspot.com
ReplyDelete