A new sensor-based Spatial OLAP architecture centered on an agricultural farm energy-use diagnosis - INRAE - Institut national de recherche pour l’agriculture, l’alimentation et l’environnement Access content directly
Journal Articles International Journal of Decision Support System Technology Year : 2014

A new sensor-based Spatial OLAP architecture centered on an agricultural farm energy-use diagnosis

Une architecture SOLAP basé sur les capteurs et un outil ACV

Abstract

Agricultural energy consumption is an important environmental and social issue. Several diagnosis tools have been proposed to define indicators for analyzing the large-scale energy consumption of agricultural farm activities (year, farm, production activity, etc.). In Bimonte, Boulil, Chanet and Pradel (2012), the authors define (i) new appropriate indicators to analyze agricultural farm energy-use performance on a detailed scale and (ii) show how Spatial Data Warehouse (SDW) and Spatial OnLine Analytical Processing (SOLAP) GeoBusiness Intelligence (GeoBI) technologies can be used to represent, store, and analyze these indicators by simultaneously producing graphical and cartographic reports. These GeoBI technologies allow for the analysis of huge volumes of georeferenced data by providing aggregated numerical values visualized by means of interactive tabular, graphical, and cartographic displays. However, existing data collection systems based on sensors are not well adapted for agricultural data. In this paper, the authors show the global architecture of our GeoBI solution and highlight the data collection process based on agricultural ad hoc sensor networks, the associated transformation and cleaning operations performed by means of Spatial Extract Transform Load (ETL) tools, and a new implementation of the system using a web-services-based loosely coupled SOLAP architecture to provide interoperability and reusability of the complex multi-tier GeoBI architecture. Moreover, the authors detail how the energy-use diagnosis tool proposed in Bimonte, Boulil, Chanet and Pradel (2012) theoretically fits with the sensor data and the SOLAP approach.

Keywords

No file

Dates and versions

hal-02599687 , version 1 (16-05-2020)

Identifiers

Cite

Sandro Bimonte, Marilys Pradel, Daniel Boffety, Aurélie Tailleur, Géraldine André, et al.. A new sensor-based Spatial OLAP architecture centered on an agricultural farm energy-use diagnosis. International Journal of Decision Support System Technology, 2014, 5 (4), pp.1-20. ⟨hal-02599687⟩
8 View
0 Download

Share

Gmail Mastodon Facebook X LinkedIn More