SQLBits 2019
Modeling data and best practices for Azure Cosmos DBs SQL API
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing
For many newcomers to Azure Cosmos DB's SQL API, the learning process starts with how to model and partition data effectively. How should I think about modeling data in Cosmos DB? When should I co-locate data in single collection verses multiple collections? When should I de-normalize or normalize properties in the same document vs multiple documents? How should I apply a partition key to this object model? In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing.
Speakers
Theodorus Leonardus van Kraay's previous sessions
How to design and build AI applications with vector search using Azure OpenAI & Azure Cosmos DB
TBA
How to build HTAP workloads using Azure Cosmos DB and Azure Synapse Link
We will go step-by-step on how to configure Synapse Link for Azure Cosmos DB and show off the features that allow users to build dashboards as well as do analytics on their operational data.
Modeling data and best practices for Azure Cosmos DBs SQL API
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing