{"id":4245,"date":"2022-05-18T11:32:49","date_gmt":"2022-05-18T18:32:49","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=4245"},"modified":"2022-05-18T14:22:14","modified_gmt":"2022-05-18T21:22:14","slug":"cosmos-db-live-tv-episode-43-data-modeling-for-azure-cosmos-db-for-relational-mind","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/cosmos-db-live-tv-episode-43-data-modeling-for-azure-cosmos-db-for-relational-mind\/","title":{"rendered":"Azure Cosmos DB Live TV Episode 43 – Data Modeling for the Relational Mind"},"content":{"rendered":"

Azure Cosmos DB Live TV returns with episode 43, where Principal Program Manager, Mark Brown<\/a> and Microsoft MVP Sarah Dutkiewicz<\/a> showcase how the relational mind can into the nonrelational side by looking at the differences in data modeling. They will walk through a common scenario and how relational modeling differs from modeling for document storage and graph databases.<\/p>\n

Data Modeling<\/h3>\n

Microsoft defines data modeling as the process of analyzing and defining all the different data your business collects and produces, as well as the relationships between those bits of data. The process of modeling your data creates a visual representation of data as it\u2019s used at your business, and the process itself is a critical exercise in understanding and clarifying your data requirements.<\/p>\n

There are typically three different types of data models used: Conceptual, Logical, and Physical. Conceptual Data Modeling is used for organizing business concepts and defining the overall structure of your business and data. Logical Data Modeling builds on the conceptual model with specific attributes of data within each entity and particular relationships between those attributes. Lastly, the Physical Data Model is the implementation of the Logical model and is developed for a specific database tool, data storage technology, and data connectors to serve the data throughout your business systems to users as needed.<\/p>\n

While schemaless databases, like Azure Cosmos DB, make it super easy to store and query unstructured and semi-structured data, you should spend some time thinking about which data model to get most of the service in terms of performance and scalability, and lowest cost. Some critical questions to ask yourself when devising a NoSQL data model include:<\/p>\n