A Relational Database for Agronomic and Genealogical Sugarcane Data
- Eric T. Stafnea,
- James S. Brownb and
- James M. Shine *c
A comprehensive relational database has been created at the USDA-ARS Canal Point Sugarcane Field Station to facilitate the entry and retrieval of data for the breeding program using Microsoft Access 2000. This software is readily available and easily adaptable to a wide variety of breeding programs. A relational database provides an efficient and powerful way to store, retrieve, manipulate, query, and report data in a multiuser environment. Data entry is performed through a series of self-explanatory forms. Once entered, data can be accessed and queried through a local area network (LAN). Data from the seedling stage (true seed planting), Stage I and Stage II (the first two clonally propagated selection stages at Canal Point), and Stage IV (the final selection stage before cultivar release) of the breeding program have currently been included in the database. The database also includes the Canal Point clonal collection inventory, crossing information, seed (fuzz) inventory, and pedigree tracking. Future plans include incorporation of data from Stage III (the next to last clonally propagated selection stage), pathology data, and access through the Canal Point Internet web site (www.canalpoint.sugarcane.usda.gov).Please view the pdf by using the Full Text (PDF) link under 'View' to the left.
Copyright © 2001.