# Presentation: 528523

## POOL 

- POOL

- Database and Information Service

- July 27, 2006Jitka Deyl

## What is POOL ?

**P**edigree **O**f **O**at **L**ines
- relational database in Microsoft Access
- database of pedigrees and background  information of oat lines and cultivars
- tool for breeders to find both the ancestry and descendants of oat lines
- publicly accessible database with user friendly web interface

## entities in POOL are “virtual” (this is where it differs from a gene bank)

the most complete collection of oat pedigree data and nomenclature in the world 

- the most complete collection of oat pedigree data and nomenclature in the world

## Where is POOL?

- Agriculture and Agri-Food Canada
-     960 Carling Avenue, Ottawa, Ontario K1A 0C6
_**http://avena.agr.gc.ca/**_
- A  Curated  Internet  Database of  Oat Pedigrees, N. Tinker and J. Deyl, Crop Sci. 45: 2269–2272

## How?

## From where?

- cultivar registrations in North America, Australia, and Europe
- breeders notes from different breeding programs
- oat tests conducted in Americas
- agricultural research & breeding institutions
- university breeding programs

- BREEDING RESULTS:

## JOURNALS & PERIODICALS INCLUDING:

- Crop Science, USA
- Agronomy Journal, USA
- Canadian Journal of Plant Science
- Genome, Canada
- Oat Newsletter, Americas
- Plant Varieties Journal, Australia
- Theoretical and Applied Genetic (TAG), International Journal of Plant Breeding Research

## GENEBANKS:

- European Avena Database, Germany
- National Genetic Resources Program (NGRP), USA
- AAFC Plant Gene Resources (PGRC), Canada
- BBSRC Small Grain Cereal Collections, UK
- Plant Genetic Resources Documentation (EVIGEZ), Czech Republic
- N.I. Vavilov Research Institute of Plant Industry (VIR), Russia

- GENEBANKS:

## OTHER:

-   Material for an International Oat Register
-      (B.R. Baum)
-   oat identification and classification publications
-      (T.R. Stanton, F. A. Coffman)
-   proceedings from International Oat Conferences
-   “Quaker Oat Bible”
-   old (1916) and new publications related to oat
-      breeding

## Visit POOL

_**http://avena.agr.gc.ca/**_

## Slide 11

## Slide 12

## Slide 13

## Slide 14

## Slide 15

## POOL in numbers

- DATABASE STATISTICS (as of July 10, 2006)

| Names and synonyms |   |   |   |   |   | 43,683 |
| --- | --- | --- | --- | --- | --- | --- |
| Unique entries |   |   |   |   |   | 17,962 |
| Sources of information |  |  |  |  |  | 642 |
| Locations where the germplasm was created |  |  |  |   |   | 752 |
| Countries where the germplasm was created |  |  |  |  |  | 79 |
| Oldest variety listed - mid 18th century |  |  |   |   |   | Dutch |
| Latest varieties listed - spring 2006 |  |   | Canmore, Canoë, Gaspé, Jordan, Lachute, Lois, Navaro, Rozmar, Shadow, Sutton |  |  |  |

## WEB TRAFFIC ANALYSIS FOR 2006

|   | January | February | March | April | May | June | AVERAGE |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Total hits | 40,408 | 45,422 | 39,024 | 50,808 | 42,476 | 42,114 | 43,375 |
| Total visits | 318 | 239 | 226 | 225 | 188 | 185 | 230 |
| Total page views | 2,301 | 3,492 | 1,808 | 1,366 | 995 | 986 | 1,825 |
| Average visits per week | 72 | 62 | 56 | 54 | 44 | 45 | 56 |
| Average visits per day | 10 | 9 | 8 | 8 | 6 | 6 | 8 |
| Average pages viewed
 per day | 74 | 129 | 65 | 47 | 33 | 34 | 64 |
| Average pages viewed
 per visit | 7 | 15 | 8 | 6 | 5 | 5 | 8 |
| Total new visitors | 79 | 67 | 58 | 44 | 39 | 36 | 54 |
| Total repeat visitors | 32 | 34 | 33 | 42 | 36 | 32 | 35 |
| Average visits per visitor | 4 | 3 | 3 | 3 | 4 | 3 | 3 |
| Visitor repeat rate [%] | 39.5 | 41.5 | 41.8 | 55.3 | 52.9 | 52.5 | 47 |
| Average length of visit [minutes] | 9.5 | 12.0 | 6.5 | 4.5 | 4.5 | 6.2 | 7 |
| Total megabytes transferred | 50 | 110 | 108 | 59 | 72 | 91 | 82 |

## WHAT’S THE FUTURE FOR POOL?

-  completion of genebanks data retrieval
- 	(cultivar  coverage  from many  data  sources, but 	comprehensive  coverage  based on  alphabetical 	order from A to D  from main world oat genebanks 	and Material for an International Oat Register)
-  financing since July 1, 2006

## Acknowledgements

**Bruce Roskens**
**Grant Morrison**

**Art McElroy**
**Nick Tinker**
**Oat breeding team from Ottawa**

**All breeders and researchers willing to share their knowledge and their breeding results with the POOL **