Book Image

Guide to NoSQL with Azure Cosmos DB

By : Gaston C. Hillar, Daron Yöndem
Book Image

Guide to NoSQL with Azure Cosmos DB

By: Gaston C. Hillar, Daron Yöndem

Overview of this book

Cosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. This book starts off by showing you the main features of Cosmos DB, their supported NoSQL data models and the foundations of its scalable and distributed architecture. You will learn to work with the latest available tools that simplify your tasks with Cosmos DB and reduce development costs, such as the Data Explorer in the Azure portal, Microsoft Azure Storage Explorer, and the Cosmos DB Emulator. Next, move on to working with databases and document collections. We will use the tools to run schema agnostic queries against collections with the Cosmos DB SQL dialect and understand their results. Then, we will create a first version of an application that uses the latest .NET Core SDK to interact with Cosmos DB. Next, we will create a second version of the application that will take advantage of important features that the combination of C# and the .NET Core SDK provides, such as POCOs and LINQ queries. By the end of the book, you will be able to build an application that works with a Cosmos DB NoSQL document database with C#, the .NET Core SDK, LINQ, and JSON.

Related Content you might be interested in

Current Title:

Small book image
Guide to NoSQL with Azure Cosmos DB
Gaston C. Hillar | Daron Yöndem
Sep, 2018 | 214 pages
Small book image
Learning Azure Cosmos DB
Shahid Shaikh
May, 2018 | 168 pages
Small book image
A Developer's Guide to .NET in Azure
Tamir Al Balkhi | Anuraj Parameswaran
Oct, 2023 | 504 pages
Small book image
A Developer's Guide to Building Resilient Cloud Applications with Azure
Hamida Rebai Trabelsi
Feb, 2023 | 296 pages
Table of Contents (13 chapters)
Title Page
Title Page
Packt Upsell
Packt Upsell
Contributors
Contributors
Preface
Preface
Free Chapter
1
Introduction to NoSQL in Cosmos DB
Introduction to NoSQL in Cosmos DB
Making the paradigm shift to the NoSQL way
Learning about the main features of Cosmos DB
Understanding the supported NoSQL data models
Using the appropriate API for each data model
Diving deep into the Cosmos DB resource model
Understanding the system topology NoSQL
Learning about the resource hierarchy for each container
Test your knowledge
Summary
2
Getting Started with Cosmos DB Development and NoSQL Document Databases
Getting Started with Cosmos DB Development and NoSQL Document Databases
Provisioning a Cosmos DB account that uses the SQL API
Understanding URIs, read-write and read-only keys, and connection strings
Creating a new document database with the SQL API
Creating a new collection
Populating a collection with documents
Understanding automatically generated key-value pairs
Understanding schema-agnostic features
Working with the web-based Azure Cosmos DB Explorer
Using Azure Storage Explorer to interact with Cosmos DB databases
Working with the Azure Cosmos DB Emulator
Test your knowledge
Summary
3
Writing and Running Queries on NoSQL Document Databases
Writing and Running Queries on NoSQL Document Databases
Running queries against a collection with different tools
Understanding query results in JSON arrays
Checking the request units spent by a query
Working with schema-agnostic queries
Using built-in array functions
Working with joins
Using array iteration
Working with aggregate functions
Test your knowledge
Summary
4
Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API
Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API
Understanding the requirements for the first version of an application
Understanding the main classes of the Cosmos DB SDK for .NET Core
Creating a .NET Core 2 application to interact with Cosmos DB
Configuring a Cosmos DB client
Creating or retrieving a document database
Querying and creating document collections
Retrieving a document with an asynchronous query
Inserting documents that represent competitions
Calculating a cross-partition aggregate with an asynchronous query
Reading and updating an existing document with a dynamic object
Querying documents in multiple partitions
Calling asynchronous methods that create and query dynamic documents
 Test your knowledge
Summary
5
Working with POCOs, LINQ, and a NoSQL Document Database
Working with POCOs, LINQ, and a NoSQL Document Database
Creating models and customizing serialization
Retrieving a POCO with a LINQ asynchronous query
Inserting POCOs
Calculating a cross-partition aggregate with an asynchronous LINQ query
Reading and updating an existing document with a POCO
Querying documents in multiple partitions with LINQ
Writing LINQ queries that perform operations on arrays
Calling asynchronous methods that use POCOs to create and query documents
Inspecting the SQL API queries that LINQ generates
Test your knowledge
Summary
6
Tuning and Managing Scalability with Cosmos DB
Tuning and Managing Scalability with Cosmos DB
Understanding request units and how they affect billing
Dynamically adjusting throughput for a collection with the Azure portal
Working with client-side throughput management
Understanding rate limiting and throttling
Tracking consumed request units with client-side code
Understanding the options for provisioning request units
Learning portioning strategies
Deploying to multiple regions
Understanding the five consistency levels
Taking advantage of regional failover
Understanding indexing in Cosmos DB
Checking indexing policies for a collection with the Azure portal
Test your knowledge
Summary
Answers
Answers
Chapter 1: Introduction to NoSQL in Cosmos DB
Chapter 2: Getting Started with Cosmos DB Development and NoSQL Document Databases
Chapter 3: Writing and Running Queries on NoSQL Document Databases
Chapter 4: Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API
Chapter 5: Working with POCOs, LINQ, and a NoSQL Document Database
Chapter 6: Tuning and Managing Scalability with Cosmos DB
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think
Index
Index

Understanding schema-agnostic features

Now we will add another document to the same collection. In this case, the new document will have new keys that didn't exist in the previously inserted document.

Create a new JSON file with the following contents in your favorite text editor and save it in a temporary folder as videogame1_02.json. The following lines show the code that defines a new game with its tags, levels, high score achievements, and prizes. The code file for the sample is included in the learning_cosmos_db_02_01 folder in the videogames/videogame1_02.json file:

{ 
    "id": "2", 
    "name": "Fortnite vs Zombies", 
    "lastCompetitionDate": "2018-09-30T03:31:20.7251173Z", 
    "tags": [ 
        "3D", "battle royale", "monsters", "shooter" 
    ], 
    "platforms": [ 
        "PS4", "XBox", "PC", "Switch", "iPad", "iPhone", "Android" 
    ], 
    "levels": [ 
        { 
            "title": "Dancing in the storm", 
            "maximumPlayers": 50, 
            "minimumExperienceLevel...
Previous Section
End of Section 8
Next Section