[Verse 1] Once upon a time we built our data neat and clean Star schema was the king, dimensions ruled the scene Fact tables in the center, dimensions all around But modern data's bigger now, new methods can be found [Chorus] One Big Table, everything's together OBT makes querying much better Activity schema tells a story Trade-offs matter, choose your glory Model data your way, your way Find the path that fits today [Verse 2] Traditional approach says normalize your design Break it down to pieces, make relationships align But joining takes forever when your dataset starts to grow Sometimes flat and simple is the better way to go [Chorus] One Big Table, everything's together OBT makes querying much better Activity schema tells a story Trade-offs matter, choose your glory Model data your way, your way Find the path that fits today [Verse 3] Activity schema thinks in terms of events and time Every action logged becomes a record in the line Who did what and when they did it, context all preserved Better for analytics when behavior patterns are observed [Bridge] Storage space versus query speed Flexibility versus what you need Dimensional modeling's still around But modern approaches break new ground [Chorus] One Big Table, everything's together OBT makes querying much better Activity schema tells a story Trade-offs matter, choose your glory Model data your way, your way Find the path that fits today [Outro] No single method rules them all Choose the right tool for your call Data modeling's evolved and grown Pick the approach to call your own
← Data Documentation and Lineage | Semantic Layers and Metrics →