datamodel

vijaykumar · Post by **vijaykumar** » Wed Feb 21, 2007 5:00 pm

Hi Gurus,

Actually my team mates were asking me that besides two types of dimensional models like star schema and snowflake there is also another model, can gurus help me out .
I just want to analyze.

cheers;
Vijay

kumar_s · Post by **kumar_s** » Wed Feb 21, 2007 5:35 pm

Starflake Schema - Combination of Star and Snowflake.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 21, 2007 5:40 pm

There are those who advocate bolting a star schema logical design onto a third-normal-form (3NF) physical design. These are mainly vendors of 3NF database products who don't have a good star schema story.

Teradata is an interesting and performant hybrid.