My Account: Log In | Join | Renew
Search
Author
Title
Vol.
Issue
Year
1st Page

Abstract

 

This article in AJ

  1. Vol. 93 No. 4, p. 923-928
     
    Received: Sept 11, 2000
    Published: July, 2001


    * Corresponding author(s): jmshine@scgc.org
 View
 Download
 Alerts
 Permissions
 Share

doi:10.2134/agronj2001.934923x

A Relational Database for Agronomic and Genealogical Sugarcane Data

  1. Eric T. Stafnea,
  2. James S. Brownb and
  3. James M. Shine *c
  1. a Dep. of Hortic., Univ. of Arkansas, 316 Plant Sci., Fayetteville, AR 72701
    b USDA-ARS, Subtropical Hortic. Res. Stn., 13601 Old Cutler Rd., Miami, FL 33158
    c Jr., Sugarcane Growers Coop. of Florida, P.O. Box 666, Belle Glade, FL 33430

Abstract

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. American Society of AgronomyPublished in Agron. J.93:923–928.