One Big Table & Wide-Table Design

The columnar-engine-native modeling style. When 200-column denormalized tables go from heresy to the right answer — and where OBT's quiet costs (update amplification, fan-out, governance) live.

The columnar-engine-native modeling style. When 200-column denormalized tables go from heresy to the right answer — and where OBT's quiet costs (update amplification, fan-out, governance) live.

Intermediate9 chapters· 1h 34m· in Semantic & Metrics Layer

Course content

  1. 01Lab SetupFree
  2. 02The Columnar Economics That Made OBT SaneFree
  3. 03OBT vs Star — A Real Benchmark🔒
  4. 04The Cost of OBT — Update Amplification🔒
  5. 05Hybrid Approaches — OBT on Top of a Star🔒
  6. 06OBT for ML Feature Stores🔒
  7. 07Schema Evolution in an OBT🔒
  8. 08OBT and Symmetric Aggregates🔒
  9. 09OBT in the BI Tool — Pre-Joined for Self-Serve🔒

Prerequisites

What to learn next

Read the first chapter free

Start reading now — no account required for the free chapters.