Question:
Differences between star and snowflake schemas
Answer:
Star schema
A single fact table with N number of Dimension
Snowflake schema
Any dimensions with extended dimensions are know as snowflake schema
Source: CoolInterview.com
star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema. Source: CoolInterview.com
Answered by: harinathreddy | Date: 11/20/2007
| Contact harinathreddy
star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema. Source: CoolInterview.com
Answered by: harinathreddy | Date: 11/20/2007
| Contact harinathreddy
star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
Star Schema: can have less number of joins.
Snow flake: can have more number of joins.
Star Schema : has data redundancy, so the query performace is good.
Snow flake: is normalized, so does not has data redundancey. can have perfomance issues. Source: CoolInterview.com
Answered by: vijay | Date: 10/8/2009
| Contact vijay
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|