Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault)

Looking for help with your team's data strategy? → https://www.kahandatasolutions.com
Looking to improve your data engineering skillset?→ https://bit.ly/more-kds

Without 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 deeper into three of the most common examples which include:
1. Normalized
2. Star schema
3. 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.

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.

Thank you for watching!

Timestamps:
0:00 - Intro
1:02 - Normalized (Inmon)
1:37 - Star Schema (Kimball)
2:37 - Data Vault

Title & Tags:
Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault)
#kahandatasolutions #dataengineering #datamodeling