A Database for Agroecological Research Data: I. Data Model

Abstract

Data from agroecological experiments are typically stored in a collection of minimally documented computer files, with additional information entered into field or lab books. As a result of this fragmentation of data and lack of proper documentation, information may be lost and data manipulation is generally cumbersome, error‐prone, and hard to automate. Modern database technology has the potential to resolve these issues. Storing experiment data in a database solves the problem of fragmentation because all data are in the database; the problem of documentation is solved by making the relations between different items of information explicit during the design of the database; and the problem of manipulation is solved by the powerful query languages available with modern database management systems. As a first step in the construction of a generally applicable database for use in agroecological research, we used a formal method to design a data model that explicitly describes the types of information (‘entities’) one may want to remember about experiments and the relationships between these entities. The data model described here consists of 40 entities and 54 relationships. The entities are classified in five categories: (i) experiments, including statistical design; (ii) objects on which measurements are made; (iii) measurement protocol and equipment; (iv) measurements; and (v) field operations. We describe in detail how the information from several common types of measurements is stored using the proposed data model and conclude that the data model adequately describes the information that scientists in agroecological disciplines need to remember about their experiments.

Integration of a Cropping Systems Simulation Model and a Relational Database for Simple Farm‐Scale Analyses

“…Wö sten et al (1999) have developed a relational database to store soil hydraulic data from several sites in Europe: the collation of several data into a single database allowed integrated analyses of the entire data set, in particular the estimation of parameters for moisture retention and hydraulic conductivity functions. Van Evert et al (1999aEvert et al ( , 1999b proposed a very flexible data model for storing data about field experiments, allowing exploring the relationships among different variables measured on different objects at different space and time scales.…”

Big Data for weed control and crop protection

“…The behaviour of relational data can be fully described using set theory (Codd, ). There is ample literature using the relational model to store agricultural data, including work started by decision support system for agrotechnology transfer (DSSAT) and continued by the International Consortium for Agricultural Systems Applications (ICASA) (Hunt et al ., ; White et al ., ) and the Agricultural Model Intercomparison and Improvement Project (AgMIP) (Rosenzweig et al ., ), but also by others (Van Evert et al ., ,b; Steiner et al ., ).…”

Publishing Agronomic Data

“…Entity‐relationship modeling has been used by various agricultural groups. Van Evert et al (1999) described a flexible system for general experimental data with specific relevance to agricultural experiments. The ICASA standards are based on a master list of variables that are interrelated through a relational structure (Hunt et al, 2006).…”