A database management system for information retrieval and documentation of experiments for plant breeders

Andrews, D. J.; Hardwick, R. C.

doi:10.1007/bf00021641

Cited by 7 publications

(4 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…These customary requirements, well described by many authors are as follows : 1) The database is used to avoid some clerical operations . This is suggested by Andrews & Hardwick (1982) and by Brown (1984) who wrote that a database could alleviate some of the time that a breeder has to spend in maintaining material and hence allow more time for plant breeding . As a result, a database is a mean to save time and labour because it decreases the number of clerical operations .…”

Section: Discussionmentioning

confidence: 99%

“…With such processing, it is possible to illustrate that the database is a good way of saving time and limiting clerical operations . 2)As many authors have pointed out (Andrews & Hardwick, 1982 ;Brown, 1984), a database must be reliable . In our case, the reliability is dependant upon the Oracle Relational Database Management System which can manage special files and many locks, and on the generation of fault messages in order to prevent the user from making errors .…”

Section: Discussionmentioning

confidence: 99%

See 1 more Smart Citation

A database for a more efficient perennial ryegrass breeding programme

1992

View full text Add to dashboard Cite

The development and use of a computer database specifically designed to be used to store data from a plant breeding programme on perennial ryegrass (Lolium perenne) is described . Setting up a database requires data analysis in order to establish a conceptual dat model and a conceptual processing data . Every model has been written with MERISE method . With the models, a database has been built using ORACLE relational database management system . It is tailored to meet our own requirements which may be common to other database users .

show abstract

Section: Discussionmentioning

confidence: 99%

Section: Discussionmentioning

confidence: 99%

A database for a more efficient perennial ryegrass breeding programme

1992

View full text Add to dashboard Cite

show abstract

“…Plant breeders typically deal with hundreds or thousands of genotypes for which they need to manage seed lots and store performance data and genealogical information. Some breeders used databases before the advent of the microcomputer (Andrews and Hardwick, 1982;Andrews et al, 1978). Later work includes that of Mulitze (1990).…”

Section: Databases In Agroecological Researchmentioning

confidence: 99%

A Database for Agroecological Research Data: I. Data Model

Evert¹,

Spaans

Krieger

et al. 1999

Agronomy Journal

View full text Add to dashboard Cite

Data from agroecological experiments are typically stored in a collection of minimally documented computer files, with additional information entered into field or lab books. As a result of this fragmentation of data and lack of proper documentation, information may be lost and data manipulation is generally cumbersome, error‐prone, and hard to automate. Modern database technology has the potential to resolve these issues. Storing experiment data in a database solves the problem of fragmentation because all data are in the database; the problem of documentation is solved by making the relations between different items of information explicit during the design of the database; and the problem of manipulation is solved by the powerful query languages available with modern database management systems. As a first step in the construction of a generally applicable database for use in agroecological research, we used a formal method to design a data model that explicitly describes the types of information (‘entities’) one may want to remember about experiments and the relationships between these entities. The data model described here consists of 40 entities and 54 relationships. The entities are classified in five categories: (i) experiments, including statistical design; (ii) objects on which measurements are made; (iii) measurement protocol and equipment; (iv) measurements; and (v) field operations. We describe in detail how the information from several common types of measurements is stored using the proposed data model and conclude that the data model adequately describes the information that scientists in agroecological disciplines need to remember about their experiments.

show abstract

“…ROGERS (1975), TALBOT & ROBINSON (1980) and ANDREws et al . (1978ANDREws et al . ( , 1982 describe but a few.…”

Section: Introductionmentioning

confidence: 99%

A new data base computer package for plant breeders

Brown

1984

Euphytica

View full text Add to dashboard Cite

A computer data base package, specifically designed to be used to store data collected from a plant breeding programme is described . The package will do many of the routine clerical operations involved in plant breeding, such as producing plot labels, field plans, genotype lists and data tabulations. It also has several statistical analysis routines, and routines which allow the user to examine and manipulate data . The package is user friendly since it was designed to be operated by plant breeders rather than computing specialists . Although it was written to handle data collected from a plant breeding programme, the package is flexible and could be used for a number of different applications .

show abstract

A database management system for information retrieval and documentation of experiments for plant breeders

Cited by 7 publications

References 4 publications

A database for a more efficient perennial ryegrass breeding programme

A database for a more efficient perennial ryegrass breeding programme

A Database for Agroecological Research Data: I. Data Model

A new data base computer package for plant breeders

Contact Info

Product

Resources

About