Preprints
https://doi.org/10.5194/gi-2024-3
https://doi.org/10.5194/gi-2024-3
28 Jun 2024
 | 28 Jun 2024
Status: a revised version of this preprint was accepted for the journal GI.

Managing Data of Sensor-Equipped Transportation Networks using Graph Databases

Erik Bollen, Rik Hendrix, and Bart Kuijpers

Abstract. In this paper, we are concerned with data pertinent to transportation networks, which model situations in which objects move along a graph-like structure. We assume that these networks are equipped with sensors that monitor the network and the objects moving along it. These sensors produce time-series data resulting in sensor networks. Examples are river-, road- and electricity networks.

Geographical information systems are used to gather, store and analyse data, and we focus on these tasks in the context of data emerging from transportation networks equipped with sensors. While tailored solutions exist for many contexts, they are limited for sensor-equipped networks at this moment. We view time-series data as temporal properties of the network and approach the problem from the viewpoint of property graphs. In this paper, we adapt and extend the theory of the existing property graph databases to model spatial networks, where nodes and edges can contain temporal properties that are time-series data originating from the sensors. We propose a language for querying these property graphs with time series, in which time-series and measurement patterns may be combined with graph patterns to describe, retrieve and analyse real-life situations. We demonstrate the model and language in practice by implementing both in Neo4j and explore questions hydrology researchers pose in the context of the Internet of Water, including salinity analysis in the Yser river basin.

Publisher's note: Copernicus Publications remains neutral with regard to jurisdictional claims made in the text, published maps, institutional affiliations, or any other geographical representation in this preprint. The responsibility to include appropriate place names lies with the authors.
Erik Bollen, Rik Hendrix, and Bart Kuijpers

Status: final response (author comments only)

Comment types: AC – author | RC – referee | CC – community | EC – editor | CEC – chief editor | : Report abuse
  • RC1: 'Comment on gi-2024-3', Anonymous Referee #1, 06 Aug 2024
    • AC1: 'Reply on RC1', Erik Bollen, 09 Aug 2024
  • RC2: 'Comment on gi-2024-3', Maxim V. Philippov, 23 Sep 2024
    • AC2: 'Reply on RC2', Erik Bollen, 26 Sep 2024
      • RC3: 'Reply on AC2', Maxim V. Philippov, 27 Sep 2024
Erik Bollen, Rik Hendrix, and Bart Kuijpers
Erik Bollen, Rik Hendrix, and Bart Kuijpers

Viewed

Total article views: 457 (including HTML, PDF, and XML)
HTML PDF XML Total BibTeX EndNote
320 105 32 457 9 9
  • HTML: 320
  • PDF: 105
  • XML: 32
  • Total: 457
  • BibTeX: 9
  • EndNote: 9
Views and downloads (calculated since 28 Jun 2024)
Cumulative views and downloads (calculated since 28 Jun 2024)

Viewed (geographical distribution)

Total article views: 450 (including HTML, PDF, and XML) Thereof 450 with geography defined and 0 with unknown origin.
Country # Views %
  • 1
1
 
 
 
 
Latest update: 07 Oct 2024
Download
Short summary
Transportation networks, such as road or river systems and electricity grids, are often equipped with various sensors that produce vast amounts of data that reflect real-life situations on these networks. We present an all-in-one data management solution to deal with these data. Our solution addresses both the storage and querying of such data and is based on a theoretical database model and query logic. In addition, this is implemented and tested on real-life datasets.