swecrets
Catalog

The Analytics Database Problem

Foundations

Establish why analytical and transactional databases diverged, and place ClickHouse in that landscape before touching a line of syntax.

What this module covers

  • OLTP vs. OLAP workload characteristics
  • Row-oriented storage
  • Columnar storage
  • Data warehouse
  • Data lake and lakehouse
  • The real-time OLAP category
  • ClickHouse's origin at Yandex
  • Vectorized execution (first mention)
  • OLAP vocabulary — throughput vs. latency, ingestion, cardinality, query engine

Lessons

  1. ✓1. The OLTP/OLAP Divide9 min
  2. ✓2. Row vs. Columnar Storage, From First Principles10 min
  3. ✓3. The Analytics Database Landscape: Warehouses, Lakehouses, Real-Time OLAP10 min
  4. ✓4. ClickHouse's Origins and Where It Fits11 min
  5. ✓5. Vocabulary of the OLAP World9 min