0

632views

Differentiate between Star Schema and Snowflake Schema.

written 2.5 years ago by pradnyanabar2613 ★ 5.2k

modified 2.5 years ago by DevarenjiniP • 3.2k

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

0

18views

written 2.5 years ago by DevarenjiniP • 3.2k

Parameter	Star Schema	Snow Flake Schema
Hierarchies	Hierarchies for the dimensions are stored in the dimensional table.	Hierarchies are divided into separate tables.
Structure	It contains a fact table surrounded by dimension tables.	One fact table surrounded by dimension table which are in turn surrounded by dimension table
Join	Inastar schema, only single join creates the relationship between the fact table and any dimension tables.	A snowflake schema requires many joins to fetch the data.
DB Design	Simple DB Design.	Very Complex DB Design.
Normalization	Denormalized Data structure and query alsorun faster.	Normalized Data Structure.
Data Redundancy	High level of Data redundancy	Very low-level data redundancy
Dimensions	Offers higher performing queries using StarJoin Query Optimization. Tables may be connected with multiple dimensions.	The Snow Flake Schema is represented by centralized fact table which unlikely connected with multiple dimensions.

ADD COMMENT SHARE EDIT