Zhen Hua Liu
Abstract
Both RDBMS and NoSQL database vendors have added varying degrees of support for storing and processing JSON data. Some vendors store JSON directly as text while others add new JSON type systems backed by binary encoding formats. The latter option is increasingly popular as it enables richer type systems and efficient query processing. In this paper, we present our new native JSON datatype and how it is fully integrated with the Oracle Database ecosystem to transform Oracle Database into a mature platform for serving both SQL and NoSQL style access paradigms. We show how our uniquely designed Oracle Binary JSON format (OSON) is able to speed up both OLAP and OLTP workloads over JSON documents.
- A. Mishra, et al. Accelerating Analytics with Dynamic In-Memory Expressions. PVLDB 9(13), 1437--1448, 2016 Google Scholar
Digital Library
- BSON: http://bsonspec.org/Google Scholar
- Block Volume: https://docs.cloud.oracle.com/iaas/Content/Block/Concepts/overview.htmGoogle Scholar
- Couchbase JSON Support: https://developer.couchbase.com/documentation/server/3.x/developer/dev-guide-3.0/using-json-docs.htmlGoogle Scholar
- D. Tahara, et al: Sinew: a SQL system for multi-structured data. SIGMOD Conference 2014: 815--826 Google ScholarDigital Library
- DB2 JSON support: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/json/src/tpc/db2z_jsonfunctions.htmlGoogle Scholar
- EYCSB: https://blog.couchbase.com/ycsb-json-benchmarking-json-databases-by-extending-ycsb/Google Scholar
- Elastic Search API: https://www.elastic.co/guide/en/elasticsearch/reference/1.4/index.htmlGoogle Scholar
- Kian et al: "The SQL++ Query Language: Configurable, Unifying and Semi-structured". http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.690.8323Google Scholar
- Microsoft SQL Server JSON support: https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-2017Google Scholar
- MongoDB BSON and JSON : https://www.mongodb.com/json-and-bsonGoogle Scholar
- MySQL JSON DataType: https://dev.mysql.com/worklog/task/?id=8132Google Scholar
- N. Mukherjee, et al. Oracle SecureFiles System. PVLDB 1(2), 1301--1312, 2008 Google ScholarDigital Library
- Oracle Exadata Machine & Storage Server: http://www.oracle.com/us/products/database/exadata-tech-overview-wp-1867437.pdfGoogle Scholar
- PartiQL: https://partiql.org/Google Scholar
- PostgreSQL with JSON and JSONB support: https://www.postgresql.org/docs/9.4/datatype-json.htmlGoogle Scholar
- Regions and Availbility Domains https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htmGoogle Scholar
- S. Melnik, et al: Dremel: Interactive Analysis of Web-Scale Datasets. VLDB 3(1), 330--339, 2010 Google ScholarDigital Library
- SODA: Simple Oracle Document Access API: https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/index.htmlGoogle Scholar
- SQL NESTED Clause: https://docs.oracle.com/en/database/oracle/oracle-database/19/adjsn/function-JSON_TABLE.htmlGoogle Scholar
- SQL/JSON 2016 Standard: ISO/TEC TR 19075-6:2017, Information technology Part 6: SQL support for JavaScript Object Notation (JSON), http://standards.iso.org/ittf/PubliclyAvailableStandards/Google Scholar
- T. Lahiri, et al.: Oracle Database In-Memory: A dual format in-memory database. ICDE 2015: 1253--1258Google Scholar
- Teredata JSON Datatype: https://docs.teradata.com/reader/C8cVEJ54PO4~YXWXeXGvsA/4IAzgRsj_8aRj5pCQoEqzAGoogle Scholar
- UBJSON: http://ubjson.org/Google Scholar
- Virtual Machines: https://www.oracle.com/cloud/compute/virtual-machines.htmlGoogle Scholar
- Y. Li, et al: Mison. A Fast JSON Parser for Data Analytics. PVLDB 10(10): 1118--1129, 2017 Google ScholarDigital Library
- Z. Wang, et al: STEED: An Analytical Database System for TrEE-structured Data. PVLDB 10(12): 1897--1900, 2017 Google ScholarDigital Library
- Z.H. Liu, et al. Closing the functional and Performance Gap between SQL and NoSQL. SIGMOD Conference 2016, 227--238 Google ScholarDigital Library
- Z.H. Liu, et al. JSON data management: supporting schemaless development in RDBMS. SIGMOD Conference 2014, 1247--1258 2014 Google ScholarDigital Library
Recommendations
JSON: Data model, Query languages and Schema specification
PODS '17: Proceedings of the 36th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database SystemsDespite the fact that JSON is currently one of the most popular formats for exchanging data on the Web, there are very few studies on this topic and there is no agreement upon a theoretical framework for dealing with JSON. Therefore in this paper we ...
Foundations of JSON Schema
WWW '16: Proceedings of the 25th International Conference on World Wide WebJSON -- the most popular data format for sending API requests and responses -- is still lacking a standardized schema or meta-data definition that allows the developers to specify the structure of JSON documents. JSON Schema is an attempt to provide a ...
JSON data management: supporting schema-less development in RDBMS
SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of DataRelational Database Management Systems (RDBMS) have been very successful at managing structured data with well-defined schemas. Despite this, relational systems are generally not the first choice for management of data where schemas are not pre-defined ...
Comments