Dimensional modelling

Organising a warehouse around measurable events and the things that describe them, rather than around the shape of the source application. The point is that analysts write joins by hand under time pressure, so the schema is a user interface: predictable shapes beat clever ones. It has survived every generation of storage technology because the constraint it addresses — a human holding a query in their head — has not changed.