Episode

Azure Cosmos DB Certification Study Hall Ep17: Design a data partitioning strategy

with Alex Mang, Mark Brown, Chris Hyde

Identify strategies for managing relationships between data entities, such as customers and sales data. Improve data-model performance and scaling by pre-aggregating and denormalizing your data. Use change-feed to maintain your data's referential integrity.

Learning objectives

  • Manage relationships between data entities by using advanced modeling and partitioning strategies.
  • Maintain the referential integrity of your data by using change feed.
  • Implement pre-aggregating and denormalizing data strategies to improve data-model performance and scaling.
  • Optimizing storage and compute by mixing entity types in a single container

Chapters

  • 00:00 - Welcome
  • 06:41 - Learning objectives​ and introduction
  • 25:57 - Denormalize data in your model​
  • 38:18 - Manage referential integrity by using change feed​
  • 40:53 - Combine multiple entities in the same container​
  • 47:16 - Denormalize aggregates in the same container​
  • 50:14 - Finalize the data model​
  • 54:53 - Exercise​: Exercise advanced modeling patterns​
  • 01:23:33 - Knowledge Check​
  • 01:27:01 - Summary​ and conclusion

Connect

Intermediate
Developer
Azure Cosmos DB