Closing the functional and Performance Gap between SQL and NoSQL

Proceedings of the 2016 International Conference on Management of Data Pub Date : 2016-06-14 DOI:10.1145/2882903.2903731

Z. Liu, B. Hammerschmidt, Douglas Mcmahon, Y. Liu, Hui J. Chang

{"title":"Closing the functional and Performance Gap between SQL and NoSQL","authors":"Z. Liu, B. Hammerschmidt, Douglas Mcmahon, Y. Liu, Hui J. Chang","doi":"10.1145/2882903.2903731","DOIUrl":null,"url":null,"abstract":"Oracle release 12cR1 supports JSON data management that enables users to store, index and query JSON data along with relational data. The integration of the JSON data model into the RDBMS allows a new paradigm of data management where data is storable, indexable and queryable without upfront schema definition. We call this new paradigm Flexible Schema Data Management (FSDM). In this paper, we present enhancements to Oracle's JSON data management in the upcoming 12cR2 release. We present JSON DataGuide, an auto-computed dynamic soft schema for JSON collections that closes the functional gap between the fixed-schema SQL world and the schema-less NoSQL world. We present a self-contained query friendly binary format for encoding JSON (OSON) to close the query performance gap between schema-encoded relational data and schema free JSON textual data. The addition of these new features makes the Oracle RDBMS well suited to both fixedschema SQL and flexible-schema NoSQL use cases, and allows users to freely mix the two paradigms in a single data management system.","PeriodicalId":20483,"journal":{"name":"Proceedings of the 2016 International Conference on Management of Data","volume":"349 1","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2016-06-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"38","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 2016 International Conference on Management of Data","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/2882903.2903731","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 38

Abstract

Oracle release 12cR1 supports JSON data management that enables users to store, index and query JSON data along with relational data. The integration of the JSON data model into the RDBMS allows a new paradigm of data management where data is storable, indexable and queryable without upfront schema definition. We call this new paradigm Flexible Schema Data Management (FSDM). In this paper, we present enhancements to Oracle's JSON data management in the upcoming 12cR2 release. We present JSON DataGuide, an auto-computed dynamic soft schema for JSON collections that closes the functional gap between the fixed-schema SQL world and the schema-less NoSQL world. We present a self-contained query friendly binary format for encoding JSON (OSON) to close the query performance gap between schema-encoded relational data and schema free JSON textual data. The addition of these new features makes the Oracle RDBMS well suited to both fixedschema SQL and flexible-schema NoSQL use cases, and allows users to freely mix the two paradigms in a single data management system.

查看原文本刊更多论文

缩小SQL和NoSQL在功能和性能上的差距

Oracle 12cR1版本支持JSON数据管理，允许用户存储、索引和查询JSON数据以及关系数据。将JSON数据模型集成到RDBMS中允许一种新的数据管理范式，其中数据可存储、可索引和可查询，而无需预先定义模式。我们称这种新模式为灵活模式数据管理(FSDM)。在本文中，我们将介绍在即将发布的12cR2版本中对Oracle JSON数据管理的增强。我们提出了JSON DataGuide，一个自动计算的JSON集合动态软模式，它缩小了固定模式的SQL世界和无模式的NoSQL世界之间的功能差距。我们提出了一种自包含的查询友好型二进制格式，用于编码JSON (OSON)，以缩小模式编码的关系数据和模式自由JSON文本数据之间的查询性能差距。这些新特性的添加使Oracle RDBMS非常适合固定模式SQL和灵活模式NoSQL用例，并允许用户在单个数据管理系统中自由混合这两种范式。

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

求助全文

约1分钟内获得全文求助全文

来源期刊

Proceedings of the 2016 International Conference on Management of Data

自引率

0.00%

发文量