• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2631
  • Last Modified:

Difference between star schema and snow flake schema design?

Hi Can anyone tell me the difference between star schema and snow flake schema design and if appropriate which is applicable with Data warehousing?

Cheers
0
ac_davis2002
Asked:
ac_davis2002
  • 4
  • 3
1 Solution
 
isaackhaziCommented:
Snowflake schema architecture is a more complex variation of a star schema design. The main difference is that dimensional tables in a snowflake schema are normalized, so they have a typical relational database design.

Snowflake schemas are generally used when a dimensional table becomes very big and when a star schema cant represent the complexity of a data structure. For example if a PRODUCT dimension table contains millions of rows, the use of snowflake schemas should significantly improve performance by moving out some data to other table (with BRANDS for instance).

The problem is that the more normalized the dimension table is, the more complicated SQL joins must be issued to query them. This is because in order for a query to be answered, many tables need to be joined and aggregates generated.
0
 
isaackhaziCommented:
0
 
ac_davis2002Author Commented:
That...is brillent thanks for you help. The perfect level of detail.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
isaackhaziCommented:
Always ready to help......

Cheers,
0
 
ac_davis2002Author Commented:
I am going to raise another question about a beginners guide to data warehouse design if you are interested.

Cheers
0
 
isaackhaziCommented:
I recommend closing this question and opening another one........
0
 
ac_davis2002Author Commented:
1st class
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now