The Aggregation Layer Pattern

Build pre-aggregated tables to serve common reporting queries that do not require raw record access.