A New Sensor-Based Spatial OLAP Architecture Centered on an Agricultural Farm Energy-Use Diagnosis Tool

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.