2017/12/20 by Émilie Donnat, D. Boffety, Donnat, Emilie +24
Agricultural and Biological Sciences · #Capteur #Energetic performance #Entrepôt de données spatiales #Food Supply Chain Traceability #Indicateur #Indicator #Performance énergétique #Sensor #Spatial data warehouse
paper · doi:10.15454/1.51377788991795e12
openalex publication_date 2017/12/20 · openalex created_date 2022/10/04 · openalex updated_date 2026/07/25
Agricultural energy consumption is an important issue that concerns the international community for environmental and economic reasons. Technology of data warehouse and multidimensional database opens the door to new solutions for collect and decisional use of data. These technologies enable to have access, on collected and stored data, to a whole range of indicators resulting from aggregated operations (sum, mean) in function of different criteria (period of time, type of machine, type of work or management entity). In this project, integration chains of information from the sensor to the indicator have been developed for gas consumptions in mobile farm equipment (for cultures) and for electricity and water consumption in breeding buildings (cow and goat breeding) and for irrigation. The use of data collected thanks to the technological solutions implemented on the field, then their integration in the data warehouse in order to establish relevant indicators of the energetic consumption enables monitoring in real time and traceability of energy consumption at different scales of the farm, through dashboard instrument panel and diagnosis. This project has led to technological solutions to obtain reliable data, on a data warehouse able to integrate heterogeneous data in terms of quality and granularity at an accurate scale, in order to provide reliable performance indicators.