Summary
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.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
Andrews, D.J., R.C. Hardwick & J.M. Hardaker, 1978. A computer-based retrieval scheme for plant breeding material. Euphytica 27: 849–853.
Andrews, D.J. & R.C. Hardwick, 1982. A database management system for information. Retrieval and documentation of experiments for plant breeders. Euphytica 31: 281–285.
Brown, J., 1984. A new database computer package for plant breeders. Euphytica 33: 935–942.
Chen, P., 1976. The entity relationship model; towards a unified view of data. ACM TODS vol I, no 1: 336–346.
Clarke, P.A. & B. Casiero, 1979. A genealogical database for plant propagation records. Euphytica 28: 785–792.
Collongues, A., J. Hugues & B. Laroche, 1986. Merise: méthode de conception. Ed Dunod.
Davenport, R.A., 1978. Data analysis for database design. The Australian Computer Journal 10: 122–137.
Gauthier, L. & R. Kok, 1988. A microcomputer based farm management operating system. Can. Agric. E,g. 30: 69–76.
Hellman, E.W., 1978. An interactive microcomputer program for development and calculation of a plant breeding selection index. Hortscience, 19(6): 812–813.
Hobkirk, D.R., 1986. A database management system for fruit farmers for the comparison of production and financial record. Acta Horticultural 184: 165–172.
Johnson, M.W., B. Snoad & D.R. Davies, 1971. A computer based record system for pisum. Euphytica 20: 126–130.
Mc Nicol, J.W., S.C.M. Ng & R. Kidger, 1982. A data-capture system for agricultural research based on a microcomputer. Expl. Agric. 18: 255–265.
Martiniello, P., 1988. Development of a database computer management system for retrieval on varietal field evaluation and plant breeding information in agriculture. Comput. Electron Agric. 2: 183–192.
Matheron, J.P., 1987. Comprendre Merise. Ed. Eyrolles.
Pasleau, S., 1989. Apprende ORACLE. Ed. P.S.I.
Perry, M., 1988. The Germplasm resources information network. A genetic resources information management system for the United States. Plant Genetic resources newsletter, 73/74: 21–26.
Syme, J.R. & D.G. Butler, 1983. A database for wheat breeding. Proceedings australian plant breeding conference: 351.
Talbot, M. & D.L. Robinson, 1980. CVT — a statistical computing and data management system in agricultural crop research. Computat 7: 81–87.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Ravel, C., Charmet, G. & Balfourier, F. A database for a more efficient perennial ryegrass breeding programme. Euphytica 61, 145–151 (1992). https://doi.org/10.1007/BF00026805
Received:
Accepted:
Issue Date:
DOI: https://doi.org/10.1007/BF00026805