Difference
Between Star Schema and Snowflake Schema
-
S.No Star SchemaSnowflake Schema1Data Structure:De-Normalized Data StructureData Structure:Normalized Data Structure2 Dimension:Category wise Single Dimension TableDimension:Dimension table split into many pieces3 Data dependency & redundancy:More data dependency and redundancyData dependency & redundancy:Less data dependency and No redundancy4 Join:No need to use complicated joinJoin:Complicated Join5 Query Result:Query Results FasterQuery Result:Some delay in Query Processing6 Parent Table:No Parent TableParent Table:It may contain Parent Table7 DB Structure:Simple DB StructureDB Structure:Complicated DB Structure8 Sample:Sample:
No comments:
Post a Comment