Genetic Resources in CIMMYT Development of Generic GRIMS - PowerPoint PPT Presentation

1 / 9
About This Presentation
Title:

Genetic Resources in CIMMYT Development of Generic GRIMS

Description:

Genetic Resources in CIMMYT Development of Generic GRIMS Juan Carlos Alarc n M. Crop Informatics Specialist - Genetic Resources (CIMMYT) Crop Research Informatics ... – PowerPoint PPT presentation

Number of Views:126
Avg rating:3.0/5.0
Slides: 10
Provided by: IvanMa3
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com