Back to Search Start Over

Native JSON datatype support

Authors :
Alfonso Colunga Sosa
Arora Geeta
Josh Spiegel
Hui Chang
Srikrishnan Suresh
Zhen Hua Liu
Doug McMahon
Ying Lu
Vikas Arora
Beda Hammerschmidt
Source :
Proceedings of the VLDB Endowment. 13:3059-3071
Publication Year :
2020
Publisher :
Association for Computing Machinery (ACM), 2020.

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.

Details

ISSN :
21508097
Volume :
13
Database :
OpenAIRE
Journal :
Proceedings of the VLDB Endowment
Accession number :
edsair.doi...........2a51bf9b777d232cb80de4ff07427156
Full Text :
https://doi.org/10.14778/3415478.3415534