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) : 214-218.

Url - jeu de données - Dataverse Cirad : https://doi.org/10.18167/DVN1/1GCL8F / Url - autre : https://www.researchgate.net/publication/317434037_ECOFI_A_new_generic_database_to_analyse_complex_agroecological_experimentation

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

Résumé : 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.

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 et information
F01 - Culture des plantes
F08 - Systèmes et modes de culture

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

Auteurs et affiliations

• Auzoux Sandrine, CIRAD-PERSYST-UPR AIDA (FRA) ORCID: 0000-0002-8764-8672
• Martiné Jean-François, CIRAD-PERSYST-UPR AIDA (FRA)
• Loison Romain, CIRAD-PERSYST-UPR AIDA (FRA) ORCID: 0000-0001-6562-658X
• Poser Christophe, CIRAD-PERSYST-UPR AIDA (FRA)
• Marnotte Pascal, CIRAD-PERSYST-UPR AIDA (REU)
• Goebel François-Régis, CIRAD-PERSYST-UPR AIDA (FRA) ORCID: 0000-0002-5438-1078

Source : Cirad-Agritrop (https://agritrop.cirad.fr/584134/)

Métriques

[ Page générée et mise en cache le 2024-04-04 ]