CouchBase, SQLite launch unified NoSQL query language

The newly launched UnQL NoSQL query language has gotten the backing of Microsoft

Hoping to unify the growing but disparate market of NoSQL databases, the creators behind CouchDB and SQLite have introduced a new query language for the format, called UnQL (Unstructured Data Query Language).

"The impetus for UnQL is to create some form of commonality among non-SQL databases," said James Phillips, a co-founder and vice president of products for Couchbase, which oversees the document-oriented CouchDB database.

UnQL, pronounced "Uncle," could be considered a "superset" of the SQL syntax, Phillips said. It can parse all statements formulated in the SQL language and supports a number of new operators and expressions as well.

If adopted by other vendors, UnQL could do for the NoSQL market what SQL did for the relational database market 40 years ago, namely provide a portable common interface to unify an otherwise fragmented market of database offerings, Phillips said.

"UnQL was built to be a very portable, multi-vendor implement-able language standard," Phillips said. "So certainly MongoDB, Cassandra and any other vendors supporting unstructured data in distributed databases will find a clear path of implementation."

The use of NoSQL databases has grown dramatically in the past few years as consumer-focused Web service providers and other purveyors of large datasets sought to distribute their data across multiple servers, a task that requires considerable effort to manage using traditional SQL-based databases.

While NoSQL databases such as Cassandra and CouchDB offer an alternative way to rapidly store and access data across multiple servers, each database offers its own unique interface, which limits the ability for organizations to use multiple databases interchangeably or to switch among databases while maintaining the same skillsets and query code.

All SQL-based relational databases more or less follow a standard format, one that allows for both portability and ensures predictable query results. Data is organized into columns and rows, which were themselves organized into tables defined by a SQL schema.

In contrast, NoSQL databases typically do not have pre-defined schemas. In order to be queried, all the values in a NoSQL deployment must be self-describing, meaning each data value must be accompanied by a name that categorizes that data. "The schema rides along with the data itself," Phillips said.

UnQL was designed to offer a single interface for a wide range of underlying database architectures, both SQL and NoSQL in nature.

"The syntax diagram to UnQL will look very, very familiar to SQL developers," Phillips said. "There are additional statements and operators, and the expression statements one can create can be extended to dig into complex documents." The developers have promised to post the complete syntax on the UnQL site.

CouchDB mastermind Damien Katz and SQLite inventor Richard Hipp created UnQL, following the general guidelines set forth by Microsoft researchers in a paper published earlier this year in the Association for Computing Machinery's flagship publication, Communications. The Microsoft researchers subsequently lent a hand in the development of UnQL, Phillips said.

Like SQL, UnQL was built on the foundation of relational algebra, Phillips said. This foundation should provide assurance that using the language will produce predictable and repeatable results. The Microsoft researchers "proved you can create a co-variant relationship between the SQL relationship and a language that looks like UnQL," Phillips said.

Following the model used for SQLite, the UnQL specification has been released in the public domain, with no accompanying license. "It is open for anyone to come in and participate," Phillips said.

CouchDB, SQLite and Microsoft are shepherding the project and are inviting other parties to participate. "We're not trying to drive some sort of heavyweight process," Phillips said. Future versions of both CouchDB and SQLite will support UnQL queries, their creators promise.

This version of UnQL has no relation to an identically named unstructured data query language proposed by a University of Pennsylvania researcher over a decade ago, Phillips said.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags open sourcedatabasessoftwareapplicationsCouchBase

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Father’s Day Gift Guide

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

Louise Coady

Brother MFC-L9570CDW Multifunction Printer

The printer was convenient, produced clear and vibrant images and was very easy to use

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?