Grouping germplasm search results
From ICISWiki
Contents |
Summary:
In Germplasm search, group/order records by neighborhood, with option to show all germplasm records in the neighborhood or only germplasm records with a name* matching the name search.
(*note that a germplasm can have many names with various types)
Feature Request Details:
I. For grouping results of name search
- First level nodes are the germplasm records where method of germplasm development is generative
- First level nodes: In addition to above, the matching germplasm records whose GPID1 do not belong to the name search results set
- Second level nodes: these are the germplasm records that has the selected first level node as their source GID
- Second level nodes: these are further grouped (maintenance neighborhood), the root of subtrees in the second level nodes are the last source of the maintenance root or the maintenance root itself (if its source is not part of the search results set)
II. For grouping results: show all GIDs in the neighborhood
tbc...
Example:
Below is a sample germplasm result for azucena% grouped by method type, maintenance root gid (for use case where only matching records in the name search are shown)
More examples
Another example (with management neighborhood/grouping): IRGC 2826% (32 records)
Status of Feature Request:
More information can be found here: http://cril.cimmyt.org/jira/browse/ZEUS-2
Summary:
December 18++ 2009 - initial talks
December 22, 2009 - availability of database for IRIS, attempt to include maintenance root GID in wh_germplasm_details
January 8, 2010 - meeting "Maintenance Neighborhood" organized by Arllet Portugal
March 17, 2010 - sqls formulated for getting node entries (to be discussed in meeting); sample tree made and posted on cropwiki
March 19, 2010 - meeting about the feature request (result of meeting: changes made to sample grouped tree fro azucena; corrected maintenance root GID entry in warehouse table - corrected the definition)
March 22, 2010 - Kevin changed the stored procedure(wh_create_germplasm_details) that is used to set the maintenance root GID information in the warehouse table
March 24, 2010 - Jira issue was created
March 24++ - explored use of ehcache
April 6 (week of) - Kevin's attempt to setup database with correct maintenance root GIDs
April 13 (week of) - datasource backend testing
April 14, 2010 - Kevin released version 1.5.0 of ICIS datasource with the tree generation feature; limitation: not able to process large datasets (test made on local machine)
May 4, 2010 - problems with using datasource (bad class)
May 7, 2010 - Mylah starts implementing on GUI (used ICISDS 1.8.0)
May 10, 2010 - deployed for testing http://koios.generationcp.org:8083/germplasm-dev2
May 17, 2010 - datasource software release (for faster data retrieval, with paging, supports multiple search string input)
May 25, 2010 - datasource software release (for retrieval of complete neighborhood
May 26, 2010 - Infrared profiling (initial tests)
May 27, 2010 - ICISDS 1.12.0 released
May 28, 2010 - used ICISDS 1.12.0; paging implemented for getGPID1roots; other feature requests (such as more information about names, etc) need minor changes
June 3, 2010 - paging implemented for GENroots and 3rd grouping (no GPID1s)
June 4, 2010 - demo; got feedback; need to fix bugs and then apply the same GUI to germplasm sets for paging feature on GPG2 crop registry / lists;
June 5, 2010 - from feeedback - explore UI for better presentation of top-level grouping - they are not related to each other. consider grouping grid; make queries faster - share same germplasm tree across all users;
Performance Test
Search for IR 64 - profiling report StudyMart - profiling report
