What is the difference between star flake and snow flake schema?

Editorial / Best Answer

zahoorahmad  

  • Member Since Apr-2006 | Apr 12th, 2006


Star Schema:

Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.

SnowFlake:

Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.

Showing Answers 1 - 3 of 3 Answers

zahoorahmad

  • Apr 12th, 2006
 

Star Schema:

Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.

SnowFlake:

Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.

  Was this answer useful?  Yes

kalyan

  • May 1st, 2006
 

Star schema In the star schema design, a single object (the fact table) sits in the middle and is radically connected to other surrounding objects (dimension lookup tables) like a star. A star schema can be simple or complex. A simple star consists of one fact table; a complex star can have more than one fact table.Snowflake schema In this a Dimension can have multiple Levels within multiple Hierarchies. From each hierarchy of levels any one Level can be attached to Fact Table. Mostly Lowest Level is attached to Fact Table.

  Was this answer useful?  Yes

Wayne Renolds

  • Jul 25th, 2006
 

If someone asks about a star flake schema you will know they are not a data modeler since there is no such thing. There are star schemas, sno flake schemas and there are even data vaults but there is no star flake schema.

  Was this answer useful?  Yes

Ritu Khare

  • Nov 22nd, 2006
 

hi,

There does exist a concept of "Starflake" schema. Star flake schema is a hybrid structure ( star schema + snow flake schema).

It has basic structure of star schema but based on requirements certain dimensions are snowflaked i.d. normalized.

Hope this helps!

Ritu

  Was this answer useful?  Yes

Asher

  • Sep 30th, 2007
 

A Star flake is a hybrid of a Star and a Snowflake? No!

A Snowflake is a hybrid of a Star!

Everything that a star contains but dimension tables are normalized.



Wassim Saade

  • Nov 23rd, 2011
 

Star flake schema's are snowflake schema's where only some of the dimension tables have been denormalized.
Every star flake schema is also a snowflake schema.
Not every snowflake schema is a starflake schema.
A snowflake schema with all of its dimension tables normalized is not a starflake schema.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions