ECOFI: A new generic database to analyse complex agroecological experimentation

Auzoux Sandrine, Martiné Jean-François, Loison Romain, Poser Christophe, Marnotte Pascal, Goebel François-Régis. 2017. ECOFI: A new generic database to analyse complex agroecological experimentation. International Sugar Journal, 119 (1419) : pp. 214-218.

Journal article ; Article de recherche ; Article de revue à facteur d'impact
[img] Published version - Anglais
Access restricted to CIRAD agents
Use under authorization by the author or CIRAD.
2017 Auzoux et al International Sugar Journal.pdf

Télécharger (2MB) | Request a copy

Quartile : Q4, Sujet : FOOD SCIENCE & TECHNOLOGY / Quartile : Q4, Sujet : AGRONOMY

Abstract : Agroecological studies on sugarcane dealing with genotype by environment by management interactions commonly generate complex datasets. Data are collected separately and can be multi-scale (from phytomer to field), multi-species (sugarcane and companion plants), and multi-disciplinary (agronomy, entomology, ecophysiology, weed science, etc), making their use complex in system data analysis. This paper presents a solution to manage these heterogeneous data using database and metadata technology. A relational database, named ECOFI, was designed from the analysis of the content and the structure datasets of multi-disciplinary experiments with sugarcane. The results of this analysis showed that most datasets shared data corresponding to common environmental by management factors and the same measurements, such as yield, weed occurrence and insect incidence. However, each of them had its own structure. To analyse biology by environment by management interactions efficiently, the structure of ECOFI was built into three parts: the environmental conditions, the agricultural practices, and the impacts observed on biotic and abiotic variables using agronomic measurements. In standard databases, each additional observed variable generally forces an update to the existing database model. The model of the ECOFI database does not require such modification. Taking into account a new variable is very easy, consisting solely of the addition of a new record in a table, after having stored the new variable label and its definition (unit, type, scale) in a generic metadata table. This technology minimizes the number of tables, columns and empty cells and improves database query performance. ECOFI is already used to manage, explore and analyse the data from agroecological experiments, ecophysiological observations and sugarcane modelling in Reunion Island and other sugar-producing countries. ECOFI is a generic database that improves analysis and facilitates access to multi-disciplinary and multi-scale data. Its data model can be applied to any type of project. (Résumé d'auteur)

Mots-clés Agrovoc : Saccharum officinarum, Banque de données, Expérimentation, agroécologie, Génétique, pratique agricole, Facteur du milieu, Évaluation de l'impact

Mots-clés libres : Generic data schema, Metadata technology, Relational database, Interoperability

Classification Agris : C30 - Documentation and information
F01 - Crop husbandry
F08 - Cropping patterns and systems

Champ stratégique Cirad : Axe 1 (2014-2018) - Agriculture écologiquement intensive

Auteurs et affiliations

Source : Cirad-Agritrop (

View Item (staff only) View Item (staff only)

[ Page générée et mise en cache le 2020-09-10 ]