Star schema vs snowflake schema — how do you model a data warehouse?

Answer preview

A star schema has one central fact table of measurements surrounded by denormalized dimension tables, so any attribute is one join away. A snowflake schema is the same model with dimensions normalized into sub-dimensions, putting attributes two or more joins away.…