#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!
Access More Free Training
There's only so much that can be covered in a single article or video.
But if you'd like to go deeper, come check out The Modern Data Community (it's free).
Inside, you'll get access to free training such as Modern Data Essentials, The Starter Guide for Modern Data and more.
Plus connect directly with Michael Kahan and other Engineers around the world building modern data architectures.
Click the button below to learn more.