A Database for Agroecological Research Data: II. A Relational Implementation

Abstract

With the goal of creating a generally applicable database for agroecological research data, we developed and described a data model. The objective of the present work was to determine the practical usefulness of a database implemented from that data model. We used a commercially available relational database management system and mapped the entities of the logical data structure to tables, entity attributes to table columns, and entity relationships to foreign keys. The attributes of the entity representing measurement values were distributed over two tables, both to reduce the size of the database and to reduce the response time of queries involving this entity. We found that loading data into the database was the most significant hurdle to its use, and so developed a set of stored procedures that function as a data input language. The input language and other methods were used to load the data from an intensively monitored, multisite, multiyear experiment into the database. The database was used to manage, explore, and analyze the data from these experiments, as well as to share the data between collaborators and with others in an effective way. We conclude that a database implemented from the previously designed data model is a practical and extremely useful tool for research.

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 ., ).…”

Data management approach to multidisciplinary agricultural research and syntheses

“…For a discussion of relational databases for agroecological research, see van Evert et al (1999). Through the use of Google web services, these data repositories are automatically synced via custom software to the local database at ISU.…”