• Cite Icon72
  • https://doi.org/10.1145/2588555.2595628Copy DOI Icon

JSON data management

  • Jun 18, 2014
  • Zhen Hua Liu +2 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Relational Database Management Systems (RDBMS) have been very successful at managing structured data with well-defined schemas. Despite this, relational systems are generally not the first choice for management of data where schemas are not pre-defined or must be flexible in the face of variations and changes. Instead, No-SQL database systems supporting JSON are often selected to provide persistence to such applications. JSON is a light-weight and flexible semi-structured data format supporting constructs common in most programming languages. In this paper, we analyze the way in which requirements differ between management of relational data and management of JSON data. We present three architectural principles that facilitate a schema-less development style within an RDBMS so that RDBMS users can store, query, and index JSON data without requiring schemas. We show how these three principles can be applied to industry-leading RDBMS platforms, such as the Oracle RDBMS Server, with relatively little effort. Consequently, an RDBMS can unify the management of both relational data and JSON data in one platform and use SQL with an embedded JSON path language as a single declarative language to query both relational data and JSON data. This SQL/JSON approach offers significant benefits to application developers as they can use one product to manage both relational data and semi-structured flexible schema data.

Similar Papers
  • Book Chapter
  • Citations1

Which Category Is Better: Benchmarking the RDBMSs and GDBMSs

  • Jan 01, 2019
  • Pengjie Ding +4
  • Research Article
  • Citations2

High-performance Negative Database for Massive Data Management System of The Mingantu Spectral Radioheliograph

  • Jun 22, 2017
  • Publications of the Astronomical Society of the Pacific
  • Congming Shi +5
  • Conference Article

A relational data management system for electronic switching systems

  • Nov 06, 1979
  • W.L Gewirtz +4
  • Conference Article
  • Citations110

Intermedia: A case study of the differences between relational and object-oriented database systems

  • Dec 01, 1987
  • Karen E Smith +1
  • PDF
  • Research Article
  • Citations3

Performance Metrics for Decision Support in Big Data vs. Traditional RDBMS Tools & Technologies

  • Jan 01, 2016
  • International Journal of Advanced Computer Science and Applications
  • Alazar Baharu +1
  • Book Chapter
  • Citations11

JSON Data Management in RDBMS

  • Jan 01, 2019
  • Zhen Hua Liu
  • Research Article

Development of process data capturing, analysis and controlling for thermal spray techniques - SprayTracker

  • Mar 01, 2017
  • IOP Conference Series: Materials Science and Engineering
  • C Kelber +4
  • Book Chapter

4.3 - Introduction to Data Vault Architecture

  • Jan 01, 2015
  • Data Architecture: A Primer for the Data Scientist
  • W.H Inmon +1
  • Conference Article
  • Citations1

A nested set approach for building recursive XML tree structures from relational databases

  • Jun 01, 2011
  • Frederick S Brundick +1
  • Research Article
  • Citations32

The Object-Oriented Database Management System versus the Relational Database Management System: A Comparison

  • Dec 31, 2018
  • Global Disclosure of Economics and Business
  • Mounika Mandapuram +1
  • Research Article
  • Citations4

A qualitative information system for data management

  • Jan 01, 1991
  • Qualitative Sociology
  • Laura R Winer +1
  • Research Article
  • Citations2

관계형 데이터베이스를 이용한 수문자료 관리시스템 개발

  • Oct 01, 2006
  • Journal of Korea Water Resources Association
  • Hak Yong Kim +2
  • Conference Article
  • Citations9

RDB-KV: A Cloud Database Framework for Managing Massive Heterogeneous Sensor Stream Data

  • Jan 01, 2012
  • Zhiming Ding +2
  • Dissertation

Storage and Navigation Operations on Graphs in Relational DBMS

  • May 07, 2021
  • Lucas De Carvalho Scabora
  • Book Chapter

Introducing the Model and SQLAlchemy

  • Jan 24, 2009
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.