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
- Slides: 34