Sign In Start Free Trial

Guide to NoSQL with Azure Cosmos DB

By : Gaston C. Hillar, Daron Yöndem

4 (1)

Guide to NoSQL with Azure Cosmos DB

4 (1)

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.

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

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

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

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

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

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

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

Customer Reviews

4 (1)

5 star

0

4 star

100%

3 star

0

2 star

0

1 star

0

What this book covers

Chapter 1, Introduction to NoSQL in Cosmos DB, introduces you to the features of Cosmos DB and the NoSQL data model. You will also learn about the different elements of the Cosmos DB resource model, which will allow you to have a clear understanding of how to work with this database service.

Chapter 2, Getting Started with Cosmos DB Development and NoSQL Document Databases, will teach you how to provision a Cosmos DB account that uses the SQL API, and you will start working with a document database, along with its collections and documents. You will use the web-based Azure portal and work with Azure Cosmos DB Explorer.

Chapter 3, Writing and Running Queries on NoSQL Document Databases, will have you writing and running queries to retrieve data from the documents in a collection. You will learn how to use the Cosmos DB dialect of SQL to work against a document database with the SQL API. Most importantly, you will understand the different ways of working with documents, their sub-documents, and their arrays, and you will learn about how queries consume resource units.

Chapter 4, Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API, will get you using Cosmos DB, the .NET Core SDK, the SQL API, and C# to code our first Cosmos DB application. The main focus will be on learning about many important aspects related to the SDK, as well as how to easily build a first version of the application we'll be working with.

Chapter 5, Working with POCOs, LINQ, and a NoSQL Document Database, will keep you working with the .NET Core SDK, but this time, you will work with POCOs and LINQ queries. You will take advantage of the strongly typed features of C# and the functional programming features that LINQ provides for working with Cosmos DB.

Chapter 6, Tuning and Managing Scalability with Cosmos DB, explores aspects that will enable you to design and maintain scalable architectures with Cosmos DB. You will use the sample application you will have built to understand complex topics related to scalability.

Search

Your notes and bookmarks