• A user-friendly NoSQL framewor...

Treffer: A user-friendly NoSQL framework for managing agricultural field trial data.

Title:
A user-friendly NoSQL framework for managing agricultural field trial data.
Authors:
Wu SH; Department of Agronomy, National Taiwan University, Taipei, Taiwan. stevenwu@ntu.edu.tw., Mueller TA; Pivot Bio, Sheboygan, WI, USA.
Source:
Scientific reports [Sci Rep] 2024 Nov 30; Vol. 14 (1), pp. 29819. Date of Electronic Publication: 2024 Nov 30.
Publication Type:
Journal Article
Language:
English
Journal Info:
Publisher: Nature Publishing Group Country of Publication: England NLM ID: 101563288 Publication Model: Electronic Cited Medium: Internet ISSN: 2045-2322 (Electronic) Linking ISSN: 20452322 NLM ISO Abbreviation: Sci Rep Subsets: MEDLINE
Imprint Name(s):
Original Publication: London : Nature Publishing Group, copyright 2011-
MeSH Terms:
Agriculture*/methods, Databases, Factual ; User-Computer Interface ; Software ; Database Management Systems ; Humans ; Internet
References:
PLoS One. 2010 Jul 12;5(7):e11405. (PMID: 20635001)
Agric Syst. 2017 Jul;155:191-199. (PMID: 28701812)
Cell Host Microbe. 2019 Aug 14;26(2):183-192. (PMID: 31415751)
Grant Information:
MOST 111-2313-B-002-007-MY3 Ministry of Science and Technology, Taiwan
Contributed Indexing:
Keywords: Amazon Web Services (AWS); DynamoDB; Field trial; NoSQL database; Web application
Entry Date(s):
Date Created: 20241130 Date Completed: 20241130 Latest Revision: 20241203
Update Code:
20250114
PubMed Central ID:
PMC11608345
DOI:
10.1038/s41598-024-81609-2
PMID:
39616207
Database:
MEDLINE

Weitere Informationen

Field trials are one of the essential stages in agricultural product development, enabling the validation of products in real-world environments rather than controlled laboratory or greenhouse settings. With the advancement in technologies, field trials often collect a large amount of information with diverse data types from various sources. Managing and organizing extensive datasets can impose challenges for small research teams, especially with constantly evolving data collection processes with multiple collaborators and introducing new data types between studies. A practical database needs to be able to incorporate all these changes seamlessly. We present DynamoField, a flexible database framework for collecting and analyzing field trial data. The backend database for DynamoField is powered by Amazon Web Services DynamoDB, a NoSQL database, and DynamoField also provides a front-end interactive web interface. With the flexibility of the NoSQL database, researchers can modify the database schema based on the data provided by various collaborators and contract research organizations. This framework includes functions for non-technical users, including importing and exporting data, data integration and manipulation, and performing statistical analysis. Researchers can utilize cloud computing to establish a secure NoSQL database with minimum maintenance, this also enables collaboration with others worldwide and adapt to different data-collecting strategies as their research progresses. DynamoField is implemented in Python, and it is publicly available at https://github.com/ComputationalAgronomy/DynamoField .
(© 2024. The Author(s).)

Declarations. Competing interests: The authors declare no competing interests.