home    about    browse    search    latest    help 
Login | Create Account

A user-friendly database for Participatory Plant Breeding programs

Rosenfeld, Simon; Parzies, Heiko; Grando, Stefania and Ceccarelli, Salvatore (2010) A user-friendly database for Participatory Plant Breeding programs. In: Goldringer, Isabelle; Dawson, Julie; Rey, Frédéric and Vettoretti, Alice (Eds.) Breeding for resilience: a strategy for organic and low-input farming systems?, INRA, ITAB, France, p. 146.

[thumbnail of Poster: A user-friendly database for Participatory Plant Breeding programs]
PDF - Updated Version - English (Poster: A user-friendly database for Participatory Plant Breeding programs)
Available under License Creative Commons Attribution.


Document available online at: http://www.eucarpia.org/organic-and-low-input-agriculture/119-breeding-for-resilience-a-strategy-for-organic-and-low-input-farming-systems.html


In a decentralized and participatory plant breeding (PPB) program, in contrast to conventional plant breeding, farmers select from a large number of genotypes over a number of cycles in several locations. As selection is for location-specific adaptation a PPB program based on, for example, four stages of selection, generates large, unbalanced data sets. With common spreadsheet software it is not possible, or it is at least very cumbersome to extract all the information, particularly the one that is related to genotype x environment (GE) interactions. Therefore, there is a need for an information system that makes it as easy as possible to retrieve and compare data over all given factors in the PPB-program. Due to a lack of education and financial resources in developing countries, the use of existing databases was not an option because of their complexity and/or price. We have built a simple, free and user-friendly database that allows to store, retrieve and analyze the plant breeding data. The database is implemented using the Java based HyperSQL Database Engine (HSQLDB) in the package of Open Office with links to the input formats of Genstat and GGEbiPlot. The proposed database is capable of managing the following data in a PPBprogram for barley: (I) trial data for any trial or field design (II) field data for any given trait (III) results from statistical analyses (IV) farmers selection individually or in groups.

EPrint Type:Conference paper, poster, etc.
Type of presentation:Poster
Keywords:PPP, Database, Statistical analyses, Open source, GxE, plant breeding
Agrovoc keywords:
Subjects: Knowledge management > Research methodology and philosophy > Systems research and participatory research
Crop husbandry > Breeding, genetics and propagation
Research affiliation:Other countries
Germany > University of Hohenheim > Department of Plant Breeding, Seed Science and Population Genetics
Deposited By: Rosenfeld, MSc Simon
ID Code:27718
Deposited On:17 Feb 2015 11:05
Last Modified:17 Feb 2015 11:09
Document Language:English
Refereed:Peer-reviewed and accepted

Repository Staff Only: item control page


Downloads per month over past year

View more statistics