JSON: SQL++ vs SQL:2016

Comparing Two SQL-Based Approaches For Querying JSON: SQL++ and SQL:2016

Cover

In this whitepaper, Don Chamberlin (co-designer of the original SQL) compares SQL++ and SQL:2016 – two quite different SQL-based approaches to querying JSON data. SQL++ creates a new SQL-based language specifically for JSON data, while 2016 allows JSON documents to be stored in columns of tables.

The paper introduces both languages, looks at example queries written in each, and analyzes their pros and cons. You’ll learn how SQL++ can enable you to: 

  • Use your existing SQL skills with a more flexible data format
  • Shorten your queries by about 3x compared with SQL:2016
  • Operate on JSON data without converting it to or from relational data
Vendor:
Couchbase
Posted:
30 Oct 2019
Published:
30 Oct 2019
Format:
PDF
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!