Star schema.

also: star schemas · fact table · fact tables · dimension table · dimension tables

A central fact table of measures (one row per event) with foreign keys to denormalised dimension tables you group and filter by.

the two-minute refresher

Fact table: revenue, quantity, discount, plus keys to dimensions.
Dimensions: product, customer, date, store, with descriptive attributes.
Drawn out, the fact table in the middle and dimensions around it look like a star.
Queries join the fact table to a few dimensions and aggregate.

also: star schemas · fact table · fact tables · dimension table · dimension tables

A central fact table of measures (one row per event) with foreign keys to denormalised dimension tables you group and filter by.

Fact table: revenue, quantity, discount, plus keys to dimensions.
Dimensions: product, customer, date, store, with descriptive attributes.
Drawn out, the fact table in the middle and dimensions around it look like a star.
Queries join the fact table to a few dimensions and aggregate.