CoursesChallenges

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.

Intermediate8 chapters· 1h 28m· in Semantic & Metrics Layer

Course content

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

Prerequisites

↗Dimensional Modeling Fundamentals

What to learn next

↗Choosing a Modeling Style· next

Read the first chapter free

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

Start: The Columnar Economics That Made OBT Sane →More in Semantic & Metrics Layer