Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

JSON Data Management in RDBMS

JSON Data Management in RDBMS
View Sample PDF
Author(s): Zhen Hua Liu (Oracle, USA)
Copyright: 2019
Pages: 25
Source title: Emerging Technologies and Applications in Data Processing and Management
Source Author(s)/Editor(s): Zongmin Ma (Nanjing University of Aeronautics and Astronautics, China) and Li Yan (Nanjing University of Aeronautics and Astronautics, China)
DOI: 10.4018/978-1-5225-8446-9.ch002


View JSON Data Management in RDBMS on the publisher's website for pricing and purchasing information.


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.

Related Content

Ruizhe Ma, Azim Ahmadzadeh, Soukaina Filali Boubrahimi, Rafal A Angryk. © 2019. 19 pages.
Zhen Hua Liu. © 2019. 25 pages.
Lubna Irshad, Zongmin Ma, Li Yan. © 2019. 25 pages.
Hao Jiang, Ahmed Bouabdallah. © 2019. 22 pages.
Gbéboumé Crédo Charles Adjallah-Kondo, Zongmin Ma. © 2019. 22 pages.
Safa Brahmia, Zouhaier Brahmia, Fabio Grandi, Rafik Bouaziz. © 2019. 20 pages.
Zhangbing Hu, Li Yan. © 2019. 20 pages.
Body Bottom