Skip to main content

Glossary

OLAP

Meaning and details

Columnar engines like ClickHouse and DuckDB are built for OLAP: aggregations over millions of rows in milliseconds, complementing row stores (Postgres, MySQL) that excel at transactions (OLTP).

OLAP meaning

Online Analytical Processing, querying large datasets for analytics instead of transactions.

What is OLAP?

Columnar engines like ClickHouse and DuckDB are built for OLAP: aggregations over millions of rows in milliseconds, complementing row stores (Postgres, MySQL) that excel at transactions (OLTP).

Keep exploring the glossary

Previous term OKR All terms Browse the full glossary Next term OLTP