Difference between revisions of "Queries and Query Execution Plans"

From phenoscape
(Executive Summary)
Line 2: Line 2:
  
 
==Executive Summary==
 
==Executive Summary==
The first iteration of the Web Services module for the Phenoscape project (which will be referred to as the '''SICB prototype''' henceforth) was demonstrated at the SICB meeting in Boston, MA in January 2009. This module allowed database searches for Anatomical Entities (Anatomical Entity Services) and Genes (Gene Services). Searches for Taxa (Taxon Services) are to be implemented in the next iteration which will be a part of the next Phenoscape version to be demonstrated at the ASIH meeting in Portland, OR (which will be referred to as the '''ASIH prototype''' henceforth) in July, 2009.  
+
The first iteration of the Web Services module for the Phenoscape project (the '''SICB prototype''') was demonstrated at the SICB meeting in Boston, MA in January 2009. This module allowed database searches for Anatomical Entities (Anatomical Entity Services) and Genes (Gene Services). Searches for Taxa (Taxon Services) are to be implemented in the next iteration which will be a part of the next Phenoscape version to be demonstrated at the ASIH meeting in Portland, OR (the'''ASIH prototype''') in July, 2009.
  
Testing by the Phenoscape project stakeholders (Paula, Todd, and Monte) at the SICB meeting revealed that Anatomy and Gene Services were functional, but their execution was very slow in terms of time. As a result, the data retrieval strategy used in the SICB prototype are being examined for bottlenecks and these details are presented here. New data retrieval strategies are being tested for use in the ASIH prototype. The details of these strategies are documented here as well.  
+
Testing by the Phenoscape project stakeholders (Paula, Todd, and Monte) at the SICB meeting revealed that Anatomy and Gene Services were functional, but their execution was very slow in terms of time. As a result, the data retrieval strategy used in the SICB prototype are being examined for bottlenecks and these details are presented here. New data retrieval strategies are being tested for use in the ASIH prototype. The details of these strategies are documented here as well.
  
 
==Database details==
 
==Database details==

Revision as of 22:30, 20 January 2009

This section describes the queries that have been (or are to be) implemented for the Phenoscape data services, in addition to the execution details of each queries on the PostgreSQL database on Darwin.

Executive Summary

The first iteration of the Web Services module for the Phenoscape project (the SICB prototype) was demonstrated at the SICB meeting in Boston, MA in January 2009. This module allowed database searches for Anatomical Entities (Anatomical Entity Services) and Genes (Gene Services). Searches for Taxa (Taxon Services) are to be implemented in the next iteration which will be a part of the next Phenoscape version to be demonstrated at the ASIH meeting in Portland, OR (theASIH prototype) in July, 2009.

Testing by the Phenoscape project stakeholders (Paula, Todd, and Monte) at the SICB meeting revealed that Anatomy and Gene Services were functional, but their execution was very slow in terms of time. As a result, the data retrieval strategy used in the SICB prototype are being examined for bottlenecks and these details are presented here. New data retrieval strategies are being tested for use in the ASIH prototype. The details of these strategies are documented here as well.

Database details

  • Database name: obdphenoscape
  • Database server: Darwin
  • Last updated: Jan 02, 2009
  • Size: ~ 600 MB

Anatomical Entity Services

Queries for Phenoscape UI demo'ed at SICB, Boston in Jan 2009

Queries to be implemented in the future

Gene Services

Taxon Services