GUS GUS (Genomics Unified Schema) is a relational database schema that has been deployed in Oracle and PostgreSQL. The schema is modular and has been updated (GUS4) to better cover investigational studies, results from high (and not so high) throughput technologies, technology used, biological sequences, metadata and associated standards, pathways and networks, and data control. In particular, deep phenotyping (e.g epidemiological results) can be easily captured and interpreted through associations to ontology terms. Objectives, study design, protocols, and results are all linked in a manner consistent with established standards (MAGE-TAB, Ontology for Biomedical Investigations).
The GUS source is maintained in a Subversion-powered repository. You may check the code out directly using a command such as: svn checkout https://www.cbil.upenn.edu/svn/gus/GusSchema/branches/4.0/ GusSchema
Some GUS installation documentation can be found at http://www.gusdb.org/documentation.php however we plan to replace this with new up-dated documentation either at this site or in GitHub.
Strategies-WDK Mining the data in GUS can be performed using the Strategies-WDK (Fischer et al. Database 2011) to provide a workspace for generating, combining, saving, and sharing “strategies.” Strategies are graphical workflows of database searches of record types (such as genes, SNPs, studies) that can be selected (favorites, baskets), combined, and transformed (SNPs to genes, genes to pathways, pathways to chemical compounds). This system has proved highly popular and successful in enabling sophisticating data-mining by a diverse group of end users, and has recently been updated so as to provide the ability to browse extensive metadata (e.g., clinical epidemiology variables), inspired by the Harvest data discovery platform (Pennington et. al., JAMIA 2014). Also new is the introduction of an analysis tab for the records returned by Strategy searches. For example, a list of returned genes can be analyzed for Gene Ontology or KEGG pathway enrichment without having to leave the Strategies workspace page. Future plans include refactoring the combined GUS/ Strategies-WDK system so that this package is easier for other projects and communities to install and customize.
Strategies googlecode project (will be updated): https://code.google.com/p/strategies-wdk/