Measures Concepts
GitHub icon

UnQL

UnQL - Query language

< >

UnQL, aka Unstructured Query Language, is a query language created in 2011 by Richard Hipp and Damien Katz.

#3043on PLDB 13Years Old

UnQL is a database query language, akin to SQL, but designed for modern document-oriented databases. SQL assumes a rigidly defined data schema. Each table has a fixed number of columns and each column has a defined datatype. UnQL assumes a more flexible approach to storing data. Instead of "tables", UnQL uses "collections". (The concept is the same, but the name is changed since "tables" are square whereas "collections" can be of varying shape.) Each collection consists of zero or more documents represented as JSON strings. A document in UnQL corresponds to a row in SQL


Example from the web:
SELECT {articleout:cool_nosql_collection.docNumber} FROM cool_nosql_collection

View source

- Build the next great programming language Search Add Language Features Creators Resources About Blog Acknowledgements Queries Stats Sponsor Day 605 feedback@pldb.io Logout