Star schema.
also: star schemas · fact table · fact tables · dimension table · dimension tablesA 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.