The “Internet of Water” project will deploy 2,500 sensors along the Flemish river system, in Belgium. These sensors will be part of a monitoring system. This will produce an enormous amount of data, on which prediction and analysis tasks can be performed. To represent, store, and query river data, relational databases are normally used. However, this choice introduces an “impedance mismatch” between the conceptual representation (typically a graph) and the storage model (relational tables). To solve this problem, this article proposes to use graph databases. The Flemish river system is presented as a use case and the Neo4j graph database and its high-level query language, Cypher, are used for storing and querying the data, respectively. A relational alternative is implemented over the PostgreSQL database. A collection of representative queries of interest for hydrologists is defined over both database implementations.

中文翻译：

---

迈向水互联网：使用图形数据库对弗拉芒河流系统进行水文分析

“水互联网”项目将在比利时的佛兰德河系统沿线部署 2,500 个传感器。这些传感器将成为监控系统的一部分。这将产生大量数据，可以在这些数据上执行预测和分析任务。为了表示、存储和查询河流数据，通常使用关系数据库。然而，这种选择在概念表示（通常是图形）和存储模型（关系表）之间引入了“阻抗不匹配”。为了解决这个问题，本文提出使用图数据库。Flemish 河流系统作为一个用例呈现，Neo4j 图数据库及其高级查询语言 Cypher 分别用于存储和查询数据。在 PostgreSQL 数据库上实现了一种关系替代方案。