OLAP
A workload style optimized for analytical queries that aggregate or scan large data sets across dimensions and time.
Data-System 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 Data-System Concepts
- OLTP
- Data Warehouse
- columnar storage
- partition pruning