DocumentDB

The NoSQL Database
that's made for Azure

Jay Bienvenu

bienv.com - @jbnv

Baton Rouge .Net Users Group

May 13, 2015

Resources

documentdb.com
bienv.com/topic:documentdb
bienv.com/topic:nosql

Agenda

• Overview
• Demo / Walkthrough
• Questions

DocumentDB

• NoSQL database service in Azure.
• Gen. available on April 8.
• Designed from scratch to support JSON and JavaScript directly inside the database engine.
• Fully managed by Azure -
  no VM needed.
• Stores data as BSON in "documents" within document collections.
• Allows SQL-esque queries.

"Sounds like MongoDB."

• No schemas!
  (Flexible Data Models)
• Elastic Scaling
• Big Data
• No need for DBAs (but...)

• No schemas!
  (No Data Integrity)
• Expertise / Learning Curve
• Maturity
• Support
• Analytics and BI

Tech Republic: 10 Things You Should Know About NoSQL DBs

DocumentDB vs. SQL Server in particular
and NoSQL databases vs. RMDBSs in general

Takeaways

• MS is serious about having both SQL and NoSQL in Azure.
• The learning curve will flatten as more MS developers use NoSQL and develop tools to work with it.
• Because DocumentDB is a MS product, open-source concerns go away.
• Will the MS developer community embrace it?

Is DocumentDB right for my project?

• Is NoSQL the best choice for my database?
• Can I live with the concerns about data integrity and security?
• Is it worth it to learn how to develop for a new database?

Demo

The project:

"Monsters Masters & Mobsters"

A roleplaying/monster competition game

hosted in Azure using DocumentDB.

monmamo.wikidot.com

• Open database in Azure portal.
• Document Explorer.
• Query Explorer.

SELECT m.id, m.name FROM monsters m WHERE m.level = 5

Pages: Azure Portal - server.js - data.js - Monster