Title: Genetic Resources in CIMMYT Development of Generic GRIMS
1Genetic Resources in CIMMYTDevelopment of
Generic GRIMS
- Juan Carlos Alarcón M.
- Crop Informatics Specialist - Genetic Resources
(CIMMYT) - Crop Research Informatics Laboratory
2History.
- Wheat GeneBank system was moved to Inventory
Management System (IMS). - Currently, most of all activities related to
Wheat Genebank are supported by IMS. - Last year Maize Genebank system was moved to IMS
too. Currently is in test phase. - For both crops, Maize and Wheat, all passport
data is available in ICIS database structure.
3Activities - 2009.
- SINGER workshop on Beltsville. (Short
presentation of GRIN-GLOBAL). - Visit to IRRI in order to known more about GRIMS
. - Analysis of advantages and disadvantages of
IMS,GRIMS and GRIN-GLOBAL.
4ADVANTAGES 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
5ADVANTAGES 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
6Options suggested by CIMMYT...
- IMS.
- GRIMS.
- GRIN-GLOBAL.
- Development a new system (java platform).
7Development 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.
8Pending 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.
9THANK YOU