OLAP.
also: OLTP · OLTP vs OLAP · online analytical processing · online transaction processingOLTP runs the business (many small row reads and writes); OLAP understands it (few big queries over many rows and few columns).
the two-minute refresher
- OLTP: 'get order #12345', normalised, row-oriented, optimised for writes.
- OLAP: 'revenue by month for 2024', denormalised, column-oriented, optimised for reads.
- Don't run heavy analytics on the OLTP primary: copy the data to an OLAP store.