Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault)
Want to build a reliable, modern data architecture without the mess?
Here’s a free checklist to help you → https://bit.ly/kds-checklist
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
Watch video Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault) online without registration, duration hours minute second in high quality. This video was added by user Kahan Data Solutions 24 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 33,440 once and liked it 586 people.