🗄️One Big Table (OBT)
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
Common mistake
Key takeaways
- 1Join once. Joins happen when the table is built.
- 2Repeat details. Every row carries its names and labels.
- 3Rebuild to update. Changes show after the next build.