以Oracle DBMS为例，分析使用二进制JSON与本机JSON的对比

IF 0.4 Q4 COMPUTER SCIENCE, INFORMATION SYSTEMS

IPSI BgD Transactions on Internet Research Pub Date : 2023-07-01 DOI:10.58245/ipsi.tir.2302.10

Srđa Bjeladinović, Milica Škembarević, Olga Jejic, Marko Asanović,

{"title":"以Oracle DBMS为例，分析使用二进制JSON与本机JSON的对比","authors":"Srđa Bjeladinović, Milica Škembarević, Olga Jejic, Marko Asanović,","doi":"10.58245/ipsi.tir.2302.10","DOIUrl":null,"url":null,"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.","PeriodicalId":41192,"journal":{"name":"IPSI BgD Transactions on Internet Research","volume":"39 1","pages":""},"PeriodicalIF":0.4000,"publicationDate":"2023-07-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"An analysis of using binary JSON versus native JSON on the example of Oracle DBMS\",\"authors\":\"Srđa Bjeladinović, Milica Škembarević, Olga Jejic, Marko Asanović,\",\"doi\":\"10.58245/ipsi.tir.2302.10\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":41192,\"journal\":{\"name\":\"IPSI BgD Transactions on Internet Research\",\"volume\":\"39 1\",\"pages\":\"\"},\"PeriodicalIF\":0.4000,\"publicationDate\":\"2023-07-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"IPSI BgD Transactions on Internet Research\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.58245/ipsi.tir.2302.10\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q4\",\"JCRName\":\"COMPUTER SCIENCE, INFORMATION SYSTEMS\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"IPSI BgD Transactions on Internet Research","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.58245/ipsi.tir.2302.10","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q4","JCRName":"COMPUTER SCIENCE, INFORMATION SYSTEMS","Score":null,"Total":0}

引用次数: 0

摘要

JSON是一种流行且经过验证的标准，用于指定具有灵活结构的自描述文本文件。为了保持其在市场上的地位，Oracle在其DBMS的12c R1版本中引入了对JSON数据的支持。这个版本引入了以本机形式存储和管理JSON数据的函数，但也有一些限制。每个新版本都引入了新的或更新的JSON函数。21c可以以二进制形式存储JSON数据，提供更直接的语法，甚至支持JSON作为预定义的数据类型。本文旨在比较JSON的底层存储是本机存储还是二进制存储时的性能。设计了一个数据模型和七个用例来演示早期的和新的功能。此外，实验还显示了以原生(19c和21c)和二进制(21c)形式存储的JSON数据对SQL语句的平均执行时间和成本的影响。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

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

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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

IPSI BgD Transactions on Internet Research COMPUTER SCIENCE, INFORMATION SYSTEMS-

自引率

25.00%

发文量