Abstract

JSON (JavaScript Object Notation) has become popular as the data exchange format over the Web. Recently, JSON has been gaining more popularity over XML due to its simplicity and ability to fit into the programming languages’ data types. At the beginning, JSON data have been stored by document store systems. Since the publication of the SQL/JSON specification in the SQL standard, several relational database vendors have integrated the support of JSON in their database systems. In this paper we compare two forms of storing JSON data into relational tables in respect to data load time and disk space usage. Our experimental results show that the native (binary) storage form occupies approximately 56% of disk space needed for the row storage form. Also, the former outperforms the latter in relation to data loading time.

References

• ISO/IEC TR 9075-6:2017 Information technology, DB languages: SQL Technical Reports Support for JavaScript Object Notation, http://standards.iso.org/ ittf/PubliclyAvailableStandards/index.html .
• Petković, D. SQL/JSON Standard: Properties and Deficiencies. Datenbank Spektrum 17, 277–287 (2017). https://doi.org/10.1007/s13222-017-0267-4 .
• Piech,M., Marcjan,R., A New Approach to Storing Dynamic Data in Relational Databases Using JSON, Computer Science, 19(1) (2018), https://doi.org/10.7494/csci.2018.19.1.2505 .
• Bahta,R., Atay,M., Translating JSON data into relational data using schema-oblivious approaches, ACM Southeast Conference, Kennesaw, USA, 2019, https://doi.org/10.1145/3299815.3314467.
• Petković, D. Non-native Techniques for Storing JSON Documents into Relational Tables, Proc. of the 22nd Int. Conf. on Information Integration and Web-based Appl. & Services, 2020, https://doi.org/10.1145/3428757.3429103.
• Liu, Z.H., Hammerschmidt, B., McMahon, D., Chang, H., Native JSON Datatype Support: Maturing SQL and NoSQL Convergence in Oracle Database, Proc. Of the VLDB Endovment, Vol. 13(12), 2020, https://doi.org/10.14778/3415478.3415534.
• Atay,M., Chebotko, A., Liu, D., Lu, S., Fotouhi, F., Efficient Schema-based XML-to-Relational data mapping. Information Systems Journal 32 (3), 2007, https://doi.org/10.1016/j.is.2005.12.008.
• Shanmugasundaram, J. et al., Relational Databases for Querying XML Documents: Limitations and Opportunities, VLDB, 1999, pp. 302–314, Edinburgh.
• Lee, D. Chu, W., Constraints-preserving Transformation from XML Document Type Definition to Relational Schema, ER, Salt Lake City, USA 2000.
• Florescu, D., Kossmann,D., Storing and Querying XML Data Using an RDBMS, IEEE Data Eng. Bull. 22 (3) (1999), pp. 27–34.
• Yoshikawa, M., Amagasa, T., Shimura, T., Uemura, S., XRel: A Path-Based Approach to Storage and Retrieval of XML Documents using Relational Databases. ACM Trans. on Internet Technology, 2001, https://doi.org/10.1145/383034.383038.
• Petković, D., Storing XML documents in databases using existing object-relational features, - Proc. of the Fifth Balkan Conference in Informatics, 2012, https://doi.org/10.1145/2371316.2371373 .
• Zip Code Data Sample, https://catalog.data.gov/dataset/cadastral-plss-standardized-data-plssspecialsurvey-se-version-1,last accessed2023/05/01