Query Engine Foundations
The theory layer of Strata 6 — Query Engines & OLAP. Execution models, MPP architecture, optimization, joins, and the engine-format contract. Engine-agnostic foundations that the rest of S6 (ClickHouse, Druid/Pinot, Trino, DuckDB) builds on.
Course content
- 01Compute vs Query EnginesFree
- 02The OLAP Workload Profile🔒
- 03The Volcano Model🔒
- 04Vectorized Execution🔒
- 05Push-Based & Morsel-Driven Execution🔒
- 06Codegen vs Vectorization🔒
- 07MPP Architecture🔒
- 08Exchange Operators🔒
- 09Query Planning 101🔒
- 10Rule-Based vs Cost-Based Optimization🔒
- 11Cardinality Estimation🔒
- 12Join Algorithms🔒
- 13Distributed Join Strategies🔒
- 14Runtime & Dynamic Filtering🔒
- 15Predicate & Projection Pushdown🔒
- 16Pipeline Breakers & Memory🔒
Read the first chapter free
Start reading now — no account required for the free chapters.