Paper/Poster/Presentation Title
AgroDB – Integration of Database Management Systems with Crop Models
Keywords
Integrative approach; Procedural Languages; Database design; Model coupling.
Location
Session A2: Interoperability, Reusability, and Integrated Systems
Start Date
11-7-2016 2:50 PM
End Date
11-7-2016 3:10 PM
Abstract
The usefulness of crop simulation models for understanding and transferring agricultural technology is widely acknowledged. The decision support system for agrotechnology transfer (DSSAT) has been in use for the last 3 decades by researchers worldwide. The DSSAT-Cropping System Model (CSM) is a general model for simulating crop growth and development, as well as the soil and plant water, nitrogen phosphorus, and carbon dynamics. The DSSAT-CSM comprises a suite of crop simulation models, including the CSM-CROPSIM wheat. However, depending on the type and number of simulations, it is usually necessary to handle large volumes of input and output data. A database management system (DBMS) provides technological resources and accessible methods for handling big data. In this study, we integrate simulation models with a DBMS and we demonstrate the advantages of this approach. We present a database called AgroDB that acts as a generic tool for crop simulation model users, which facilitates input data quality control, tracks the users selections during simulation model parameterization, and enables the visual analysis of simulation model outcomes. In addition, the system serves as communication route for model coupling. We describe a proof of concept application of the database management system approach and evaluate how well our approach meets its goals.
Included in
Civil Engineering Commons, Data Storage Systems Commons, Environmental Engineering Commons, Hydraulic Engineering Commons, Other Civil and Environmental Engineering Commons
AgroDB – Integration of Database Management Systems with Crop Models
Session A2: Interoperability, Reusability, and Integrated Systems
The usefulness of crop simulation models for understanding and transferring agricultural technology is widely acknowledged. The decision support system for agrotechnology transfer (DSSAT) has been in use for the last 3 decades by researchers worldwide. The DSSAT-Cropping System Model (CSM) is a general model for simulating crop growth and development, as well as the soil and plant water, nitrogen phosphorus, and carbon dynamics. The DSSAT-CSM comprises a suite of crop simulation models, including the CSM-CROPSIM wheat. However, depending on the type and number of simulations, it is usually necessary to handle large volumes of input and output data. A database management system (DBMS) provides technological resources and accessible methods for handling big data. In this study, we integrate simulation models with a DBMS and we demonstrate the advantages of this approach. We present a database called AgroDB that acts as a generic tool for crop simulation model users, which facilitates input data quality control, tracks the users selections during simulation model parameterization, and enables the visual analysis of simulation model outcomes. In addition, the system serves as communication route for model coupling. We describe a proof of concept application of the database management system approach and evaluate how well our approach meets its goals.
