"Nesting performs a join across two buckets. But instead of producing a cross-product of the left and right hand inputs, a single result is produced for each left hand input, while the corresponding right hand inputs are collected into an array and nested as a single array-valued field in the result object."
Couchbase Query Language, known as N1QL and pronounced "Nickel", is a query language for finding data in Couchbase Server. N1QL is designed to be human readable and writable. It is a language designed for ad-hoc querying. The query language is a standard semantic used to build querying ability in other databases.
DB2 NoSQL JSON enables developers to write applications using a popular JSON-oriented query language created by MongoDB to interact with data stored in IBM DB2 for Linux, UNIX, and Windows. This driver-based solution embraces the flexibility of the JSON data representation within the context of a RDBMS, which provides established enterprise features and quality of service.
The MySQL Cluster team are working on a new NoSQL JavaScript connector for MySQL. The objectives are simplicity and high performance for JavaScript users:
- allows end-to-end JavaScript development, from the browser to the server and now to the world's most popular open source database
- native "NoSQL" access to the storage layer without going first through SQL transformations and parsing.