Schema-Based JSON Data Stores in Relational Databases
Schema-Based JSON Data Stores in Relational Databases
复制标题
关系数据库中基于模式的 JSON 数据存储
DOI：
10.4018/jdm.2019070103
复制
发表时间：
2019-07-01
影响因子：
2.6
通讯作者：
Ma, Zongmin
中科院分区：
文献类型：
--
作者：
Irshad, Lubna;Yan, Li;Ma, Zongmin
JSON是一种简单、紧凑和轻量级的数据交换格式，用于在Web服务和客户端应用程序之间进行通信。NoSQL文档存储随着JSON的流行而发展，它可以支持JSON无模式存储，降低成本，促进快速开发。然而，NoSQL仍然缺乏标准的查询语言，并支持最终一致的BASE事务模型，而不是ACID事务模型。这对开发人员来说是一个很大的挑战和负担。关系数据库管理系统（RDBMS）支持JSON的二进制格式与SQL函数（也称为SQL/JSON）。然而，这些功能尚未标准化，并且沿着不同的供应商而变化，具有不同的限制和复杂性。更重要的是，与标准SQL操作相比，SQL/JSON中的复杂搜索、部分更新、复合查询和分析既繁琐又耗时。必须将JSON集成到使用标准SQL功能、支持ACID事务模型并具有有效管理和组织数据能力的数据库中。在本文中，我们授权JSON使用关系数据库进行分析和复杂查询。作者揭示了JSON模式的描述性本质可以用来创建用于存储JSON文档的关系模式。然后，可以使用强大的SQL特性来获得一致性和ACID兼容性，以便从关系模式中查询JSON实例。这种方法将为联合收割机提供一个结合两个世界最佳特性的门户：JSON的快速开发、关系模型的一致性和SQL的效率。
JSON is a simple, compact and light weighted data exchange format to communicate between web services and client applications. NoSQL document stores evolve with the popularity of JSON, which can support JSON schema-less storage, reduce cost, and facilitate quick development. However, NoSQL still lacks standard query language and supports eventually consistent BASE transaction model rather than the ACID transaction model. This is very challenging and a burden on the developer. The relational database management systems (RDBMS) support JSON in binary format with SQL functions (also known as SQL/JSON). However, these functions are not standardized yet and vary across vendors along with different limitations and complexities. More importantly, complex searches, partial updates, composite queries, and analyses are cumbersome and time consuming in SQL/JSON compared to standard SQL operations. It is essential to integrate JSON into databases that use standard SQL features, support ACID transactional models, and has the capability of managing and organizing data efficiently. In this article, we empower JSON to use relational databases for analysis and complex queries. The authors reveal that the descriptive nature of the JSON schema can be utilized to create a relational schema for the storage of the JSON document. Then, the powerful SQL features can be used to gain consistency and ACID compatibility for querying JSON instances from the relational schema. This approach will open a gateway to combine the best features of both worlds: the fast development of JSON, consistency of relational model, and efficiency of SQL.