On the Use of Virtual Knowledge Graphs to Improve Environmental Sensor Data Accessibility
Jiantao Wu, Fabrizio Orlandi, Declan O’Sullivan, Soumyabrata Dev · IEEE Journal of Selected Topics in Applied Earth Observations and Remote Sensing · 2024
The rapid proliferation of Environmental Sensor Networks (ESNs) used for monitoring environmental systems such as meteorology and air quality, as well as advances in database technologies (e.g., SQL) has made significant progress in sensor data management. Notwithstanding the strength of these databases, they can inevitably lead to a data heterogeneity problem as a result of isolated databases with distinct data schema, which are expensive to be accessed and pre-processed when the data is consumed spanning multiple databases. Recently, knowledge graphs have been used as one of the most popular integration frameworks to address this data heterogeneity problem from the perspective of establishing an interoperable semantic schema (a.k.a.ontology). However, the majority of proposed knowledge graphs in this domain are a product of an ETL (Extraction-Transform-Load) approach with all the data physically stored in a triplestore. In contrast, this paper examines an approach of virtualizing knowledge graphs on top of the SQL databases as the means to provide a federated data integration approach for enhanced heterogeneous Environmental Sensor Networks' data access, bringing with it the promise of more cost-efficiency in terms of I/O, storage,etc. In addition, this work also considers some motivating application scenarios regarding the efficiency of time series data access. Based on a performance comparison between the proposed integration approach and some popular triplestores, the proposed approach has a significant edge over triplestores in multiple time series structuring and acquisition.