Skip to main content
SpringerLink
Log in

A relational database system for potato breeding programs

  • Published:
American Journal of Potato Research Aims and scope Submit manuscript

Abstract

Using a desktop database management system (DBMS), a relational database system was developed to replace outdated systems for data storage, retrieval and summary in a potato breeding research program. The new system allows for easy and efficient access, storage and interrelation of potato data, and automated reporting functions to support presentation and analysis requirements of the research program. DBMS tools and programmed functions provide summary information pertaining to such areas as potato plant genealogy and progeny performance in early selection, regional adaptation and disease resistance trials. Database structures have been implemented to facilitate the collection and verification of new data, interface to a hand-held data collection computer, and transfer report data and charts to standard word processing and presentation software. The concepts and techniques used in the construction of this database system can be applied to other potato and plant breeding programs

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

Literature Cited

  • Litwin, P., K. Getz, and M. Gilbert. 1997. Access 97 Developer’s Handbook. 3rded. SYBEX Inc., San Francisco, CA. 1544 pp.

    Google Scholar 

  • Elmasri, R., and Navathe S.B. 1994. Fundamentals of Database Systems. 2nded. The Benjamin/Cummings Publishing Company, Inc., Redwood City, CA. 873 pp.

    Google Scholar 

  • Lynch, D.R. and G.C. Kozub. 1988. An analysis of the response of nine potato genotypes to five prairie environments. Can J Plant Sci 68:1219–1228.

    Google Scholar 

  • Lynch, D.R. and G.C. Kozub. 1991. The association between potato tuber yield and the components of yield in irrigated and dryland environments in the prairies. Can J Plant Sci 71:279–287.

    Google Scholar 

  • Lynch, D.R. and E.L. Dyck. eds. 1982–1993. Prairie Potato Regional Trial Report. Agriculture and Agri-Food Canada, Lethbridge Research Centre, Lethbridge. Alberta. TlJ 4B1

    Google Scholar 

  • Que Development Group. 1994. Using Paradox 5 for Windows. Special ed. Que Corporation, Hollis, NH. 1200 pp.

    Google Scholar 

  • SAS Institute Inc. 1989. SAS/STAT User’s Guide, version 6. 4thed. SAS Institute Inc., Cary, NC. 1686 pp.

    Google Scholar 

  • Borland International Inc. 1992. Paradox 7 for Windows 95, version 7. 564 pp.

Download references

Author information

Authors and Affiliations

  1. Agriculture and Agri-Food Canada, Research Centre, P.O. Box 3000, TlJ 4B1, Lethbridge, Alberta, Canada

    J. G. Kozub, D. R. Lynch, G. C. Kozub (Retired), L. M. Kawchuk & D. K. Fujimoto

Authors
  1. J. G. Kozub
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. D. R. Lynch
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. G. C. Kozub
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. L. M. Kawchuk
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. D. K. Fujimoto
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to D. R. Lynch.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Kozub, J.G., Lynch, D.R., Kozub, G.C. et al. A relational database system for potato breeding programs. Am. J. Pot Res 77, 95–101 (2000). https://doi.org/10.1007/BF02853736

Download citation

  • Accepted:

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF02853736

Additional Key Words

Search

Navigation