Document sans titre

About us

Research

Events

Publications

General

Links

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