| 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