#051: Comparing 3 Types of Data Modeling
Sep 13, 2023Without a solid data modeling approach, most architectures fall apart.
And in a previous video I broke down five of the most common data modeling strategies you'll see in a modern stack.
But today we'll look at little more into three of the most common examples which include:
- Normalized
- Star schema
- Data Vault
But rather than going deep into code, instead we'll review some images (that I found in a simple Google search) of what some example table/relationship designs can look like in each approach.
It's nothing crazy and just a quick overview. But my hope is by giving this level of example will help get the point across a little better and clear up any gaps that you may be having after watching the last video.
What will you learn?
- Example designs of Normalized & Star Schema
- Subtle differences between each approach
- Why DataVault tends to be most helpful for logging
Enjoy!
Looking for more? Here are 2 other ways I can help you:
1. Simple Stack Academy: Join 100+ students in an end-to-end, project-based training. Simple Stack Academy teaches you a 5-Step Framework to design, build & automate reliable end-to-end data architectures using modern tools like dbt & Github. Ideal for both data engineers looking to advance their careers and data team leaders looking for a clear strategy to follow.
2. Consulting Services: Get personalized support to properly implement a well-structured, scalable, and maintainable data architecture at your company. Whether starting from scratch or migrating a legacy design, you'll get custom support each step of the way to make sure it's done right.