Azure Cosmos DB with SQL API Net SDK

Azure Cosmos DB with SQL API. Net SDK Bhavna Mangal

History 2010 Project Florence 2015 Document. DB 2017 Azure Cosmos DB @bhavna_mangal | Bhavna_Mangal@yahoo. com

Azure Cosmos DB No. SQL Multiple Data Models Horizontal Partitioning Turnkey Global Distribution Scaling on Demand Complete Indexing @bhavna_mangal | Bhavna_Mangal@yahoo. com

Cosmos DB by Industries @bhavna_mangal | Bhavna_Mangal@yahoo. com

Guaranteed Low Latency Reads (1 KB) Indexed Writes (1 KB) 50 th < 2 ms < 6 ms 99 th < 10 ms @bhavna_mangal | Bhavna_Mangal@yahoo. com

Supported Programming Languages JS C# Java. Script Node. js Python @bhavna_mangal | Bhavna_Mangal@yahoo. com Mongo. DB Client Drivers

Architecture Azure Cosmos DB Account Database Container Partition Item Item @bhavna_mangal | Bhavna_Mangal@yahoo. com Item Container

Resources Relationships @bhavna_mangal | Bhavna_Mangal@yahoo. com

Horizontal Partitioning Required for More than 10 GB Partition Key, Document Id Combination Unique @bhavna_mangal | Bhavna_Mangal@yahoo. com One Partition per Partition Key

@bhavna_mangal | Bhavna_Mangal@yahoo. com

Five Consistency Models and Usage Dirty Order P P P Strong Bounded-stateless Session Client Usage 4% 18% P P P Consistent prefix Eventual 73% 2% Higher Availability, Lower Latency, Weaker Consistency @bhavna_mangal | Bhavna_Mangal@yahoo. com 3%

Turnkey Global Distribution @bhavna_mangal | Bhavna_Mangal@yahoo. com

Automatic Failover u v w @bhavna_mangal | Bhavna_Mangal@yahoo. com

Manual Failover u v w @bhavna_mangal | Bhavna_Mangal@yahoo. com

Define and Save Document ID JSON Single Document OR Single Record Properties User Defined, System Generated @bhavna_mangal | Bhavna_Mangal@yahoo. com User Defined, Auto Generated GUID

With Id Before After @bhavna_mangal | Bhavna_Mangal@yahoo. com

Without Id Before After @bhavna_mangal | Bhavna_Mangal@yahoo. com

Unique Combination of Id and Partition Key @bhavna_mangal | Bhavna_Mangal@yahoo. com

Query @bhavna_mangal | Bhavna_Mangal@yahoo. com

Server Side Code @bhavna_mangal | Bhavna_Mangal@yahoo. com

Server Side Code Runs Inside Cosmos DB Stored Procedures, User Defined Functions, Triggers Java. Script Functions Read Write By Partition Key @bhavna_mangal | Bhavna_Mangal@yahoo. com Call from Other Programs C#, Java, Python

@bhavna_mangal | Bhavna_Mangal@yahoo. com

Azure Cosmos DB Emulator Desktop app @bhavna_mangal | Bhavna_Mangal@yahoo. com

Cosmos DB Emulator Desktop App Free Tool Local Machine No Internet Same Functionality as Portal @bhavna_mangal | Bhavna_Mangal@yahoo. com No Azure Subscription

Bhavna Mangal | Bhavna_Mangal@yahoo. com

Document. DB Data Migration Tool @bhavna_mangal | Bhavna_Mangal@yahoo. com

@bhavna_mangal | Bhavna_Mangal@yahoo. com

Cosmos DB Explorer in Public View @bhavna_mangal | Bhavna_Mangal@yahoo. com

u v w @bhavna_mangal | Bhavna_Mangal@yahoo. com

Microsoft Azure Storage Explorer @bhavna_mangal | Bhavna_Mangal@yahoo. com

@bhavna_mangal | Bhavna_Mangal@yahoo. com

Resources • ‘Microsoft Azure Cosmos DB Revealed: A Multi-Model Database Designed for the Cloud’ Jose Rolando Guay Paz • Pluralsight Course ‘Learning Azure Cosmos DB’ by Leonard Lobel • cosmos. azure. com • azure. microsoft. com/en-us/blog/new-azure-cosmosdbexplorer-now-in-public-preview/ • documentdb. com/capacityplanner @bhavna_mangal | Bhavna_Mangal@yahoo. com

Thank You! @bhavna_mangal Mangal_Bhavna@yahoo. com linkedin. com/in/bhavna-mangal