SUP! Hubert’s Substack

SUP! Hubert’s Substack

One Big Table (OBT) vs Star Schema

Where do you execute the JOIN in real-time analytics?

Hubert Dulay's avatar
Hubert Dulay
Dec 20, 2023
∙ Paid

Two methodologies stand out when building an analytical data model: One Big Table (OBT) and Star Schema. Let’s quickly go over them.

What Is OBT?

"One Big Table" (OBT) is a database design approach in which all the data is stored in a large table. There are no relations between tables in this schema, and all the information is contained within a single st…

User's avatar

Continue reading this post for free, courtesy of Hubert Dulay.

Or purchase a paid subscription.
© 2026 Hubert Dulay · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for writing, podcasting, and media founders.