One Big Table (OBT) vs Star Schema
Where do you execute the JOIN in real-time analytics?
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…
Keep reading with a 7-day free trial
Subscribe to SUP! Hubert’s Substack to keep reading this post and get 7 days of free access to the full post archives.