Microsoft Azure Cosmos DB Revealed (eBook)

José Rolando Guay Paz is a professional developer with more than 20 years of experience in implementing database-backed applications. He was among the first in Central America to build commercial applications using Microsoft .NET. He has deep experience in Oracle Database and SQL Server, and he is an MCPD in ASP.NET 3.5/4.0, an MCSD in web applications, and an MCTS in SQL Server 2012/2014. José's native language is Spanish; he is fluent in English; and has learned some French. He holds a bachelor's degree in Computer Science, and a master’s degree in Finance.  

Table of Contents 5
About the Author 10
About the Technical Reviewer 11
Acknowledgments 12
Chapter 1: Introduction to Azure Cosmos DB 13
What Is Azure Cosmos DB? 14
Major Features 14
Turnkey Global Distribution 14
Multiple Data Models and APIs 15
Elastically Scale Throughput and Storage on Demand 15
High Availability and Response Time 16
Five Consistency Models 16
Setting Up the Development Environment 16
Installing Microsoft Visual Studio 16
Installing the Azure Cosmos DB Emulator 24
Creating a Microsoft Azure Account and Subscription 27
Provisioning an Azure Cosmos DB Database 33
Summary 35
Chapter 2: Learning Azure Cosmos DB Concepts 36
Understanding Global Distribution 36
Introducing Write and Read Regions 38
Understanding the Consistency Models 39
Scope of Consistency 40
Strong Consistency Model 41
Eventual Consistency Model 42
Bounded Staleness Consistency Model 43
Session Consistency Model 44
Consistent Prefix Consistency Model 44
Consistency for Queries 45
Understanding Partitioning 45
What Are Containers? 45
How Does Partitioning Work? 47
Designing for Partitioning 48
Boundary for Query and Transactions 48
No Storage and Performance Bottlenecks 48
Understanding Throughput 49
Specifying Request Unit Capacity 49
Estimating Throughput 50
Implementing Security 52
Encryption at Rest 52
Firewall Support 53
Securing Access to Data 55
Master Keys 55
Resource Tokens 56
Supported APIs 57
Azure Cosmos DB REST API 57
DocumentDB API 60
MongoDB API 62
Graph API 64
Table API 68
Summary 70
Chapter 3: Working with an Azure Cosmos DB Database 71
Creating Your Database 72
Defining the Document 79
Managing Documents 80
Using the Azure Cosmos DB Emulator to Manage Documents 81
Managing Documents with an Application 87
Creating the ASP.NET Web Application 87
Creating a Class for the Document 95
Creating the Data Layer 99
Querying the Database 107
Creating a Document 111
Replacing a Document 112
Deleting a Document 112
Using the Data Layer in the Controller and Completing the Application 113
Summary 132
Chapter 4: Importing Data into an Azure Cosmos DB Database 134
Introducing the DocumentDB Data Migration Tool 134
Software Requirements 135
Features of the DocumentDB Data Migration Tool 136
Installing the DocumentDB Data Migration Tool 137
Installing the DocumentDB Data Migration Tool from the Source Code 141
Importing Data with the DocumentDB Data Migration Tool GUI 149
Importing JSON Files 149
Importing from SQL Server 160
Importing from MongoDB 163
Importing Data with the DocumentDB Data Migration Tool Command Line Interface 165
Summary 166
Chapter 5: Querying an Azure Cosmos DB Database 168
Understanding Indexing 168
Understanding the Indexing Mode 171
Understanding Index Paths 172
Adjusting the Indexing Policy 174
Querying an Azure Cosmos DB Database 176
Learning the SELECT Statement 176
Understanding the SELECT Clause 178
Understanding the FROM Clause 180
Understanding the WHERE Clause 183
Understanding the ORDER BY Clause 185
Working with Iterations 186
Understanding Joins 188
Working with Parameterized SQL Queries 189
Using Built-In Functions 190
Extending the Sample Application 191
Implementing SQL Queries 202
Implementing Parameterized Queries 204
Implementing LINQ Queries 206
Summary 209
Chapter 6: Working with a  Globally Distributed Database 211
Configuring Global Distribution 211
Configuring Failover 216
Working with Manual Failover 216
Configuring Automatic Failover 217
Connecting to a Preferred Region 219
Implementing a Multi-Master Database 221
Application Scenario 221
Implementing the Solution 222
Summary 226
Chapter 7: Advanced Concepts 227
Working with Transactions 227
Implementing Stored Procedures 228
Creating a Stored Procedure 233
Creating a Stored Procedure in the Azure Portal 233
Creating a Stored Procedure Programmatically 234
Executing a Stored Procedure 237
Implementing Triggers 239
Creating a Trigger 242
Creating a Trigger in the Azure Portal 242
Creating a Trigger Programmatically 243
Implementing User-Defined Functions 245
Creating a UDF 246
Creating a UDF in the Azure Portal 246
Creating a UDF Programmatically 248
Using a UDF 249
Working with Dates 258
Backing Up and Restoring Azure Cosmos DB Databases 260
Backup Retention Policy 261
Restoring Databases 261
Summary 262
Index 263