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

Implementation of JSON Update Framework in RDBMSs

by Dušan Petković
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 177 - Number 37
Year of Publication: 2020
Authors: Dušan Petković
10.5120/ijca2020919881

Dušan Petković . Implementation of JSON Update Framework in RDBMSs. International Journal of Computer Applications. 177, 37 ( Feb 2020), 35-39. DOI=10.5120/ijca2020919881

@article{ 10.5120/ijca2020919881,
author = { Dušan Petković },
title = { Implementation of JSON Update Framework in RDBMSs },
journal = { International Journal of Computer Applications },
issue_date = { Feb 2020 },
volume = { 177 },
number = { 37 },
month = { Feb },
year = { 2020 },
issn = { 0975-8887 },
pages = { 35-39 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume177/number37/31148-2020919881/ },
doi = { 10.5120/ijca2020919881 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:48:00.706049+05:30
%A Dušan Petković
%T Implementation of JSON Update Framework in RDBMSs
%J International Journal of Computer Applications
%@ 0975-8887
%V 177
%N 37
%P 35-39
%D 2020
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The existing SQL/JSON standard specifies the way how queries can be performed, but in order to reach the full functionality for data representation and as a sharing format, it needs to support several additional features. One of the most important missing features is the facility to perform updates on the content of JSON documents. In this article we discuss how update operations for JSON data have been implemented in relational database systems and compare these implementations in relation to their scope and coverage of our framework, which comprises the set of primitive update operations. SQL Server uniformly supports all implemented operations with the JSON_MODIFY function, but the syntax of the second argument of the function is not uniform. The syntax for PostgreSQL update operations is rather awkward and the implementation is not uniform. On the other hand, PostgreSQL supports the full update operation in the same way as this paper proposes. MySQL implemented all update primitives specified in the framework.

References
  1. Chausser, C. 2013. Enabling JSON Document Stores in Relational Systems. WebDB.
  2. ISO/IEC TR 19075-6:2017. Information technology -- Database languages -- SQL Technical Report -- Part 6: SQL support for JavaScript Object Notation (JSON). http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html. . (Accessed October 15, 2019)
  3. Liu, Z,H, Hammerschmidt, B., McMahon, D. 2014. JSON Data management – Supporting Schema-Less Development in RDBMS. SIGMOD/PODS’14.
  4. Liu, Z.H. 2019. JSON Data Management in RDBMS. In The Emerging Technologies and Applications in Data Processing and Management.
  5. Liu, Z.H, Gawlick, D. 2015. Management of Flexible Schema Data in RDBMSs. CIDR’ 15.
  6. MS SQL Server: JSON Data, https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server. (Accessed Dec 25, 2019)
  7. MS SQL Server JSON_MODIFY function. https://docs.microsoft.com/en-us/sql/t-sql/functions/json-modify-transact-sql?view=sql-server-2017. (Accessed July 5, 2019)
  8. Petković, D. 2017. SQL/JSON Standard: Properties and Deficiencies. Datenbank Spektrum, Vol. 17, No.3.
  9. Petković, D. 2017. JSON integration in relational database systems. Int. Journal of Computing Applications, Vol. 168(5)
  10. Petković, D. 2018. Full-Text Search Extensions for JSON Documents: Design Goals and Implementations. In Proc. Of the 14th International Conference, BDAS 2018, Poznan, Poland.
  11. PostgreSQL9.5,JSONTypes,www.postgresql.org/docs/9.5/static/datatype-json.html (accessed November 13, 2019)
  12. PostgreSQL 9.5, JSON Functions , www.postgresql.org/docs/9.5/static/functions-json.html (Accessed December 20, 2019)
  13. Tatarinov, I.; Ives, Z.; Halevy, A.; Weld, D. 2001. Updating XML. ACM SIGMOD.
  14. Zemke F, Hammerschmidt B, Kulkarni K, Liu Z, McMahon D, Melton J, Michels J, Özcan F, Pirahesh H. - ANSI SQL/JSON: Part 1, www.wiscorp.com/pub/DM32.2-2014-00025r1-sql-json-part-1.pdf. (Accessed July 26, 2019).
  15. Zemke, F.; Hammerschmidt, B. ; Kulkarni, K. ; Liu, Z. ; McMahon, D. ; Melton, J. ; Michels, J. ; Özcan, F. ; Pirahesh, H. - ANSI SQL/JSON: Part 2 : Querying JSON, www.wiscorp.com/pub/DM32.2-2014-00025r1-sql-json-part-2.pdf. (Accessed October 25, 2019)
Index Terms

Computer Science
Information Sciences

Keywords

JSON SQL/JSON JSON Update Framework MySQL PostgreSQL SQL Server

Powered by PhDFocusTM