The Star Schema, Explained

The dimensional-modeling pattern behind most data warehouses - one fact table surrounded by dimension tables - and why it's shaped that way on purpose.

1. Facts vs. dimensions
2. Why it's shaped like a star
3. Star vs. snowflake, and when to use it