OLAP
A workload style optimized for analytical queries that aggregate or scan large data sets across dimensions and time.
Technical Context
OLAP favors scan throughput, columnar layouts, partition pruning, compression, pre-aggregation, and parallel execution. It has different latency and consistency expectations from OLTP, so forcing both workloads onto the same physical design often creates interference.
Related Concepts
- OLTP
- Data Warehouse
- columnar storage
- partition pruning