Welcome to the InfoSci Platform
Reference Hub2
JSON Data Management in RDBMS

JSON Data Management in RDBMS

Zhen Hua Liu
Copyright: © 2019 |Pages: 25
ISBN13: 9781522584469|ISBN10: 1522584463|ISBN13 Softcover: 9781522585053|EISBN13: 9781522584476
DOI: 10.4018/978-1-5225-8446-9.ch002
Cite Chapter Cite Chapter

MLA

Liu, Zhen Hua. "JSON Data Management in RDBMS." Emerging Technologies and Applications in Data Processing and Management, edited by Zongmin Ma and Li Yan, IGI Global, 2019, pp. 20-44. https://doi.org/10.4018/978-1-5225-8446-9.ch002

APA

Liu, Z. H. (2019). JSON Data Management in RDBMS. In Z. Ma & L. Yan (Eds.), Emerging Technologies and Applications in Data Processing and Management (pp. 20-44). IGI Global. https://doi.org/10.4018/978-1-5225-8446-9.ch002

Chicago

Liu, Zhen Hua. "JSON Data Management in RDBMS." In Emerging Technologies and Applications in Data Processing and Management, edited by Zongmin Ma and Li Yan, 20-44. Hershey, PA: IGI Global, 2019. https://doi.org/10.4018/978-1-5225-8446-9.ch002

Export Reference

Mendeley
Favorite

Abstract

Being a simple semi-structured data model, JSON has been widely accepted as a simple way to store, query, modify, and exchange data among applications. In comparison with schema-oriented relational data model to store, query, and update application data, JSON data model has the advantage of being self-contained, free from schema evolution issues, and flexible enough to enable agile style development paradigm. Therefore, during the last 5 years, SQL/JSON standard has been established as foundation for managing JSON data in SQL standard and there have been JSON functionalities added into RDBMS products to support SQL/JSON standard to various degree. In this chapter, the authors will analyze the strength and weakness of using JSON as the data model to manage data for applications. For use cases where JSON data model is ideal, they present the design approaches to store, index, query, and update JSON in the kernel of RDBMS to support SQL/JSON standard defined operations effectively and efficiently.

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.