Skip to content
BENIBIX Learn

One Big Table (OBT)

Data🗄️ Storage & WarehousingDimensional Modeling

Also known as Wide Table, Flat Wide Table

One wide table with all the details on each row. Queries need no joins.

Think of it like

It is like a lunchbox with the whole meal packed in. You do not visit five shops to eat.

Example

A sales table carries the store, customer and product names on each row. Anyone can sum sales by store with one short query.

Why it matters

Queries are simple and fast, and many BI tools work best on a single table. Columnar storage makes the repeated values cheap.

Definition

One big table is a warehouse design where the facts and all their details sit in one wide table. The joins to customer, product and date tables are done once, when the table is built. Queries then read one table with no joins. Names and labels repeat on every row, so it takes more space. Columnar storage keeps that cost low.
The joins of a star schema are done once, and queries read one wide table.

Common mistake

Forgetting to rebuild it when a detail changes. If a product is renamed, the old name stays on every row until the next build.

Key takeaways

  1. 1
    Join once. Joins happen when the table is built.
  2. 2
    Repeat details. Every row carries its names and labels.
  3. 3
    Rebuild to update. Changes show after the next build.

Compare