Page 1 of 1

datamodel

Posted: Wed Feb 21, 2007 5:00 pm
by vijaykumar
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

Posted: Wed Feb 21, 2007 5:35 pm
by kumar_s
Starflake Schema - Combination of Star and Snowflake.

Posted: Wed Feb 21, 2007 5:40 pm
by ray.wurlod
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.