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.

Highlights

  • Nowadays, the JavaScript Object Notation (JSON) data format [1], which is endorsed by the Internet Engineering Task Force (IETF), is widely used in the context of several emerging applications, such as Big Data applications, Internet of Things (IoT), mobile computing, streaming applications, smart cities, and online social networks, since it is a lightweight serialization data format that makes storage, interchange, and querying of data easy

  • JUpdate is composed of fourteen high-level operations (HLOs) with an SQLlike syntax, so that it could be considered, for instance, as a complement of SQL++ to make up a complete JSON data manipulation language (DML)

  • We have proposed JUpdate, a JSON Update language, which includes a complete set of fourteen user-friendly high-level operations

Read more

Summary

Introduction

The JavaScript Object Notation (JSON) data format [1], which is endorsed by the Internet Engineering Task Force (IETF), is widely used in the context of several emerging applications, such as Big Data applications, Internet of Things (IoT), mobile computing, streaming applications, smart cities, and online social networks, since it is a lightweight serialization data format that makes storage, interchange, and querying of data easy. According to the discussion of the SQL/JSON standard presented in [24], this new language does not support the modification of portions of a JSON document through the SQL UPDATE statement In this context, it is our conviction that a JSON data update requires more attention and that the definition of a JSON update language is necessary. It is our conviction that a JSON data update requires more attention and that the definition of a JSON update language is necessary Such a language should be powerful and user-friendly and defined with a well-founded and DBMSindependent semantics in order to facilitate its use and implementation. For these reasons, we propose in this paper a language, named JUpdate, for updating JSON data.

High-Level Update Operations on JSON Documents
Objective
CreateDocument
DropDocument
InsertValue
DeleteValue
UpdateValue
CopyValue
MoveValue
InsertMember
DeleteMember
2.10. RenameMember
2.11. ReplaceMember
2.12. CopyMember
2.13. MoveMember
2.14. UpdateObject
Illustrative Example
Primitive Update Operations
DropDoc
InsMemb
InsVal
Completeness and Minimality
Completeness of JUpdate
Definability of the HLOs Making up JUpdate
Basic HLOs
Derived HLOs
Related Work Discussion
Conclusions
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call