AnalysisArticle written by Philip Howard, Data Management Bloor
Couchbase has introduced N1QL (pronounced “nickel”). This is, in effect, SQL for JSON and it is mostly SQL 92 compliant. Not entirely of course, because it lacks table expressions (there are no tables) and because it also adds new syntax, specifically NEST and UNNEST. This is what the company has called it N1QL because the N1 refers to “not first normal form” – in other words, nested structures (documents) are supported. One notable feature of N1QL is that it supports joins.
Also just announced, Neo4j is open sourcing its Cypher language (the OpenCypher project) with a view to it becoming the standard declarative language for graph databases.Read the full article here