We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

RelationalJSON, An Enriched Method to Store and Query JSON Records

by Ankit Bharthan, Devesh Bharathan
journal cover thumbnail

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.

Powered by PhDFocusTM