JUpdate: A JSON Update Language

Abstract

Although JSON documents are being used in several emerging applications (e.g., Big Data applications, IoT, mobile computing, smart cities, and online social networks), there is no consensual or standard language for updating JSON documents (i.e., creating, deleting or changing such documents, where changing means inserting, deleting, replacing, copying, moving, etc., portions of data in such documents). To fill this gap, we propose in this paper an SQL-like language, named JUpdate, for updating JSON documents. JUpdate is based on a set of six primitive update operations, which is proven complete and minimal, and it provides a set of fourteen user-friendly high-level operations with a well-founded semantics defined on the basis of the primitive update operations.

Utilization of Telegram application As an Information Media Face Mask Detection Result

“…JSON is a very lightweight data interchange [17] and is a ubiquitous file [18]. JSON is widely used in several applications such as big data, IoT, soft computing ,and intelligent cities [19].…”

$${\tau }$$JUpdate: A Temporal Update Language for JSON Data

“…In this section, we propose the τ JUpdate language, by showing how the JUpdate specication [6] has to be extended. More precisely, in Sec.…”

“…However, in the state-of-the-art of JSON data management [21,17,20,1,27,22,6], there is neither a consensual nor a standard language for updating (i.e., inserting, modifying, and deleting) temporal JSON data, like the TSQL2 (Temporal SQL2) [28] or SQL:2016 [24] language for temporal relational data. It is worth mentioning here that the extension of the SQL language, named SQL/J-SON [23,29,18] and standardized by ANSI to empower SQL to manage queries and updates on JSON data, has no built-in support for updating time-varying JSON data.…”

“…With the aim of overcoming the lack of an IETF standard or recommendation for updating JSON data, we have recently proposed a powerful SQL-like language, named JUpdate (JSON Update) [6], to allow users to perform updates on (non-temporal) JSON data. It provides fourteen user-friendly high-level operations (HLOs) to fulll the dierent JSON update requirements of users and applications; not only simple/atomic values but also full portions (or chunks) of JSON documents can be manipulated (i.e., inserted, modied, deleted, copied or moved) The semantics of JUpdate is based on a minimal and complete set of six primitives (i.e., low-level operations, which can be easily implemented) for updating JSON documents.…”

“…Taking into account the requirements mentioned above, we considered very interesting to ll the evidenced gap and to propose a temporal JSON update language that would help users in the non-trivial task of updating temporal JSON data. Moreover, based on our previous work, we think that (i) the JUpdate language [6] can be a good starting point for deriving such a temporal JSON update language, and (ii) the τ JSchema framework can be used as a suitable environment for dening the syntax and semantics of a user-friendly temporal update language, mainly due to its support of logical and physical data independence.…”