You are here Home>Research>Database

 Database?

 Definition : A database is a collection of information (raw data processed) that is organized so that it can easily be  accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic,  full-text, numeric, and images.  

 In computing, databases are sometimes classified according to their organizational approach. The most prevalent approach  is the relational database , a tabular database in which data is defined so that it can be reorganized and accessed in a  number of different ways. A distributed database is one that can be dispersed or replicated among different points in a  network.

 Computer databases typically contain aggregations of data records or files, such as passport data information, seeds  distribution data, and cooperators profiles. Typically, a database manager provides users the capabilities of controlling   read/write access, specifying report generation, and analyzing usage. Databases and database managers are prevalent in   large mainframe systems, but are also present in smaller distributed workstation and mid-range systems such as the   AS/400 and on personal computers. SQL (Structured Query Language) is a standard language for making interactive   queries from and updating a database such as IBM's DB2 , Microsoft's Access, and database products from SQL Server,   Oracle , Sybase , and Computer Associates .

Wagis database structure

Passport data information

   
 S/No
Field name Field description attribute code attribute description
1
Accn WARDA Accession Number
2
GenusSpeciesCode WARDA Genus species code TOb Oryza barthii
TOg Oryza glaberrima
TOl Oryza logistaminata
TOp Oryza punctata
TOs Oryza sativa
W/R Wild Rice - Specie not specified
3
Name Cultivar Name
4
Instcode Institution code
5
Country Country of Origin
6
Colno Collection code
7
Coldate Collection Date
8
Latitude Source Latitude
9
Longtude Source Longitude
10
Ecozone Ecological Zone 1 Forest
2 Transition Zone
3 Derived Savanna
4 Guinea Savanna
5 Sudan Savanna
6 Sahel Savanna
7 Highland/Mountain
11
Ecosys Ecological System 1 Dryland
2 Hydromorphic
3 Shallow Forest Swamp
4 Deep Forest Swamp
5 Floating Rice
6 Mangrove Swamp
7 Irrigation
12
Status Biological Status at Source 1 Wild
2 Weed
3 Cultivated
13
Freq Frequency of Occurence 1 Abundant
2 Frequent
3 Occassional
4 Rare
14
Source Descriptn of source where the material is collectd 1 Crop
2 FarmStore
3 Market
4 Wild Vegetation
5 Other Institute
15
Collector Collectors Name
16
Locat Location
17
Pedigree Pedidree
18
Cycle Cycle
19
High the height
20
Objectif Objectif
21
TRL Year of Trial
22
STN Stock Not sorted
23
Swp % germination test
24
STA Stability and adaptability
25
SEN Sender
26
Cooperator_code Cooperator code
27
Collmisscode collection mission code
28
PhotoGrain Grain picture
29
PhotoPlant picture of the plant
30
FaoTrust Whether the accession been designated as an "in-trust" accession.
31
Traditional Whether the accession is traditional or not (1/0)

Characterization data information

