Updates_IRIS-GRIMS

boundlessbazaarΔιακομιστές

9 Δεκ 2013 (πριν από 3 χρόνια και 10 μήνες)

196 εμφανίσεις

IRIS
-
GRIMS Updates

Lilibeth M. Sison

Grace Lee S. Capilit

Nelia Resurreccion

TTC GRC

IRIS
-
Genetic Resources Information
Management System (IRIS
-
GRIMS)


Manages genetic resources information for the IRRI
genebank


Being developed to follow (and improve) the
functionalities of the genebank’s old system IRGCIS


Development of new functions for additional
needs/requirements


Uses ICIS tables, where possible


Database is Oracle (migrating to PostgreSQL)


GUI was developed in Borland Delphi

IRIS
-
GRIMS Modules



Involves
management of all
information given by
the donor (passport
and collection
information), initial
seed increase,
assignment of IRGC
accession number and
designation of
MLS/FAO dates

Seed Acquisition

Seed Multiplication



Involves
management of
processes related to
seed rejuvenation and

replenishment of
samples in the
genebank

Seed Characterization



Involves
management of
morphological and
agronomic traits of
samples stored in the
genebank

Seed Management



Involves
monitoring of the
movement of
seeds to and from
the genebank

System Administration



Involves
management of
reference tables
used by the system

Tasks for GRC*


ICIS Database Structure

o
Review ICIS GMS schema tables relating to genetic
resources (IRGCIS) conversion

LISTNMS,EVENTMEM/PROJECT/PERSONLIST


ICIS database access

o
Status of GRIMS Backend conversion of Oracle to
PostgreSQL

o
Some issues encountered during conversion


ICIS implementations and conversion

o
Rice Registry
-

(IRRI/CIAT/WARDA/IITA/GRIN) GPG2 cross
referencing of rice germplasm, data loading

o
Scanned Collecting Mission documents


Enhancement of GRIMS
-

Location, People, Institute




*Taken from 2010 Future Planning,ICIS Workshop, Perth Australia



ICIS database access


Status of GRIMS Backend conversion of Oracle to PostgreSQL

o
Specs : PostgreSQL 8.4 on Debian Linux and Ubuntu
(development); PostgreSQL 8.4(?) on Centos (production)

o
Consultant has successfully migrated all objects
(tables,views,functions,triggers,sequences) in 4 weeks

o
Scheduled back
-
up scripts are in place

o
Backup and recovery procedures are provided to ITS, in
addition to their disaster recovery plan

o
Currently on the second phase of system testing for GRIMS
and ICIS applications (Browse, Setgen, GMSSrch,ICIS Lite)



Some issues encountered during conversion

o
Datatype conversion

o
ICIS32.dll problem

o
Oracle and Postgresql with similar function but
with different parameters

o
Some built
-
in variables and functions are different
in Postgresql

o
Postgresql not allowing default parameters in
function declaration

o
ODBC driver version of PostgreSQL


ICIS database access


cont’d

Rice Registry


on Setgen



Rice Registry


on IRIS web

Neighborhood


Scanned Collecting Mission documents

Use of REFLINKS and BIBREF in scanned
Collecting Mission documents

Displaying Collecting Mission documents
on IRIS web

Browsing Collecting Mission lists

Enhancement of GRIMS
-

Location,
People, Institute


Data from GRIMS are now uploaded in Central IRIS
tables


PERSONS, INSTITUT and ADDRESS


On
-
going curation of address type, institute type and
person roles for these uploaded data


Data entry for these tables are currently under
development in GRIMS


PERSONS, INSTITUT and ADDRESS will be used
as reference tables for Incoming (sender, donor,
collector, etc.) and Seed Distribution (requestor,
recipient)


GRIMS


data entry forms

Seed Distribution

Old form

New form