A database for agroecological research data: II. A relational implementation

With the goal of creating a generally applicable database for agroecological research data, wt 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 wag. We conclude that a database implemented from the previously designed data model is a practical and extremely useful tool for research.