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.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
customersupport@researchsolutions.com
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Copyright © 2025 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.