Difference between revisions of "Database Roadmap"

From phenoscape
(New page: This is a development roadmap for the second production iteration of the Phenoscape database and web interface, intended for demonstration and testing at the [http://www.dce.k-state.edu/co...)
 
 
(27 intermediate revisions by 3 users not shown)
Line 2: Line 2:
  
 
==Cartik==
 
==Cartik==
===Jan. 12-16===
+
 
 +
This is an outline of my tasks in the coming months.
 +
 
 +
===January 2009===
 +
<sup>*</sup> indicates task dependency
 
* Work on moving database connection parameters from code to properties file that does not go into SVN.
 
* Work on moving database connection parameters from code to properties file that does not go into SVN.
* Begin work on new database views and procedures to speed up anatomy and gene queries in Phenoscape
+
** STATUS: Complete
 +
* Document inherited database query module in OBD API*
 +
** STATUS: Deferred (lower priority)
 
* Finish documentation of the OBD reasoner on the Wiki
 
* Finish documentation of the OBD reasoner on the Wiki
 +
** STATUS: Complete
 +
* Work on Unit test modules for database queries*
 +
** STATUS: Complete
 +
* Document performance metrics of database queries from Unit test cases*
 +
** STATUS: Complete
 +
* Document query optimization patterns for database queries*
 +
** STATUS: Complete
  
===Jan. 19-23===
+
===February===
* Continue work on writing database views and procedures
+
* Complete documentation of query execution methods*
* Begin work on augmenting OBD reasoner to infer presence and absence of anatomical features
+
** STATUS: Complete
 
+
* Implement improved query methods to speed up execution of anatomy data services
===Jan. 26-30===
+
** NOTE: contingent upon completion of previous related tasks marked with *
* Complete work on new database views and procedures
+
** STATUS: Complete
* Test database for improved performance
+
* Investigate possible additions to OBD reasoner (with input from Hilmar and Jim)
* Continue work on augmenting OBD reasoner
+
** STATUS: Added facet to add direct relationships between characters and all of the states they may take. Complete
 
+
* Add extinct/extant species information to the database
===Feb. 2-6===
+
** STATUS: Complete
* Commence work on adding collection information to phenotype annotations
+
* Automate data loader module
* Complete work on augmenting OBD reasoner
+
** STATUS: Complete
 
 
===Feb. 9-13===
 
* Continue work on adding collection information to the database
 
* Commence work on adding extinct/extant species information to the database
 
  
===Feb. 16-20===
+
===March===
* Finish work on adding collection information
+
* Add Gene data service to Phenoscape
* Continue work on adding extinct/extant species
+
** STATUS: Complete
* Commence work on adding publication information to database
+
* Add collection information to the database
** NOTE: Dependant upon SICI and Endote work
+
** STATUS: Complete
 +
* Add Taxon query service to Phenoscape
 +
** STATUS: Complete
  
===Feb. 23-27===
+
===April===
* Finish work on adding extinct/extant species information
+
* Add publication information to database
* Continue work on adding publication information
+
** NOTE: Dependant upon SICI and Endnote work
* Commence work on adding Taxon query service to Phenoscape
+
* Investigate load sharing and connection pooling strategies for Phenoscape prototype
  
===Mar.1-5===
+
===May===
* Continue work on publications
+
* Refine web services specifications as per Jim's requirements
* Continue work on Taxon query service
+
* Performance tuning
  
===Mar.8-12===
+
===June===
* Complete work on publications
+
* Testing and bug fixes
* Complete work on Taxon query service
 
* Bug fixes
 
  
===Mar.15-19===
+
===July===
* More bug fixes
+
* Public release at ASIH
* Status check
 
  
==Jim==
+
[[Category:Archive]]

Latest revision as of 19:25, 11 October 2011

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

This is an outline of my tasks in the coming months.

January 2009

* indicates task dependency

  • Work on moving database connection parameters from code to properties file that does not go into SVN.
    • STATUS: Complete
  • Document inherited database query module in OBD API*
    • STATUS: Deferred (lower priority)
  • Finish documentation of the OBD reasoner on the Wiki
    • STATUS: Complete
  • Work on Unit test modules for database queries*
    • STATUS: Complete
  • Document performance metrics of database queries from Unit test cases*
    • STATUS: Complete
  • Document query optimization patterns for database queries*
    • STATUS: Complete

February

  • Complete documentation of query execution methods*
    • STATUS: Complete
  • Implement improved query methods to speed up execution of anatomy data services
    • NOTE: contingent upon completion of previous related tasks marked with *
    • STATUS: Complete
  • Investigate possible additions to OBD reasoner (with input from Hilmar and Jim)
    • STATUS: Added facet to add direct relationships between characters and all of the states they may take. Complete
  • Add extinct/extant species information to the database
    • STATUS: Complete
  • Automate data loader module
    • STATUS: Complete

March

  • Add Gene data service to Phenoscape
    • STATUS: Complete
  • Add collection information to the database
    • STATUS: Complete
  • Add Taxon query service to Phenoscape
    • STATUS: Complete

April

  • Add publication information to database
    • NOTE: Dependant upon SICI and Endnote work
  • Investigate load sharing and connection pooling strategies for Phenoscape prototype

May

  • Refine web services specifications as per Jim's requirements
  • Performance tuning

June

  • Testing and bug fixes

July

  • Public release at ASIH