About Us | Help Videos | Contact Us | Subscriptions

Agronomy Journal Abstract - SOFTWARE

A Relational Database for Agronomic and Genealogical Sugarcane Data


This article in AJ

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

    * Corresponding author(s): jmshine@scgc.org
Request Permissions

  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


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.