Call for Paper - October 2019 Edition
IJCA solicits original research papers for the October 2019 Edition. Last date of manuscript submission is September 20, 2019. Read More

RelationalJSON, An Enriched Method to Store and Query JSON Records

Print
PDF
International Journal of Computer Applications
© 2014 by IJCA Journal
Volume 98 - Number 7
Year of Publication: 2014
Authors:
Ankit Bharthan
Devesh Bharathan
10.5120/17193-7382

Ankit Bharthan and Devesh Bharathan. Article: RelationalJSON, An Enriched Method to Store and Query JSON Records. International Journal of Computer Applications 98(7):3-6, July 2014. Full text available. BibTeX

@article{key:article,
	author = {Ankit Bharthan and Devesh Bharathan},
	title = {Article: RelationalJSON, An Enriched Method to Store and Query JSON Records},
	journal = {International Journal of Computer Applications},
	year = {2014},
	volume = {98},
	number = {7},
	pages = {3-6},
	month = {July},
	note = {Full text available}
}

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

  • Florescu, D. , D. Kossman, 1999. Storing and querying JSON data using an RDBMS, IEEE Data Engineering Bulletin.
  • 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.
  • 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.
  • Tian, F. , D. DeWitt, J. Chen, C. Zhang, 2002. The design and performance evaluation of alternative JSON storage strategies, ACM Sigmod Record
  • Florescu, D. , D. Kossman, 1999. Storing and querying JSON data using an RDBMS, IEEE Data Engineering Bulletin.
  • 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
  • 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
  • Zhang Yu, Research of Conversion Method of Entity Object and JSON Data, The 2nd International Conference on Computer Application and System Modeling (2012)