Thursday, October 01, 2015

Azure DocumentDB: NoSQL + SQL

Azure DocumentDB is a NoSQL database, but it could be used accessed by SQL...

SQL Queries on a DocumentDB Database – Query SQL | Microsoft Azure
"Microsoft Azure DocumentDB supports querying documents using SQL (Structured Query Language) over hierarchical JSON documents. DocumentDB is truly schema-free. By virtue of its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
While designing the query language for DocumentDB we had two goals in mind:

  • Embrace SQL... DocumentDB SQL provides a formal programming model for rich queries over JSON documents.
  • Extend SQL – As a JSON document database capable of executing JavaScript directly in the database engine, we wanted to use JavaScript's programming model as the foundation for our query language..."
mentioned in podcast: 

Azure Storage - Secure cloud storage | Microsoft Azure.

DocumentDB vs Azure SQL vs Azure Table