Welcome to the InfoSci Platform
Reference Hub6
Schema-Based JSON Data Stores in Relational Databases

Schema-Based JSON Data Stores in Relational Databases

Lubna Irshad, Li Yan, Zongmin Ma
Copyright: © 2019 |Volume: 30 |Issue: 3 |Pages: 33
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781522563808|DOI: 10.4018/JDM.2019070103
Cite Article Cite Article

MLA

Irshad, Lubna, et al. "Schema-Based JSON Data Stores in Relational Databases." JDM vol.30, no.3 2019: pp.38-70. http://doi.org/10.4018/JDM.2019070103

APA

Irshad, L., Yan, L., & Ma, Z. (2019). Schema-Based JSON Data Stores in Relational Databases. Journal of Database Management (JDM), 30(3), 38-70. http://doi.org/10.4018/JDM.2019070103

Chicago

Irshad, Lubna, Li Yan, and Zongmin Ma. "Schema-Based JSON Data Stores in Relational Databases," Journal of Database Management (JDM) 30, no.3: 38-70. http://doi.org/10.4018/JDM.2019070103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.