- Demo / Walkthrough
- NoSQL database service in Azure.
- Gen. available on April 8.
- Fully managed by Azure -
no VM needed.
- Stores data as BSON in "documents" within document collections.
- Allows SQL-esque queries.
BSON = an optimized binary representation of JSON.
"Sounds like MongoDB."
Yes, they are both NoSQL databases
that store data in a
schemaless BSON format.
Other examples: CouchBase / Couch DB, DynamoDB (AWS)
How they are different:
DocumentDB is a service that is fully managed by Azure.
MongoDB is an application that runs in a machine.
- No schemas!
(Flexible Data Models)
- Elastic Scaling
- Big Data
- No need for DBAs (but...)
- No schemas!
(No Data Integrity)
- Expertise / Learning Curve
- Analytics and BI
DocumentDB vs. SQL Server in particular
and NoSQL databases vs. RMDBSs in general
- 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?
"Monsters Masters & Mobsters"
A roleplaying/monster competition game
hosted in Azure using DocumentDB.
- Open database in Azure portal.
- Document Explorer.
- Query Explorer.
SELECT m.id, m.name FROM monsters m WHERE m.level = 5
Write SQL-esque queries against document collections.
By Jay Bienvenu