Translating JSON Data into Relational Data Using Schema-oblivious Approaches
Rahwa Bahta, Mustafa Atay · 2019
JSON (JavaScript Object Notation) has become popular as the data exchange standard over the Web. JSON has been gaining more popularity over XML due to its simplicity, compactness and ability to fit into the object types of programming languages. The large sizes of JSON data has been primarily stored and managed by NoSQL document store systems. While NoSQL systems appeal to the developers due to the native support for the object types of programming languages, they do not provide mechanisms to support ACID properties for the transactions that occur over sensitive JSON data. In this paper, we propose to store and manage JSON data in relational database systems to get advantages of transaction management and concurrency control mechanisms. We elaborate whether JSON can be effectively stored in a relational database system as an alternative to NoSQL document stores as well as whether schema-oblivious XML-to-Relational mapping techniques can be adopted to the process of JSON-to-Relational mapping.