MICROSOFT AZURE

DOCUMENTDBThe JSON database for rapid developmentBy: Mohamed Elkhodary

WHAT IS DOCUMENT DATABASE? Definition

WHAT IS A DOCUMENT DATABASE?

WHAT IS A DOCUMENT DATABASE?o Growth with the use of the term NoSQL itself.o Designed for storing, retrieving, and managing document-oriented information.o Get their type information from the data itself, normally store all related information together, and allow every instance of data to be different from any other. o Attractive for programming modern web applications, which are subject to continual change in place, and speed of deployment is an important issue.

WHAT IS A DOCUMENT DATABASE?

Come as you are

Data normalizationORM

WHAT IS A DOCUMENT DATABASE?

WHY USING DOCUMENTDB? Why it is different?

WHY?

WHY?

WHY?

WHY?

WHY?

WHY?

WHY?

fully managed, scalable, queryable, schemafree JSON document database service for modern applications

fully featured RDBMStransactional processing

rich query managed as a service

elastic scale

internet accessible http/rest

schema-free data model

arbitrary data formats

WHY?

WHY?Fully-managed, highly-scalable, NoSQL document database service

query over schema-free

JSON

multi-documenttransactions

tunable, high performance

fully managed and designed for

massive scale

JS{ }SQL

WHY?o Promotes code first development.o Resilient to iterative schema changes.o Provide rich queries.o Low impedance as object/JSON store. No ORM required.o It just works.o It is fast.

USING DOCUMENTDB More details

DOCUMENTDB RESOURCES

{ “id” : “123” “name” : “joe” “age” : 30 “address” : { “street” : “some st” }}

SO COLLECTION IS A TABLE?

COLLECTION IS NOT A TABLE

SCALE UP VS SCALE OUT Scale Up – add bigger resources Scale Out – add more of the same

SCALING UP WITH DOCUMENTDB

Choose the kind of collection you want based on your throughput needs

10GB

1000 RU/sec

S2

$0.067/hour~ $50 per

month

10GB

250 RU/sec

$0.034/hour~ $25 per

month

S1

10GB

2,500 RU/sec

$0.134/hour~ $100 per

month

S3

LET’S GET STARTED Using Azure Portal and .NET SDK

USING AZURE PORTALo Create DocumentDB database account.o Add, edit and delete documents.o Query documents.o Explore Query Playground.

USING .NET SDKo Add, edit, query and delete documents.

Thank you