{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,4]],"date-time":"2026-05-04T10:18:24Z","timestamp":1777889904774,"version":"3.51.4"},"reference-count":29,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2020,8]]},"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.14778\/3415478.3415534","type":"journal-article","created":{"date-parts":[[2020,9,14]],"date-time":"2020-09-14T18:46:35Z","timestamp":1600109195000},"page":"3059-3071","source":"Crossref","is-referenced-by-count":11,"title":["Native JSON datatype support"],"prefix":"10.14778","volume":"13","author":[{"given":"Zhen Hua","family":"Liu","sequence":"first","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Beda","family":"Hammerschmidt","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Doug","family":"McMahon","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hui","family":"Chang","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ying","family":"Lu","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Josh","family":"Spiegel","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Alfonso Colunga","family":"Sosa","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Srikrishnan","family":"Suresh","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Geeta","family":"Arora","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Vikas","family":"Arora","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2020,8]]},"reference":[{"issue":"13","key":"e_1_2_1_1_1","first-page":"1437","volume":"9","author":"Mishra A.","year":"2016","unstructured":"A. Mishra, et al. Accelerating Analytics with Dynamic In-Memory Expressions. PVLDB 9(13), 1437--1448, 2016","journal-title":"Accelerating Analytics with Dynamic In-Memory Expressions. PVLDB"},{"key":"e_1_2_1_2_1","unstructured":"BSON: http:\/\/bsonspec.org\/"},{"key":"e_1_2_1_3_1","unstructured":"Block Volume: https:\/\/docs.cloud.oracle.com\/iaas\/Content\/Block\/Concepts\/overview.htm"},{"key":"e_1_2_1_4_1","unstructured":"Couchbase JSON Support: https:\/\/developer.couchbase.com\/documentation\/server\/3.x\/developer\/dev-guide-3.0\/using-json-docs.html"},{"key":"e_1_2_1_5_1","volume-title":"SIGMOD Conference 2014:  815--826","author":"Tahara D.","unstructured":"D. Tahara, et al: Sinew: a SQL system for multi-structured data. SIGMOD Conference 2014: 815--826"},{"key":"e_1_2_1_6_1","unstructured":"DB2 JSON support: https:\/\/www.ibm.com\/support\/knowledgecenter\/en\/SSEPEK_11.0.0\/json\/src\/tpc\/db2z_jsonfunctions.html"},{"key":"e_1_2_1_7_1","unstructured":"EYCSB: https:\/\/blog.couchbase.com\/ycsb-json-benchmarking-json-databases-by-extending-ycsb\/"},{"key":"e_1_2_1_8_1","unstructured":"Elastic Search API: https:\/\/www.elastic.co\/guide\/en\/elasticsearch\/reference\/1.4\/index.html"},{"key":"e_1_2_1_9_1","unstructured":"Kian et al: \"The SQL++ Query Language: Configurable Unifying and Semi-structured\". http:\/\/citeseerx.ist.psu.edu\/viewdoc\/summary?doi=10.1.1.690.8323"},{"key":"e_1_2_1_10_1","unstructured":"Microsoft SQL Server JSON support: https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/json\/json-data-sql-server?view=sql-server-2017"},{"key":"e_1_2_1_11_1","unstructured":"MongoDB BSON and JSON : https:\/\/www.mongodb.com\/json-and-bson"},{"key":"e_1_2_1_12_1","unstructured":"MySQL JSON DataType: https:\/\/dev.mysql.com\/worklog\/task\/?id=8132"},{"issue":"2","key":"e_1_2_1_13_1","first-page":"1301","volume":"1","author":"Mukherjee N.","year":"2008","unstructured":"N. Mukherjee, et al. Oracle SecureFiles System. PVLDB 1(2), 1301--1312, 2008","journal-title":"Oracle SecureFiles System. PVLDB"},{"key":"e_1_2_1_14_1","unstructured":"Oracle Exadata Machine & Storage Server: http:\/\/www.oracle.com\/us\/products\/database\/exadata-tech-overview-wp-1867437.pdf"},{"key":"e_1_2_1_15_1","unstructured":"PartiQL: https:\/\/partiql.org\/"},{"key":"e_1_2_1_16_1","unstructured":"PostgreSQL with JSON and JSONB support: https:\/\/www.postgresql.org\/docs\/9.4\/datatype-json.html"},{"key":"e_1_2_1_17_1","unstructured":"Regions and Availbility Domains https:\/\/docs.cloud.oracle.com\/iaas\/Content\/General\/Concepts\/regions.htm"},{"issue":"1","key":"e_1_2_1_18_1","first-page":"330","volume":"3","author":"Melnik S.","year":"2010","unstructured":"S. Melnik, et al: Dremel: Interactive Analysis of Web-Scale Datasets. VLDB 3(1), 330--339, 2010","journal-title":"Interactive Analysis of Web-Scale Datasets. VLDB"},{"key":"e_1_2_1_19_1","unstructured":"SODA: Simple Oracle Document Access API: https:\/\/docs.oracle.com\/en\/database\/oracle\/simple-oracle-document-access\/index.html"},{"key":"e_1_2_1_20_1","unstructured":"SQL NESTED Clause: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/adjsn\/function-JSON_TABLE.html"},{"key":"e_1_2_1_21_1","volume-title":"2016 Standard: ISO\/TEC TR 19075-6:2017","unstructured":"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\/"},{"key":"e_1_2_1_22_1","volume-title":"ICDE 2015:  1253--1258","author":"Lahiri T.","unstructured":"T. Lahiri, et al.: Oracle Database In-Memory: A dual format in-memory database. ICDE 2015: 1253--1258"},{"key":"e_1_2_1_23_1","unstructured":"Teredata JSON Datatype: https:\/\/docs.teradata.com\/reader\/C8cVEJ54PO4~YXWXeXGvsA\/4IAzgRsj_8aRj5pCQoEqzA"},{"key":"e_1_2_1_24_1","unstructured":"UBJSON: http:\/\/ubjson.org\/"},{"key":"e_1_2_1_25_1","unstructured":"Virtual Machines: https:\/\/www.oracle.com\/cloud\/compute\/virtual-machines.html"},{"issue":"10","key":"e_1_2_1_26_1","first-page":"1118","volume":"10","author":"Li Y.","year":"2017","unstructured":"Y. Li, et al: Mison. A Fast JSON Parser for Data Analytics. PVLDB 10(10): 1118--1129, 2017","journal-title":"Mison. A Fast JSON Parser for Data Analytics. PVLDB"},{"issue":"12","key":"e_1_2_1_27_1","first-page":"1897","volume":"10","author":"Wang Z.","year":"2017","unstructured":"Z. Wang, et al: STEED: An Analytical Database System for TrEE-structured Data. PVLDB 10(12): 1897--1900, 2017","journal-title":"STEED: An Analytical Database System for TrEE-structured Data. PVLDB"},{"key":"e_1_2_1_28_1","volume-title":"SIGMOD Conference","author":"Liu Z.H.","year":"2016","unstructured":"Z.H. Liu, et al. Closing the functional and Performance Gap between SQL and NoSQL. SIGMOD Conference 2016, 227--238"},{"key":"e_1_2_1_29_1","volume-title":"SIGMOD Conference 2014","author":"Liu Z.H.","year":"2014","unstructured":"Z.H. Liu, et al. JSON data management: supporting schemaless development in RDBMS. SIGMOD Conference 2014, 1247--1258 2014"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3415478.3415534","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,17]],"date-time":"2025-09-17T02:32:19Z","timestamp":1758076339000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3415478.3415534"}},"subtitle":["maturing SQL and NoSQL convergence in Oracle database"],"short-title":[],"issued":{"date-parts":[[2020,8]]},"references-count":29,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2020,8]]}},"alternative-id":["10.14778\/3415478.3415534"],"URL":"https:\/\/doi.org\/10.14778\/3415478.3415534","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2020,8]]}}}