Modeling Temporal Information With JSON

Abstract

As a ubiquitous form of data in human natural life, time has been widely used in military, finance, medical treatment, environment and other fields. Therefore, temporal data models used to express the dynamic development process of data have been proposed constantly. Currently, the main research achievements focus on temporal database and temporal XML. With the rapid development and popularization of network technology, the requirement of efficiency and security is getting higher and higher. JSON, a new generation of data exchange language, has been widely used because of its lightweight, fast parsing and high transmission efficiency. However, modeling temporal information with JSON has not been studied enough. The chapter proposes a temporal data model based on JSON. What is more, the temporal query language and the JSON Schema is also mentioned.

JUpdate: A JSON Update Language

“…However, by studying the state-of-the-art of JSON data management (e.g., [2][3][4][5][6][7][8][9][10][11][12]), we have not found a recommended, consensual, and/or standard language for updating (native) JSON data (such as SQL for relational data, XQuery Update Facility for XML data, or SPARQL 1.1 Update for RDF data). Several JSON query languages have been proposed, such as Jaql [13], JSONiq [14], JPQ [15], SQL++ [16,17], JNL [18], JSON-λ [19], JSONata, GROQ, and JMESPath, which all lack modification statements making up a JSON update language.…”

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

“…Moreover, existing JSON-based NoSQL database management systems (DBMSs) (e.g., MongoDB, Couchbase, CouchDB, DocumentDB, MarkLogic, OrientDB, RethinkDB, and Riak) and both commercial DBMSs (e.g., IBM DB2 12, Oracle 19c, and Microsoft SQL Server 2019) and open-source ones (e.g., PostgreSQL 15, and MySQL 8.0) do not provide any support for maintaining temporal JSON data [3,11,13].…”