Couchbase Announces N1QL, SQL-based Query Language For JSON-based NoSQL

This week, Couchbase announced the availability of N1QL (pronounced “nickel”), a “breakthrough query language” that delivers the capabilities of SQL alongside the Couchbase NoSQL database platform. Developers can use N1QL to perform queries on data stored and aggregated within the Couchbase NoSQL platform to facilitate the development of data-driven applications that leverage the data modeling and massive scalability of Couchbase’s JSON-based NoSQL platform. Given the ability of NoSQL to respond to the contemporary need to store massive amounts of data that defies classification into rigidly defined schemas, N1QL gives developers enhanced flexibility regarding the querying of semi-structured and unstructured data. Moreover, N1QL enables organizations to take advantage of the highly mature skillsets of SQL-trained developers in addition to the venerable ecosystem of SQL-compliant tools and products. N1QL conforms to a specification developed by UCSD for a SQL-compliant language that can perform queries on semi-structured data. As such, N1QL stands poised to accelerate NoSQL adoption by empowering developers to bring the familiarity of JOINS and NEST operators to JSON documents. N1QL takes its place within an emerging landscape of SQL-compliant platforms for NoSQL that affirm the enduring supremacy of SQL’s querying ability as well the criticality of developing sophisticated querying functionality for JSON-based NoSQL data stores. Leading technology vendors such as Informatica, Metanautix and Tableau have partnered with Couchbase to develop connectors that take advantage of N1QL’s unique querying functionality. Meanwhile, N1QL represents a key component of what’s new in Couchbase Server 4.0.


IBM’s Acquisition of Cloudant And The Walmart Effect In Tech

Last week, IBM announced an agreement to acquire NoSQL database as a service vendor Cloudant for an undisclosed sum. An active contributor to the Apache CouchDB project, Cloudant delivers a JSON document database-based platform that claims high availability, scalability and elasticity amongst its attributes. Cloudant customers can take advantage of its JSON-based database as a service to store and mine structured and unstructured data from a variety of sources. Because the JSON database format is so widely used by developers of mobile and web applications, IBM’s acquisition of Cloudant stands to strengthen its positioning with respect to the development of applications for mobile devices in conjunction with the build out of its OpenStack-based cloud solution for the enterprise. The acquisition of Cloudant will be central to IBM’s MobileFirst solutions as well as its Worklight application for developing mobile applications. From an industry perspective, the acquisition represents a huge coup for the NoSQL space in general. CouchDB has historically not had the traction of MongoDB, Cassandra and Couchbase, so we should expect brand name tech companies to make similar offerings for the likes of MongoDB in the ensuing few months. Moreover, IBM’s acquisition of Cloudant testifies to the increasing emergence of cloud and big data behemoths with solutions for both hosting infrastructure, as well as database solutions that accommodate enterprise needs for scalability and the ability to store unstructured data. Cloudant CEO Derek Schoettle surmised the significance of Cloudant’s contribution to IBM’s SoftLayer cloud platform as follows:

Cloudant’s decision to join IBM highlights that the next wave of enterprise technology innovation has moved beyond infrastructure and is now happening at the data layer. Our relationship with IBM and SoftLayer has evolved significantly in recent years, with more connected devices generating data at an unprecedented rate. Cloudant’s NoSQL expertise, combined with IBM’s enterprise reliability and resources, adds data layer services to the IBM portfolio that others can’t match.

Schoettle notes that IBM is extending its infrastructure innovations to the “data layer” and as such, follows in the footsteps of Amazon Web Services and EMC/VMware spin-off Pivotal, which similarly deliver a combination of cloud and big data solutions in their platform and product offerings. The notable consequence of this convergence of cloud and big data product offerings is that only large enterprises with the requisite capital and resources can afford to cobble together combined cloud-big data product offerings. As a result, cloud startups and smaller data vendors will need to continue to compete by way of their agility, responsiveness, consultative support and superior technology. In effect, the IBM acquisition of Cloudant signals a Walmart effect in technology, of sorts, whereby large, well capitalized vendors have the ability to create marts of diverse data and analytics products that threaten the viability of cloud, big data and analytics startups in the same way that massive retailers such as Walmart threaten the viability of independent stores or small chains. Oracle’s recent acquisition of Blue Kai, a big data management platform geared toward marketing, constitutes another example of the way in which tech giants are continuing to integrate diverse data products into increasingly heterogeneous product portfolios. The question that remains unanswered, however, is whether the emerging Walmart technology maze is sufficiently easy to navigate that enterprises opt to partner either with one vendor for all of their technology needs, or whether they feel more comfortable shopping from a diverse range of technology vendors in order to avoid vendor lock-in and locate products that richly respond to the specificities of their industry-vertical and customer needs.