Data modeling & partitioning: What every relational database dev needs to know (Ignite 2019)

In this 2019 Ignite session (BRK3015) Thomas Weiss walks through how to take a relational data model and transform it into an efficient and high-performance NoSQL database model. If you are new to NoSQL database development, this session is for you.

#azurecosmosdb #azure #nosql #cloud

Overview of Azure Cosmos DB: 1:11
E-Commerce data modeling example 4:39
Embed or reference? 7:27
What is partitioning? 9:23
Choosing a partition key 14:34
Denormalizing data 25:08
Final design 40:18
Key takeaways 41:17

Additional resources:

[mohammedsafiahmed]

What an excellent video. The first Microsoft employee that I've come across that didn't define cosmos DB in marketing terms, and instead said what it actually is; a no SQL database on Azure.
The rest of the presentation was fantastic as well.

[AnugrahGupta]

One of the best videos about Cosmos DB! Not just sales pitch, but the real use cases.

[valkarynvoyages]

Best explanation of applying partition keys and how it impacts RUs I have watched - and I have watched quite a few here and on PluralSight. I finally feel like I understand these areas fully and can move ahead with refactoring my SQL project.

[bestrobin]

Loved your explanations on everything! Cosmos DB will be my first DB to work with, and I am even more excited after watching this video!

[joychakraborty]

Probably the best video out in internet on real time example

[solaivel]

Crystal clear explanation. It helped me on Document DB Design.

[venkatesansrinivasan]

Lovely explanation on Cosmos DB Design. Thanks bro!

[chandrag]

Excellent video...really helped me in a design work

[kamathsutra]

So every time there is a query requirement, you denormalise and store that value in the document? How is that scalable :/

[aaronbcj]

Can a logical partition span across more than one physical server ?

[sphxcyprex]

A logical partition can max 20GB not 10 GB

[AyanMullick]

I thought that with persistent memory technology there would be a cosmos database SKU to put the entire database in memory so one doesn’t need to do all this complicated modeling.