Accéder directement au contenu Accéder directement à la navigation
Article dans une revue

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

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.
Mots-clés : OLAP
Type de document :
Article dans une revue
Liste complète des métadonnées
Déposant : Migration Irstea Publications <>
Soumis le : samedi 16 mai 2020 - 03:18:43
Dernière modification le : jeudi 10 décembre 2020 - 16:06:03


  • HAL Id : hal-02599687, version 1
  • IRSTEA : PUB00040803



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, IGI Global, 2014, 5 (4), pp.1-20. ⟨hal-02599687⟩



Consultations de la notice