The week's pick
Random Articles
Reseach Article
Implementation of JSON Update Framework in RDBMSs
| 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
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
- Chausser, C. 2013. Enabling JSON Document Stores in Relational Systems. WebDB.
- 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)
- Liu, Z,H, Hammerschmidt, B., McMahon, D. 2014. JSON Data management – Supporting Schema-Less Development in RDBMS. SIGMOD/PODS’14.
- Liu, Z.H. 2019. JSON Data Management in RDBMS. In The Emerging Technologies and Applications in Data Processing and Management.
- Liu, Z.H, Gawlick, D. 2015. Management of Flexible Schema Data in RDBMSs. CIDR’ 15.
- MS SQL Server: JSON Data, https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server. (Accessed Dec 25, 2019)
- 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)
- Petković, D. 2017. SQL/JSON Standard: Properties and Deficiencies. Datenbank Spektrum, Vol. 17, No.3.
- Petković, D. 2017. JSON integration in relational database systems. Int. Journal of Computing Applications, Vol. 168(5)
- 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.
- PostgreSQL9.5,JSONTypes,www.postgresql.org/docs/9.5/static/datatype-json.html (accessed November 13, 2019)
- PostgreSQL 9.5, JSON Functions , www.postgresql.org/docs/9.5/static/functions-json.html (Accessed December 20, 2019)
- Tatarinov, I.; Ives, Z.; Halevy, A.; Weld, D. 2001. Updating XML. ACM SIGMOD.
- 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).
- 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
Keywords