zahoorahmad

 Profile Answers by 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.

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.

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.

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

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.

rameshpossible

 Profile Answers by rameshpossible 

• Oct 1st, 2007

 

Nice answer

karpuni

 Profile Answers by karpuni 

• Jul 24th, 2008

 

Star schema - normalized one snow flake-denormalized

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.