Premium
A Relational Database for Agronomic and Genealogical Sugarcane Data
Author(s) -
Stafne Eric T.,
Brown James S.,
Shine James M.
Publication year - 2001
Publication title -
agronomy journal
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.752
H-Index - 131
eISSN - 1435-0645
pISSN - 0002-1962
DOI - 10.2134/agronj2001.934923x
Subject(s) - selection (genetic algorithm) , relational database , database , the internet , computer science , point (geometry) , variety (cybernetics) , field (mathematics) , stage (stratigraphy) , world wide web , biology , mathematics , artificial intelligence , paleontology , geometry , pure mathematics
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 ).