software

OLAP

Online Analytical Processing

Definition

OLAP is a category of database systems optimized for complex analytical queries over large datasets, supporting operations like slicing, dicing, drilling down, and aggregating data across multiple dimensions. Columnar storage formats (Parquet, ORC) and vectorized query execution are key technologies enabling OLAP performance.

Snowflake, BigQuery, and ClickHouse are modern OLAP systems.

Related Terms

OLTP

Online Transaction Processing

Data Warehouse

ETL

Extract, Transform, Load

← Back to Glossary

Ship secure code faster

Crash Override integrates security into the developer workflow. No context switching, no waiting on reviews.

Talk to a Human See the Product