Genetic Resources in CIMMYT Development of Generic GRIMS

1
Genetic Resources in CIMMYTDevelopment of
Generic GRIMS

• Juan Carlos Alarcón M.
• Crop Informatics Specialist - Genetic Resources
  (CIMMYT)
• Crop Research Informatics Laboratory

2
History.

1. Wheat GeneBank system was moved to Inventory
   Management System (IMS).
2. Currently, most of all activities related to
   Wheat Genebank are supported by IMS.
3. Last year Maize Genebank system was moved to IMS
   too. Currently is in test phase.
4. For both crops, Maize and Wheat, all passport
   data is available in ICIS database structure.

3
Activities - 2009.

1. SINGER workshop on Beltsville. (Short
   presentation of GRIN-GLOBAL).
2. Visit to IRRI in order to known more about GRIMS
   .
3. Analysis of advantages and disadvantages of
   IMS,GRIMS and GRIN-GLOBAL.

4
ADVANTAGES DISADVANTAGES
ICIS - GMS available - One genebank tool (Inventory System) already available Data tables (GMS, DMS, IMS, GEMS) in the same package Global System to handle multicrops in the same DB Schema Funds available for a MBP Breeder MBP oriented, not specific for GR No funds and willingness available to focus development on Genetic Resources M. Access based (limited capacity) Single user Future Uncertain ICIS has missing types of data, mostly for genebank operation tables
GRIMS Genetic Resources Management Oriented Final Product DBInterface Expertise administrator programmers Connection with ICIS Oracle database Too expensive database Specific for Rice It will required crop based adaptations Thirty part software for barcoding Manual synchronization with ICIS database Still bugs Not completely integrated with ICIS
5
ADVANTAGES DISADVANTAGES
GRIN - GLOBAL Oriented to Genetic Resources Open database source Budget available Willingness to work with CG centers Independent project to ICIS structure No connection to GMS Just a project. Now we cant get a final product Has not been tested Budget in USA?. Database schema unknown to us It will require training It will required crop based adaptations Time frame uncertain We wont be part of the project
6
Options suggested by CIMMYT...

• IMS.
• GRIMS.
• GRIN-GLOBAL.
• Development a new system (java platform).

7
Development of Generic GRIMS

• Keep the current interface and make the changes
  for all crops.
• Migrate the ORACLE sql statements to PostgreSql
  statements.

The preliminary time estimation in order to
migrate the ORACLE sql statements to PostgreSQL
statements is 6 months.
8
Pending tasks..

• Load evaluation and characterization data for
  Maize and Wheat.
• Development a query option for Passport data.
• Development a query option for evaluation and
  characterization data (Retriever?, Zeus?).
• Development a user friendly option in order to
  upload passport data.

9
THANK YOU