S/No
Field name Field description attribute code attribute description
1
BLDPUB Blade pubescence 1 Glabrous
2 Intermediate
3 Pubescent
2
BLDCOL Blade color 1 Pale green
2 Green
3 Dark green
4 Purple tips
5 Purple margins
6 Purple blotch
7 Purple
3
BSLCOL Basal leafsheat color 1 Green
2 Purple lines
3 Light purple
4 Purple
4
LFANGL Leaf angle n=5 1 Erect
5 Horizontal
9 Drooping
5
FLGANGL Flag leaf angle n=5 1 Erect
2 Intermediate
5 Horizontal
7 Descending
6
LIGLEN Ligule length (cm) n=5
7
LIGCOL Ligule color 1 White
2 Purple lines
3 Purple
8
LIGSHP Ligule shape 1 Acuminate
2 Intermediate
3 Truncate
9
COLCOL Collar color 1 Pale green
2 Green
3 Purple
10
AURCOL Auricle color 1 Pale green
2 Purple
11
LFLEN Blade or leaf length (cm) n=5
12
LFWID Blade or leaf width (cm) n=5
13
CULMNO Culm No - number per plant n=5
14
PRCUNO Production culm number
15
CULMANG Culm angle 1 Erect
3 Intermediate
5 Open
7 Spreading
9 Procumbent
16
DIAM Diameter of basal internode mm
17
INTCOL Internode color 1 Green
2 Light gold
3 Purple lines
4 Purple
18
CULMST Culm strength(lodging) 3 Moderately strong:most plants showing leaning
5 Intermediate:most plants moderately lodged
7 Weak:most plants nearly flat
9 Very weak:all plants flat
19
PANLEN Panicle length (cm) panicle base to tip ,n=5
20
PANTYPE Panicle type 1 Compact
5 Intermediate
9 Open
21
SECBRCH Secondary branching 0 Absent
1 Light
2 Heavy
3 Clustering
22
EXSERT Panicle exsertion 1 Well exserted
3 Moderately well exserted
5 Just exserted
7 Partly exserted
9 Enclosed
23
AXIS Panicle axis (at maturity) 1 Straight
2 Droopy
24
SHATRING Panicle shattering 1 Very low,less than 1 %
3 Low, 1-5%
5 Moderate, 6-25%
7 Loose, 26-50%
9 High, more than 50 %
25
THRESH Threshability 1 Difficult
5 Intermediate
9 Easy
26
AWNG Awning 0 Absent
1 Short and partly awned
5 Short and fully awned
9 Long and fully awned
27
AWNCOL Awn color 1 Straw
2 Gold
3 Brown (tawny)
4 Red
5 Purple
6 Black
28
APICOL Apiculus color 0 Colorless-white
1 Straw
2 Brown (tawny)
3 Red
4 Red apex
5 Purple
6 Purple apex
46
STGCOL Stigma color 0 Colorless (white)
1 Light green
2 Yellow
3 Light purple
4 Purple
29
LPCOL Lemma and palea color 0 Straw
1 Gold
2 Brown spots on straw
3 Brown furrows on straw
4 Brown (tawny)
5 Red
6 Purple spots on straw
7 Purple furrows on straw
8 Purple
9 Black
30
LPPUB Lemma and palea pubescence 1 Glabrous
2 Hairs on lemma keel
3 Hairs on upper portion
4 Short hairs
5 Long hairs (velvety)
31
STELCOL Sterile lemma color 1 Straw (yellow)
2 Gold
3 Red
4 Purple
32
STELLEN Sterile lemma length 5

Long (2.6cm but shorter

than the lemma)

7

Extra long (equal to or longer

than the lemma)

9 Assymetrical
3 Medium (1.6-2.5mm)
1 short(not longer than 1.5mm)
0 absent
33
SPFER Spikelet fertility 1 Highly fertile (>90%)
3 Fertile (75-90%)
5 Partly sterile (50-75%)
7 Highly sterile (<50%)
9 Completely sterile (0%)
34
GW100 100 grain weight
35
GRL Grain length (mm) n=10
36
GRW Grain width (mm) n=10
37
SCOL Seedcoat (bran) color 0 Colorless (white)
1 Light brown
2 Speckled brown
3 Brown
4 Red
5 Variable purple
6 Purple
38
ENDTYPE Endosperm type 1 Non-glutinous (non-waxy)
2 Glutinous (waxy)
39
SCENT Scent 0 Non-scented
1 Lightly scented
2 Scented
40
LFSEN Leaf senescence 1 Late and slow
5 Intermediate
9 Early and fast
41
DAM

Days to maturity:seeding to

85% grains are mature

42
DAH Days to 50% heading
43
CULML

Culm length

(soil surface to panicle base,n=5)

44
Seedht

Seedling height

(cm) 35-45 DAS,5-leaf stage,n=10

45
Lflen Blade or leaf length (cm) n=5
46
Lfwid Blade or leaf width (cm) n=5
47
Liglen Ligule length (cm) n=5
48
Dah Days to 50% heading
49
Culml Culm No - number per plant n=5
50
Prcuno Production culm number
51
Diam Diameter of basal internode mm
52
Gw100 100 grain weight
53
Grl Grain length (mm) n=10
54
Grw Grain width (mm) n=10
55
Dam Days to maturity:seeding to 85% grains are mature
     
     
     
     
     
     
 

Back

√: January 07, 2007

 


Fair use of this material is encouraged. Proper citation is requested. © Africa Rice Center 2007