Comparision of JSON Data Types across Database Products

As per https://www.simple-talk.com/blogs/2016/04/21/json-rise/?utm_content=31572759&utm_medium=social&utm_source=twitter

JSON is on the rise, so here is an initial comparision of JSON data types across data products, more to follow

SQL Server

SQL Server 2016 preview – No native JSON data type, NVARCHAR used instead, no indexing

AZURE SQL DB

https://azure.microsoft.com/en-us/blog/json-functionalities-in-azure-sql-database-public-preview/

Postgres

JSON/JSONB data types

Waiting for 9.4 – Introduce jsonb, a structured format for storing json.

JSONB “Insignificant whitespace is discarded, and the order of object keys is not
preserved. Neither are duplicate object keys kept – the later value for a given
key is the only one stored.”

MongoDB

JSON / BSON data types

Informix

Native JSON/BSON data types, indexing supported, JSON sharding across a cluster of data servers supported.Wire listener supported for Mongo DB applications to talk to Informix via MongoDB community drivers and the REST API.

JSON/BSON data types

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1770.htm?lang=en

Indexing a BSON field

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_2342.htm?lang=en

BSON processing functions

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_2313.htm%23ids_sqs_2313?lang=en

JSON data sharding

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.json.doc/ids_json_011.htm?lang=en

Wire listener which handles Mongo API wire protocol

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.json.doc/ids_json_007.htm?lang=en

 

Advertisement

---