Cosmos DB Modeling Methodology

on YouTube ↗25m

" summary

Methodology converts a 300+ table legacy e commerce schema into Cosmos DB by mapping DDD aggregates to containers and then optimizing for queries and partitions. It uses SQL API document models, follows rules like each aggregate → one container and anchor primary key as partition key, maps non‑root entities to distinct document types, embeds value objects unless they change or are many, uses a dedicated dictionary container, references across aggregates, duplicates orders into accounts to avoid cross‑partition queries and tunes indexes and partition sizes.

AI-written summary · about

" chapters (11)

1. 0:00Intro
2. 0:58Importance of modeling in NoSQL
3. 2:02Case study: legacy e-commerce platform migration challenge Scaling issues related to support bigger number of Relational Tables simultaneous users from around the globe
4. 4:41Methodology inspiration
5. 7:04The methodology: executive summary
6. 11:51Case study: application flow
7. 15:04Case study: DDD aggregates
8. 16:23Data realities & queries statistics
9. 17:49Mapping rules. Part 3
10. 20:22Case study: logical data model
11. 23:32Case study: physical optimization

" related talks

• 01h 03mData Modeling and Partitioning in Azure Cosmos DBMark Brown · NDC Oslo 2021
• 01h 00mAzure Cosmos DB : A brief Note for DevelopersDebasis Saha · Global Azure Virtual 2021
• 48mJSON Data ModelingMatthew Groves · Devnexus 2023
• 13mHow to do Data Modeling for Distributed Postgres in Azure Cosmos DBSai Krishna Srirampur · Azure Cosmos DB: Liftoff 2022
• 57mCosmosDB 101: Basics and quickstartSantosh Hari · Update Conference Prague 2018
• 01h 01mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Minnesota 2018
• 50mAzure Cosmos DB - Technical Deep DiveIgor De-Paula · NoSQL Conference 2018
• 01h 02mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Oslo 2018