qStar
Schema
vThere will be a
centrally located fact table which is surrounded by one or many dimension
table. This design looks like a star so
its called as Star Schema
vDimensions in Star
Schema are De-normalized
vBenefit of star
schema is Query performance will be very high as there will not be joins and
only disadvantage is it requires more disk space
qSnowflakes
Schema
vThere will be a
centrally located fact table which is surrounded by one or many dimension table
and dimension table splitted into more than one
table
vDimensions in
Snowflakes Schema are Normalized(more joins)
vBenefit of snowflakes
schema is overcome disk space issues
No comments:
Post a Comment