CFP last date
22 April 2024
Reseach Article

RelationalJSON, An Enriched Method to Store and Query JSON Records

by Ankit Bharthan, Devesh Bharathan
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 98 - Number 7
Year of Publication: 2014
Authors: Ankit Bharthan, Devesh Bharathan
10.5120/17193-7382

Ankit Bharthan, Devesh Bharathan . RelationalJSON, An Enriched Method to Store and Query JSON Records. International Journal of Computer Applications. 98, 7 ( July 2014), 3-6. DOI=10.5120/17193-7382

@article{ 10.5120/17193-7382,
author = { Ankit Bharthan, Devesh Bharathan },
title = { RelationalJSON, An Enriched Method to Store and Query JSON Records },
journal = { International Journal of Computer Applications },
issue_date = { July 2014 },
volume = { 98 },
number = { 7 },
month = { July },
year = { 2014 },
issn = { 0975-8887 },
pages = { 3-6 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume98/number7/17193-7382/ },
doi = { 10.5120/17193-7382 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:25:33.802462+05:30
%A Ankit Bharthan
%A Devesh Bharathan
%T RelationalJSON, An Enriched Method to Store and Query JSON Records
%J International Journal of Computer Applications
%@ 0975-8887
%V 98
%N 7
%P 3-6
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Storing JSON documents in a relational database is a favorable solution because relational database are advanced and scale very well and they have the advantage that in a relational database management system (RDBMS) database and organized data can coexist making it possible to build application that involves both kind of data with little effort. In this paper, we propose an algorithm schema named RelationalJSON that translates JSON documents to relational database according to anticipated storing structure. The steps and algorithm are giving in details to describe how to use the storing structure to storage and query JSON documents in RDBMS. Then we report our experimental results on a real database to show the performance of our method in some sorts.

References
  1. Florescu, D. , D. Kossman, 1999. Storing and querying JSON data using an RDBMS, IEEE Data Engineering Bulletin.
  2. Hasan Zafari, Keramat Hasami, M . Ebrahim Shiri, 2010. Xlight, an Efficient Relational Schema to Store and Query JSON Data. In proceeding of the IEEE International conference in Data Store and Data Engineering, pp: 254-257.
  3. Tatarinov, I. , S. Viglas, K. Beyer, et al. , 2002. Storing and querying ordered JSON using a relational database system, in Proceedings of the ACM SIGMOD.
  4. Tian, F. , D. DeWitt, J. Chen, C. Zhang, 2002. The design and performance evaluation of alternative JSON storage strategies, ACM Sigmod Record
  5. Florescu, D. , D. Kossman, 1999. Storing and querying JSON data using an RDBMS, IEEE Data Engineering Bulletin.
  6. M. A. Kashem, Abu Sayed Chowdhury, Rupam Deb, and Moslema Jahan, Query Optimization on Relational Databases for Supporting Top-k Query Processing Techniques 2010 JCIT, ISSN 2078-5828 (PRINT), ISSN 2218-5224 (ONLINE), VOLUME 01, ISSUE 01 2013
  7. Majid Khan and M. N. A. Khan, Exploring Query Optimization Techniques in Relational Databases, International Journal of Database Theory and Application Vol. 6, No. 3, June, 2013
  8. Zhang Yu, Research of Conversion Method of Entity Object and JSON Data, The 2nd International Conference on Computer Application and System Modeling (2012)
Index Terms

Computer Science
Information Sciences

Keywords

JSON Relational Database RDBMS SQL.