Difference between revisions of "Complex Query Specification"

From phenoscape
(Version 0)
(Version 4)
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Complex Query Specification ==
+
= Complex Query Specification =
 +
 
 +
== Version 4 ==
 +
 
 +
=== Buttons for advanced query ===
 +
[[Image:NewAdvancedQuery.001.png]]
 +
 
 +
=== Save a query ===
 +
[[Image:NewAdvancedQuery.002.png]]
 +
 
 +
=== Enter advanced query page ===
 +
[[Image:NewAdvancedQuery.003.png]]
 +
 
 +
=== Additional Fields (suggestions?) ===
 +
[[Image:NewAdvancedQuery.004.png]]
 +
 
 +
=== Add a new subquery ===
 +
[[Image:NewAdvancedQuery.005.png]]
 +
 
 +
=== Subquery available ===
 +
[[Image:NewAdvancedQuery.006.png]]
 +
 
 +
=== Fill in subquery ===
 +
* Need a go button - maybe drop on tool bar?
 +
[[Image:NewAdvancedQuery.007.png]]
 +
 
 +
=== Results ===
 +
[[Image:NewAdvancedQuery.008.png]]
 +
 
 +
=== Alternative Start from mesethmoid query ===
 +
* Can change the logical operation in a drop-down
 +
[[Image:NewAdvancedQuery.009.png]]
 +
 
 +
[[Image:NewAdvancedQuery.010.png]]
 +
 
 +
=== Change to disjunction returns more results ===
 +
[[Image:NewAdvancedQuery.011.png]]
 +
 
 +
[[Image:NewAdvancedQuery.012.png]]
 +
 
 +
=== Add saved basihyal query ===
 +
[[Image:NewAdvancedQuery.013.png]]
 +
 
 +
=== And specify the connective ===
 +
[[Image:NewAdvancedQuery.014.png]]
 +
 
 +
[[Image:NewAdvancedQuery.015.png]]
 +
 
 +
=== Should give same results ===
 +
[[Image:NewAdvancedQuery.016.png]]
 +
 
 +
=== Advanced query also available from gene search ===
 +
[[Image:NewAdvancedQuery.017.png]]
 +
 
 +
=== Gene query details ===
 +
[[Image:NewAdvancedQuery.018.png]]
 +
 
 +
== Notes for a Version 3 ==
 +
 
 +
A number of approaches to a complex query have been suggested.  Since Jim has added a simple query to many of the summary pages, the focus of a complex query is on covering the types of queries that can't be expressed in the standard query.  An appropriate visualization of a query ought to be very explicit and could, secondarily let users check the semantics of a simple query (e.g., make the implicit disjunctions within categories and conjunctions between categories explicit).  To this latter end, and as a way for users to discover how complex queries work, a button or link to a complex query page should be available at the bottom of every simple query panel.  When selected, the contents of the simple query will be copied into the complex query page, establishing both a starting point for the user to build on and a correspondence back to the simple query.
 +
 
 +
=== List of suggested query models ===
 +
* [[http://www.biomart.org Biomart]]
 +
* [[http://www.gusdb.org/wdk Strategies Web Development Kit]]
 +
** examples at [[http://plasmodb.org/plasmo PlasmoDB]].
 +
* [[http://compbio.charite.de/Phenomizer/Phenomizer.html Phenomizer]]
 +
* [[http://www.arb-silva.de/search/ontogrator/ Ontogrator]]
 +
* Other 'list oriented' queries (e.g., fogbugz, mail.app, etc.)
 +
 
 +
== Version 2 ==
 +
=== Entry from Taxon Page ===
 +
 
 +
[[Image:Biomart126_1.png]]
 +
 
 +
[[Image:BioMart126_2.png]]
 +
 
 +
[[Image:BioMart126_3.png]]
 +
 
 +
[[Image:BioMart126_4.png]]
 +
 
 +
[[Image:BioMart126_5.png]]
 +
 
 +
[[Image:BioMart126_6.png]]
 +
 
 +
[[Image:BioMart126_7.png]]
 +
 
 +
[[Image:BioMart126_8.png]]
 +
 
 +
[[Image:BioMart126_9.png]]
 +
 
 +
[[Image:BioMart126_10.png]]
 +
 
 +
[[Image:BioMart126_11.png]]
 +
 
 +
[[Image:BioMart126_12.png]]
 +
 
 +
=== Entry from Phenotype Page ===
 +
 
 +
[[Image:BioMart126_14.png]]
 +
 
 +
=== Entry from Gene Page ===
 +
 
 +
[[Image:BioMart126_16.png]]
 +
 
 +
=== Entry from Publication Page ===
 +
 
 +
[[Image:BioMart126_18.png]
  
 
=== Version 1 ===
 
=== Version 1 ===

Latest revision as of 18:25, 16 March 2010

Complex Query Specification

Version 4

Buttons for advanced query

NewAdvancedQuery.001.png

Save a query

NewAdvancedQuery.002.png

Enter advanced query page

NewAdvancedQuery.003.png

Additional Fields (suggestions?)

NewAdvancedQuery.004.png

Add a new subquery

NewAdvancedQuery.005.png

Subquery available

NewAdvancedQuery.006.png

Fill in subquery

  • Need a go button - maybe drop on tool bar?

NewAdvancedQuery.007.png

Results

NewAdvancedQuery.008.png

Alternative Start from mesethmoid query

  • Can change the logical operation in a drop-down

NewAdvancedQuery.009.png

NewAdvancedQuery.010.png

Change to disjunction returns more results

NewAdvancedQuery.011.png

NewAdvancedQuery.012.png

Add saved basihyal query

NewAdvancedQuery.013.png

And specify the connective

NewAdvancedQuery.014.png

NewAdvancedQuery.015.png

Should give same results

NewAdvancedQuery.016.png

Advanced query also available from gene search

NewAdvancedQuery.017.png

Gene query details

NewAdvancedQuery.018.png

Notes for a Version 3

A number of approaches to a complex query have been suggested. Since Jim has added a simple query to many of the summary pages, the focus of a complex query is on covering the types of queries that can't be expressed in the standard query. An appropriate visualization of a query ought to be very explicit and could, secondarily let users check the semantics of a simple query (e.g., make the implicit disjunctions within categories and conjunctions between categories explicit). To this latter end, and as a way for users to discover how complex queries work, a button or link to a complex query page should be available at the bottom of every simple query panel. When selected, the contents of the simple query will be copied into the complex query page, establishing both a starting point for the user to build on and a correspondence back to the simple query.

List of suggested query models

Version 2

Entry from Taxon Page

Biomart126 1.png

BioMart126 2.png

BioMart126 3.png

BioMart126 4.png

BioMart126 5.png

BioMart126 6.png

BioMart126 7.png

BioMart126 8.png

BioMart126 9.png

BioMart126 10.png

BioMart126 11.png

BioMart126 12.png

Entry from Phenotype Page

BioMart126 14.png

Entry from Gene Page

BioMart126 16.png

Entry from Publication Page

[[Image:BioMart126_18.png]

Version 1

Entry of phenotype specification

Single Pane Set Algebra interface

ComplexQuery1.png

ComplexQuery2.png

ComplexQueryAlgebraBox.png


Phenotype on Tree Mapping Specification

TreeDisplayQuery.png

Biomart style interface

BioMart1.png

BioMart2.png

Version 0

  • user enters a phenotype specification, presses Done

Queries1.png