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

JSON Integration in Relational Database Systems

by Dušan Petković
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 168 - Number 5
Year of Publication: 2017
Authors: Dušan Petković
10.5120/ijca2017914389

Dušan Petković . JSON Integration in Relational Database Systems. International Journal of Computer Applications. 168, 5 ( Jun 2017), 14-19. DOI=10.5120/ijca2017914389

@article{ 10.5120/ijca2017914389,
author = { Dušan Petković },
title = { JSON Integration in Relational Database Systems },
journal = { International Journal of Computer Applications },
issue_date = { Jun 2017 },
volume = { 168 },
number = { 5 },
month = { Jun },
year = { 2017 },
issn = { 0975-8887 },
pages = { 14-19 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume168/number5/27870-2017914389/ },
doi = { 10.5120/ijca2017914389 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:15:18.622433+05:30
%A Dušan Petković
%T JSON Integration in Relational Database Systems
%J International Journal of Computer Applications
%@ 0975-8887
%V 168
%N 5
%P 14-19
%D 2017
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Recently, a new era of application development is emerging, which us based upon big data technology and the ease of access to compute resources, such as mobile devices. All these issues can be better supported using JSON (and JavaScript) technology. Almost all relational database systems have integrated JSON, partly according to the specification given in the ANSI SQL standard and partly according to other specifications. In this article we discuss several JSON features and investigate how different relational database systems (RDBMSs) have integrated them. Of all database systems discussed in this paper Oracle has implemented the most concepts specified in the ANSI SQL/JSON standard. In contrast to Oracle, PostgreSQL have not implemented any standardized features. Also, we discuss conformance of all these implementations in relation to the ANSI SQL/JSON standard and give suggestions, which important features should be implemented in the future releases of the RDBMSs.

References
  1. Chasseur, C. et al. – Enabling JSON Document Stores in Relational Systems, WebDB, 2013.
  2. CouchDB, www.couchdb.org
  3. Li, C., Ling, T.W. & Hu, M. - Efficient updates in dynamic XML data: from binary string to quaternary string, VLDB Journal (2008) 17: 573.
  4. Liu, C.H. et al. – JSON Data Management Supporting Schema-Less Development in RDBMS, SIGMOD/PODS’14, p. 1247-58, June 2014.
  5. Liu, C.H. et al. – Closing the functional and Performance Gap between SQL and NoSQL, SIGMOD’16.
  6. MongoDB, www.mongodb.org
  7. JSON in Oracle Database, http://docs.oracle.com/ database/121/ADXDB/json.htm#ADXDB6246
  8. Indexing JSON Data in Oracle Database, https://oracle-base.com/articles/12c/indexing-json-data-in-oracle-database-12cr1
  9. Petkovic, D. SQL Server 2016, A Beginner’s Guide, McGraw Hill Educational, 2016.
  10. PostgreSQL 9.4, JSON Types, www.postgresql.org/docs/9.4/static/datatype-json.html
  11. PostgreSQL 9.4, JSON Functions , www.postgresql.org/docs/9.4/static/functions-json.html
  12. Schinckel, M. Querying JSON in Postgres, schinckel.net/2014/05/25/querying-json-in-postgres
  13. SQL Server: JSON Data, https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server
  14. Tahara, D, et al. – Sinew: A new SQL System for Multi-Structured data SIGMOD Conf. 2014.
  15. UPDATEXML, https://docs.oracle.com/cd/ B19306_01/server.102/b14200/functions205.htm
  16. Zemke, F et al.- ANSI SQL/JSON: Part 1, www.wiscorp.com/pub/DM32.2-2014-00025r1-sql-json-part-1.pdf, 2014.
Index Terms

Computer Science
Information Sciences

Keywords

JSON SQL/JSON relational database systems JSON integration

Powered by PhDFocusTM