Slashdot Mirror

← Back to Stories (view on slashdot.org)

Unified NoSQL Query Language Launched

Posted by timothy on from the ontogeny-recapitulates-phylogeny dept.

splitenz writes "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 — .PS). It has Microsoft's backing."

4 of 194 comments (clear)

  1. Wrong link in the summery? by ggy · · Score: 4, Informative
    Hrm, if you read TFA you'll notice the part

    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.

    which funnily enough is linked in the summery.
    Maybe you should fix this to point to the actual link in TFA http://wwww.unqlspec.org/ ?

  2. Re:Can somebody explain NoSQLers to me? by Anonymous Coward · · Score: 5, Insightful

    Have you ever used a relational database?

    Every NoSQL approach, be it document-oriented, key-value storage, or the various hybrid approaches, can be very easily implemented using relational techniques. In fact, they are all just subsets of the relational model. Key-value storage is merely a two-column table, for instance.

    Basically every decent relational database system today allows you to easily partition your data in almost any way possible. It's trivial to store or replicate a single table's data cross hundreds, thousands, or even tens of thousands of storage and processing nodes.

    Relational databases work very well for storing hierarchical data, as well. Recursive common table expressions make it extremely easy to work with such data.

    There's just no reason to use a NoSQL database. Relational databases can do everything a NoSQL database can, and then a fuck of a lot more.

  3. Re:Can somebody explain NoSQLers to me? by Anonymous Coward · · Score: 4, Informative

    Try to read CJ Date work on relational theory and relational databases. Every single thing you say is wrong, I'm sorry to say that. Relational databases are not about "fixed column data models". It's not an ACID Excel. It's not about tables. It's about sets and how sets relates to it's members and to other sets. This includes hierarchical models, which are easily expressed in a RDBMS.

    Those who doesn't understand relational databases are bound to reinvent it, poorly.

  4. Re:Can somebody explain NoSQLers to me? by Joey+Vegetables · · Score: 5, Informative

    Developer and former DBA here. Yes, the relational model is more than capable of expressing hierarchical data. However, the SQL language, at least the subset common to most popular RDBMSs, doesn't grok hiearchical data very well. And that leads to a point Codd, Date and others make pretty much every day of their lives: Relational =! SQL. The relational model has elegance and power that can't be expressed in SQL, at least not easily. But many of those confronted with the shortcomings of SQL falsely assume these to be shortcomings of the relational model as well, which in most cases they are not.

    --

    Nonaggression works!