Journal: IPSI Transactions on Internet Research


An analysis of using binary JSON versus native JSON
On the example of Oracle DBMS

Authors: Bjeladinović, Srđa Asanović, Marko
Škembarević, Milica and Jejić, Olga


View PDF Cite this article

Abstract

JSON is a popular and proven standard for specifying self-describing text files with a flexible structure. To maintain its position in the market, Oracle introduced support for JSON data in the 12c R1 version of its DBMS. This version has introduced functions for storing and managing JSON data in native form but also showed some limitations. Each new version introduced new or updated JSON functions. The 21c can store JSON data in binary form, provides more straightforward syntax and even supports JSON as a predefined data type. The paper aims to compare the performance when the underlying storage of JSON is native or binary. A data model and seven use cases were designed to demonstrate earlier and new functionalities. Additionally, experiments showed the impact of JSON data stored in native (19c and 21c) and binary form (21c) on the average execution time and costs of SQL statements.


Keywords

JSON, Oracle, relational DBMS


Published in: IPSI Transaction on Internet Research (Volume: 19, Issue: 2)
Publisher: IPSI, Belgrade

Date of Publication: July 1, 2023

Open Access: CC-BY-NC-ND
DOI: 10.58245/ipsi.tir.2302.10

Pages: 92 - 103

ISSN: 1820 - 4503



References

1. JsonOrg, 2021. Introduction to JSON., Accessed: March 2023, Available: https://www.json.org/json-en.html.

2. Bjeladinović, S., Babarogić, S., Marjanović, Z., "Comparison of relational and NoSQL systems", FON, Belgrade, Serbia, XIII International Symposium SymOrg 2012, June 5-9., ISBN: 978-86-7680-255- 5, pp. 974-980, 2012.

3. Bjeladinovic, S., "A fresh approach for hybrid SQL/NoSQL database design based on data structuredness". Taylor and Francis, Enterprise Information Systems, vol. 12, no. 8–9, pp. 1202–1220, 2018., doi: 10.1080/17517575.2018.1446102.

4. Solid IT, 2023. DB-engines ranking., Accessed: March 2023, Available: https://dbengines.com/en/ranking.

5. MongoDb, Accessed: March 2023, Available: https://www.mongodb.com/json-and-bson.

6. Boicea, A., Radulescu, F., & Agapin, L. I., "MongoDB vs Oracle--database comparison", third international conference on emerging intelligent data and web technologies (pp. 330-335). IEEE, 2012.

7. Deari, R., Zenuni, X., Ajdari, J., Ismaili, F., & Raufi, B., "Analysis and comparison of document-based databases with SQL relational databases: MongoDB vs MySQL" In Proceedings of the International Conference on Information Technologies (pp. 1-10), 2018.

8. Bahta, R., & Atay, M., "Translating JSON data into relational data using schema-oblivious approaches", ACM Southeast Conference (pp. 233-236), 2019.

9. Irshad, L., Yan, L., & Ma, Z., "Schema-based JSON data stores in relational databases", Journal of Database Management (JDM), 30(3), 38-70., 2019.

10. Zhen Hua Liu, Beda Hammerschmidt, and Doug McMahon. "JSON data management: supporting schema-less development in RDBMS", Association for Computing Machinery, New York, NY, USA, International Conference on Management of Data (SIGMOD '14), June 22-27., pp. 1247–1258., 2014

...

×

Bjeladinović, Srđa

University of Belgrade, Faculty of Organizational Science, Belgrade, Serbia.
Corresponding author: email: srdja.bjeladinovic@fon.bg.ac.rs; ORCID: 0000-0001-6404-3497

×

Asanović, Marko

Adriatic University Bar, Faculty for Traffic, Communication, and Logistics, Budva, Montenegro.
e-mail: asanovicmarko@live.com;

× Škembarević, Milica

University of Belgrade, Faculty of Organizational Science, Belgrade, Serbia.
e-mail: milica.skembarevic@fon.bg.ac.rs; ORCID: 0000-0003-0649-3005

×

Jejić, Olga

University of Belgrade, Faculty of Organizational Sciences, Belgrade, Serbia.
email: olga.jejic@fon.ac.rs; Orcid ID: 0000-0002-6594-6388

×

Cite this article

Bjeladinović, Srđa; Asanović, Marko; Škembarević, Milica; and Jejić, Olga
"An analysis of using binary JSON versus native JSON on the example of Oracle DBMS",
IPSI Transactions on Internet Research, vol. 19(2), pp. 92-103, 2023. https://doi.org/10.58245/ipsi.tir.2302.10