1 / 32

International Institute of Tropical Agriculture P.M.B 5320, Ibadan, Nigeria

International Institute of Tropical Agriculture P.M.B 5320, Ibadan, Nigeria. Research Database Management System. Biometrics Unit. PREMISES. Scientists generate information consistent with institute’s mandate Information generation is time consuming and expensive

whitley
Download Presentation

International Institute of Tropical Agriculture P.M.B 5320, Ibadan, Nigeria

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. International Institute of Tropical Agriculture P.M.B 5320, Ibadan, Nigeria Research Database Management System Biometrics Unit

  2. PREMISES • Scientists generate information consistent with institute’s mandate • Information generation is time consuming and expensive • Information must be preserved to ensure efficient use • Ownership and use rest with IITA • Donors, and public have unrestricted right to information • RDBMS to facilitate documentation, access, and retrieval

  3. Information defined All numeric and non-numeric data, including photographs etc. arising from (formal and informal) studies undertaken at/with IITA / Donor’s support All publications and reports, refereed / non-refereed.

  4. Initiative IITA RDBMS benefits from ICIS, a CGIAR centers initiative on the development of generic database and management system. It links crop and non-crop trials to project management system enabling effective manipulation and access to data. Data files and relevant information are secure through encrypted password and multi-layered implementation.

  5. RDBMS, SINGER, AND LANGUAGES IITA RDBMS has natural (close) links with other data systems including SINGER . Software implementation employs Visual basic, Visual C++, Delphi, and Fortran on the Microsoft Access database. All routines and procedure are packaged into a dynamic link library and can be called using most programming languages. RDBMS with ICIS provides opportunity for local and global crops and systems data management.

  6. Linkages The open database architecture (ODBC) employed for cross platform compatibility ensures that data could be shared when necessary by other database systems. CGIAR – wide; MIS – Oracle; PROMIS; etc

  7. RDBMS STRUCTURE Projects Researchers Databases and tools

  8. IITA Research Database Management System user interface

  9. PROJECTS Project documents Project researchers The project Local databases Project linkages Project activities outputs / studies

  10. Subsets from the Project Management System

  11. Researchers Outputs from all projects involved Projects Activity sheet / Activities / data / report Databases

  12. Project Management System (PMS) • PMS is the umbrella under which all the systems in the database reside in an integrated form. • Recognises that all activities and outputs emanate from projects and researchers belong to at least one project.

  13. Major links between tables in IITAPMS

  14. Germplasm Management System • GMS takes care of genealogy, nomenclature & chronology and serves as the engine that drives the DMS which manages characterization and evaluation data.

  15. Data Management System • Selective search across studies in database for particular traits based on certain criteria • Extract dataset of a particular study and export to excel, text file etc for further analyses. • Search for a cultivar and get summary analyses on all available measured traits • GID and Trait related searches, etc

  16. Location Management Module • Storing location information helps describe it with sufficient precision to permit a researcher, with no additional knowledge, to relocate a specified location and to link the location to spatially referenced data such as soil maps or climate databases.

  17. Linking RDBMS and GIS Interaction between site specific-spatial data • RDBMS • Germplasm Parameters • Crop Requirement • Human Resource • Research Data • GIS DB • Climate • Soils (Edaphic) • General Information • - agriculture • - topography • - socio-economic • Linking of Data • POINT : Lat / Long • AREA : ID

  18. Trait Management and Data Control Module Links all measured variables and factors into distinct classes, each representing a single property or trait of the experimental material. These traits form basis for linking info. across studies. Manages and relates all scales in which a trait can be measured or expressed as well as conversion between scales. Records details of all measurements or manipulation methods for traits. Manages and controls quality of data recorded (Consistency checks)

  19. Underlying tables for the Trait Management Module in ICIS

  20. Database tools in PMS GMS DMS GIS GEMS

  21. Database implementation local Central local local local

  22. Crops, Systems databases and tools Crop / System implementation GMS DMS GISGEMS • Cowpea • Soybean • Yam • Cassava • Plantain/Banana • Maize • Cropping Systems • Diagnostic Survey • Soil Management Trails • Crop Livestock Trials • Others (Lubilosa) Systems already implemented

  23. Training and local databases established System implementation Ibadan Uganda Onne Cotonou • Cowpea • Soybean • Yam • Cassava • Plantain/Banana • Maize • Cropping Systems • Diagnostic Surveys • Soil Management Trials • Crop Livestock Trials • Others(Lubilosa, etc) Implementation by locations

  24. Policy • Each activity/study/trial must be supported by an ACTIVITY SHEET, which provides basic information on the study and linkages with the project’s output(s). • Completed activity sheets must be submitted to BU for archiving after approval before the trials/surveys/studies are undertaken or soon after. • Information uploaded to the central database may not be modified, except under extreme circumstances (such as wrong coding emanating from local unit) and after thorough verification. • Reasons for such changes must be properly documented. • Information generated from trials shall be made available for local archiving within 3months of collection. • The central RDBMS will only be updated when scientists authorise BU through their local coordinators.

  25. Access How long should a scientist hold on to data? Publication rights All data used must be acknowledged Rewards For timely submission of information Scientists protected through approval of publications and authorship

  26. Biometrics Unit Organizational Chart PHMDDirector Head ESARC RCMD Director HFC Coordinator Biometrics Unit (Biometrician) Database development & Maintenance Statistics & Statistical Computing Project Coordinators RDBMS Manager Nigeria Benin Cameroon Uganda Local databases & coordinators Programmer Local Local Local Local

  27. RDBMS / ICIS BUDGET 2001 Personnel: RDBMS Manager $core Programmer $core NYSC / IT $ 2,000.00 Setup of databases / training (travels): Kano, Cotonou, Kampala, Yaounde, & Bouake (?) Approx. 2wks in locations (GMS & DMS) + I wk in Onne for (GMS) $ 8,000.00 ICIS meeting 2001 (IRRI) $ 5,000.00 2500 X 2 Contribution to ICIS development $10,000.00 CD’s, Computer Stationeries $ 1,000.00 Total $ 26,000.00

  28. RDBMS ~ BIOMETRICS UNIT SUSTAINABILITY • Core funding ? • Special Projects ?

More Related