> For the complete documentation index, see [llms.txt](https://gchandra.gitbook.io/data-warehousing/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gchandra.gitbook.io/data-warehousing/data-warehousing-concepts/dimensional-modelling/starflake-schema.md).

# 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.

<figure><img src="https://2629735788-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3G2NQEHaUSzehWzaKvXK%2Fuploads%2F42GfMoUVAjpu0dec4tU3%2Fdw_starflake_schema_01.png?alt=media&amp;token=c15cbc21-4855-42a8-826e-b5d571cabc01" alt=""><figcaption></figcaption></figure>