Starflake Schema

Starflake = Snow + Snowflake

So how does this work? Some tables are normalized in detail, and some are denormalized.

If used correctly, Starflake schema can give the best of both worlds.

dim_store is normalized, whereas time is denormalized.

Time most of it is int so not much space is wasted and it helps in reducing query complexity.