Abstract
JSONPath is a language for locations in a standard JSON document, like the XPath language for XML documents. Its definition is based on the specification of the standard JSON format. Moreover, many JSON query languages, like JSONiq, have been inspired from JSONPath. However, JSONPath allows to navigate only in the current version of a JSON document, since it does not support temporal aspects. Besides, as several modern platforms, like IoT-based applications, cloud computing, and e-health systems, are creating, accessing, updating, and querying temporal JSON documents, it will be interesting to have a temporal query language that allows locating and retrieving temporal JSON data from such documents. Moreover, the state-of-the-art of JSON data management does not include any temporal JSON query language. Hence, to fill this gap, we propose in this paper τJSONPath (Temporal JSONPath), a temporal extension of JSONPath, to query time-varying JSON documents in our temporal JSON framework τJSchema. τJSONPath extends both the syntax and the semantics of JSONPath to support transaction time. We also provide some examples to motivate and illustrate our proposal.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Jensen, C.S., Snodgrass, R.T.: Temporal database. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems (2nd edition), pp. 3945–3949. Springer, New York, NY, USA (2018)
Jensen, C.S., Snodgrass, R.T.: Transaction time. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems (2nd edition), pp. 4200–4201. Springer, New York, NY, USA (2018)
Jensen, C.S., Snodgrass, R.T.: Valid time. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems (2nd edition), pp. 4359–4360. Springer, New York, NY, USA (2018)
Internet Engineering Task Force (IETF): The JavaScript Object Notation (JSON) Data Interchange Format, Internet Standards Track document, December 2017. https://tools.ietf.org/html/rfc8259. Accessed 10 Sept 2022
Brahmia, S., Brahmia, Z., Grandi, F., Bouaziz, R.: τJSchema: a framework for managing temporal JSON-based NoSQL databases. In: Hartmann, S., Ma, H. (eds.) DEXA 2016. LNCS, vol. 9828, pp. 167–181. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-44406-2_13
Goyal, A., Dyreson, C.: Temporal JSON. In: Proceedings of the 5th IEEE International Conference on Collaboration and Internet Computing (CIC 2019), Los Angeles, CA, USA, 12–14 December 2019, pp. 135–144 (2019)
Snodgrass, R.T. (ed.), et al.: The TSQL2 Temporal Query Language. Kluwer Academic Publishers, Norwell (1995)
Zheng, X., Liu, H.K., Wei, L.N., Wu, X.G., Zhang, Z.: Timo: in-memory temporal query processing for big temporal data. In: Proceedings of the 7th International Conference on Advanced Cloud and Big Data (CBD 2019), Suzhou, China, 21–22 September 2019, pp. 121–126 (2019)
Tansel, A.U., Imberman, S.P.: Discovery of association rules in temporal databases. In: Proceedings of the 4th International Conference on Information Technology (ITNG'2007), Las Vegas, NV, USA, 02–04 April 2007, pp. 371–376 (2007)
Zhao, J., Papapetrou, P., Asker, L., Boström, H.: Learning from heterogeneous temporal data in electronic health records. J. Biomed. Inform. 65, 105–119 (2017)
Internet Engineering Task Force (IETF): JSON Schema: A Media Type for Describing JSON Documents, Internet-Draft, 19 March 2018. https://json-schema.org/latest/json-schema-core.html. Accessed 10 Sept 2022
Gössner, S.: JSONPath – XPath for JSON, 21 February 2007. http://goessner.net/articles/JsonPath/. Accessed 10 Sept 2022
Internet Engineering Task Force (IETF): JSONPath: Query Expressions for JSON, Internet-Draft, 25 April 2022. https://datatracker.ietf.org/doc/draft-ietf-jsonpath-base/. Accessed 10 Sept 2022
XML Path Language (XPath) 3.0, W3C Recommendation, 8 April 2014. http://www.w3.org/TR/2014/REC-xpath-30-20140408/. Accessed 10 Sept 2022
Liu, Z.H., Hammerschmidt, B., McMahon, D.: JSON data management: supporting schema-less development in RDBMS. In: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, Snowbird, UT, USA, 22–27 June 2014, pp. 1247–1258 (2014)
Bourhis, P., Reutter, J.L., Vrgoč, D.: JSON: data model and query languages. Inf. Syst. 89, 101478 (2020)
Brahmia, Z., Brahmia, S., Grandi, F., Bouaziz, R.: JUpdate: a JSON update language. Electronics 11(4), 508 (2022)
Allen, J.F.: Maintaining knowledge about temporal intervals. Commun. ACM 26(11), 832–843 (1983)
Wang, F., Zaniolo, C., Zhou, X.: Archis: an xml-based approach to transaction-time temporal database systems. VLDB J. 17(6), 1445–1463 (2008)
JSONPath Online Evaluator (2022). https://jsonpath.com/. Accessed 10 Sept 2022
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Brahmia, Z., Grandi, F., Brahmia, S., Bouaziz, R. (2023). τJSONPath: A Temporal Extension of the JSONPath Language for the τJSchema Framework. In: Farhaoui, Y., Rocha, A., Brahmia, Z., Bhushab, B. (eds) Artificial Intelligence and Smart Environment. ICAISE 2022. Lecture Notes in Networks and Systems, vol 635. Springer, Cham. https://doi.org/10.1007/978-3-031-26254-8_123
Download citation
DOI: https://doi.org/10.1007/978-3-031-26254-8_123
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-26253-1
Online ISBN: 978-3-031-26254-8
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)