Database Roadmap

This is a development roadmap for the second production iteration of the Phenoscape database and web interface, intended for demonstration and testing at the ASIH 2009 meeting.

Cartik

January 2009

^* indicates task dependency

• Work on moving database connection parameters from code to properties file that does not go into SVN. [Done]
• Document inherited database query module in OBD API* [In Progress]
• Finish documentation of the OBD reasoner on the Wiki [First iteration done]
• Investigate implementation of Unit test modules for database queries* [Partially done]
• Work on Unit test modules for database queries* [Partially done]
• Document performance metrics of database queries from Unit test cases* [In Progress]
• Document query optimization patterns for database queries* [In Progress]

February

• Complete documentation of query execution methods*
• Implement improved query methods to speed up execution of anatomy and gene data services
  • NOTE: contingent upon completion of previous related tasks marked with *
• Investigate possible additions to OBD reasoner (with input from Hilmar and Jim) to infer presence/absence of anatomical features
• Implement augmentations to reasoner to infer presence/absence of anatomical features
• Add extinct/extant species information to the database

March

• Add collection information to the database
• Add publication information to database
  • NOTE: Dependant upon SICI and Endnote work
• Add Taxon query service to Phenoscape
• Bug fixes
• Status check