Glossary

ClickHouse

A columnar OLAP database for fast analytics over billions of rows.

1 min read·4 sections
Open the interactive version → diagrams, practice & more

Definition

A columnar OLAP database for fast analytics over billions of rows.

How it works

Stores data by column + compresses heavily, so aggregations are orders of magnitude faster than a row store.

Common questions

What is ClickHouse?

A columnar OLAP database for fast analytics over billions of rows.

How does ClickHouse work?

Stores data by column + compresses heavily, so aggregations are orders of magnitude faster than a row store.

What is ClickHouse used for in system design?

Stores data by column + compresses heavily, so aggregations are orders of magnitude faster than a row store.

Part of Glossary on SystemLore — system design explained with 148 deep topics, interactive diagrams, and a build-it-yourself game. Build this one →