SIDECACHE: Information access, management and dissemination framework for web services
© Doderer et al; licensee BioMed Central Ltd. 2011
Received: 7 March 2011
Accepted: 14 June 2011
Published: 14 June 2011
Many bioinformatics algorithms and data sets are deployed using web services so that the results can be explored via the Internet and easily integrated into other tools and services. These services often include data from other sites that is accessed either dynamically or through file downloads. Developers of these services face several problems because of the dynamic nature of the information from the upstream services. Many publicly available repositories of bioinformatics data frequently update their information. When such an update occurs, the developers of the downstream service may also need to update. For file downloads, this process is typically performed manually followed by web service restart. Requests for information obtained by dynamic access of upstream sources is sometimes subject to rate restrictions.
SideCache provides a framework for deploying web services that integrate information extracted from other databases and from web sources that are periodically updated. This situation occurs frequently in biotechnology where new information is being continuously generated and the latest information is important. SideCache provides several types of services including proxy access and rate control, local caching, and automatic web service updating.
We have used the SideCache framework to automate the deployment and updating of a number of bioinformatics web services and tools that extract information from remote primary sources such as NCBI, NCIBI, and Ensembl. The SideCache framework also has been used to share research results through the use of a SideCache derived web service.
Often bioinformatics researchers deploy new methods as web services to make them easily accessible in client browser applications or from other tools. For example, BioCatalogue  currently curates more than 1,700 life science web services and the number is rapidly growing. A typical bioinformatics web service performs a calculation or directly returns pre-computed information based on a user request. Many such services rely on or include information consolidated from other sites.
A difficulty with this distribution strategy is that many major sources of bioinformatics information such as NCBI are regularly updated. Developers are then faced with the task of periodically re-downloading the data and rerunning computations in order to keep their results up-to-date. Users may find that the results based on the new information are not the same as the results obtained from earlier requests, but usually they have no way of knowing what information was used nor do they have the option of rolling back to a previous data state.
The origin of data or provenance has received much attention in both the database community and in the scientific workflow community [2, 3]. Detailed provenance information can be represented by directed acyclic graphs and exchanged using the Open Provenance Model (OPM) . The Taverna Workbench  is an example of a workflow system that allows the development of web services based on pipelines or workflows. Developers can create new web services by constructing workflows of available components. Taverna incorporates an internal data model called Janus and supports provenance queries on the workflows. The CaGrid Workflow Toolkit  is an example of a Taverna extension that focuses specifically on the CancerBiomedical Informatics Grid (CaBig) and supports provenance queries.
Database and workflow systems implement "fine-grained" provenance models, which trace origin of individual pieces of data and individual components in a calculation. Unfortunately, most public web sources do not currently make fine-grained provenance information available to their clients. Furthermore, most client side tools do not yet support facilities for making such information usable. Chapman and Jagadish  have examined the issue of usability in the provenance information available in workflow systems and have shown the mismatch between the types of provenance questions users are likely to ask and the types of information stored to establish the provenance of a workflow. Very few web services provide provenance information of any kind.
SideCache is a simple deployment framework that allows developers to specify a schedule for automatically updating a web service and includes a version number with each user query. Users can examine available versions and obtain results based on previous versions as well as on the current version. Developers can include information about the implementation and data sources as metadata, which is captured with each version and returned upon user query. While not a substitute for true provenance, the SideCache approach allows developers to quickly deploy data web services without having to return in subsequent months and years to run updates.
SideCache also provides caching and rate control for requests to external sites. For security reasons, much of the client side browser technology can only issue web service requests to servers in the domain from which a page was downloaded unless the remote site provides certain certificates (which most do not). Thus, applications making client-side web requests are generally forwarded through their originating server. However, many bioinformatics sites (such as NCBI) have strict restrictions on the rate at which a particular IP address can make web service requests. While the requests of an individual client may not exceed these rates, the situation can easily become serious when requests from multiple clients are pooled. NCBI states that if queries from an IP address exceed a set rate per second, the IP address will be flagged and future queries will go unfulfilled until the address is removed from the NCBI banned IP list. The SideCache Proxy web services address these issues by providing local caching and pooled rate restriction for remote sites as specified by the deployer. These facilities are important for deployment of services that require some on-the-fly queries to external sites.
If the request represented by Q in Figure 1 does not match locally stored information, ProxyWS checks to see if the call will violate the access rules and time constraints specified by the deployer and only makes the remote call if the request satisfies the constraints. Otherwise, ProxyWS returns a failure, expecting its client to retry the request. ProxyWS saves remote responses in its JCS  cache in order to satisfy future requests.
The SideCache Suite is implemented in Java and designed for services running as Java servlets under a servlet container such as Apache Tomcat . The SideCache infrastructure is available as a Java .jar file that can simply be placed in the Tomcat library directory. The data and proxy web services are deployed using Tomcat's manager. To implement and deploy a rebuildable data web service using SideCache, a developer defines the external data sources and specifies a download schedule in a configuration file (See Additional File 1: Deployment.pdf for details.) The developer then extends SideCache's RebuildableService class by providing a performOperation method that responds to the web service request and a createRebuildableData method that creates the needed data structures and files for the data blob that supports the service.
To deploy a proxy web service, the developer specifies the access information and rate constraints in an XML file. Additional File 1 provides an example of such a service deployment.
Results and Discussion
Example services using various SideCache features
Web Service / Type / Operation
GeneInfoWS data web service getInfo
Inputs a list of NCBI gene IDs and returns name, chromosome number, and chromosome start position of the corresponding genes. http://visual.cs.utsa.edu/GeneInfoWS?operation=getInfo&sourceSpecies=9606&genes=7157,20,672
GeneInfoWS data web service getIds
Inputs a list of gene names and returns a list of the corresponding NCBI gene IDs. http://visual.cs.utsa.edu/GeneInfoWS?operation=getIds&sourceSpecies=9606&genes=TP53,ABCA2,BRCA1
GeneInfoWS data web service getInteractants
Inputs a list of NCBI gene IDs and returns a list of NCBI gene IDs for the genes whose products interact with the products of the input genes. The results for both input and output gene IDs include gene name, chromosome and chromosome start position. http://visual.cs.utsa.edu/GeneInfoWS?operation=getInteractants&sourceSpecies=9606&genes=7157,20,672
GeneInfoWS data web service getVersions
Returns a list of provenance data including a version identifier as well as creation date, size and source for each file. http://visual.cs.utsa.edu/GeneInfoWS?operation=getVersions
GeneInfoWS data web service versioned getInfo
Inputs a list of NCBI gene IDs and returns name, chromosome number, and chromosome start position of the corresponding genes. http://visual.cs.utsa.edu/GeneInfoWS?operation=getInfo&sourceSpecies=9606&genes=7157,20,672&versionIdentifier=1296771389679(getid)
EnrichWS data web service goEnrichment
Inputs a list of NCBI gene IDs, GO type, IEA evidence inclusion, a maximum group count and species. The service returns groups of gene IDs that are enriched for particular GO terms. The results include term, group members and group p-value. The number of groups is limited by the input group count. http://visual.cs.utsa.edu/EnrichWS?enrichType=goEnrichment&calc=Parent-Child-Union&species=9606&genes=1499|7827|2719|5002&max=10&evid=_IEA_&type=Component
Gene ontology from NCBI
EnrichWS data web service meshEnrichment
Inputs a list of NCBI gene IDs, a maximum group count, and taxonomy ID. The service returns the enriched MeSH terms, their corresponding enriched members, and the p-value for that group. The number of groups is limited by the input group count. http://visual.cs.utsa.edu/EnrichWS?enrichType=meshEnrichment&calc=Parent-Child-Union&species=9606&genes=1499|7827|2719|5002&max=10
Gene2MeSH from NCIBI
EnrichWS data web service getVersions
Returns a list of provenance data including a version identifier as well as creation date, size and source for each file. http://visual.cs.utsa.edu/EnrichWS?enrichType=getVersions
OrthologWS data web service default
Inputs a list of NCBI gene IDs, the source species taxonomy ID, and the target species taxonomy ID. The service returns all orthologs and the percent identity shared between the products of the source and target genes. http://visual.cs.utsa.edu/OrthologWS?sourceSpecies=9606&targetSpecies=10090&genes=7157,20,672
OrthologWS data web service getVersions
Returns a list of provenance data including a version identifier as well as creation date, size and source for each file. http://visual.cs.utsa.edu/OrthologWS?operation=getVersions
ProxyWS proxy web service uml
Returns the results from the input UML. Manages caching for efficient retrievals, and timing of external web site calls. http://visual.cs.utsa.edu/ProxyWS/Proxy?url=http://eutils.ncbi.nlm.nih.gov/entrez/eutils/esummary.fcgi?db=gene&id=7157,20,672&retmode=xml
The EnrichWS performs enrichment analysis for an input list of NCBI gene IDs using the enrichment approach of Grossman et al. . GO enrichment is calculated from downloaded NCBI gene ontology files. The mesh enrichment service is derived from NCIBI's Gene2MeSH , which integrates public sources of information to associate genes with Medical Subject Headings (MeSH terms) . Gene2MeSH does not provide download files for its information, so calls must be done dynamically. We configured these services to perform the calls through ProxyWS in order to cache the information locally and avoid network calls to remote sources. If the web service is restarted, SideCache ProxyWS will service the dynamic calls using local information. Finally, the OrthologWS periodically queries Ensembl's Biomart  web service, downloads identifier and orthology information, and creates indexed files. The OrthologWS returns the orthologous genes from look-ups using these indexed files.
Time comparison for cached and non-cached downloads
URL of source
Size of File (MB)
Times for Cached Calls (MS)
Times for Non-Cached Calls (MS)
Many algorithms and methods in bioinformatics are based on publically available date that is continuously updated. An automatic update system such as SideCache allows developers to deploy algorithms as web services and to specify the frequency of updates of the underlying data without further manual intervention. The SideCache versioning system includes a version with each data rebuild. The versioning allows users to retrieve information about the available versions and to address a query to a previous version. SideCache user responses automatically include information about what external resources were downloaded and the date of download as well as provenance annotations provided by the deployer. While not a fine-grained provenance system, versioning provides enough information for users to recreate earlier responses and to back trace information from external sources. The frequency of updates is left to the developer's discretion. For example, although NCBI updates its data daily, the web service described in this paper is only updated weekly because the service does not warrant the storage cost for more frequent updates. Many journals require authors to explicitly state the update frequency of the services described in their publications. SideCache allows web service creators to automate these updates.
If a scheduled update fails, SideCache logs the errors. SideCache only replaces the current data blob if all of the external data has been downloaded and the computation completed successfully. Occasionally external web services will change the calling URL or format of the results, which will require modifications to the download settings and processing methods.
SideCache enables the developer of a web service to take a data warehousing approach to versioning by saving each version as an immutable data blob. Deployers specify how long to retain previous versions or may specify that the versions be kept indefinitely. The deployment strategy of saving copies of previous versions may not work well for services involving very large data sets. However, the availability of multi-terabyte drives makes this strategy feasible for most services. This strategy fits biological research well. When new information is discovered it is included in the developer's data repositories, however previous data corresponding to previous publications must be retained. The developer simply indicates the published version data identifier and even when new versions are added with each update the previous data will be available.
Using web services to distribute data and algorithms increases their likelihood of use by providing easy programmatic as well as viewing access. The example services of this paper return information in a variety of formats including html, xml, csv, text files, and zipped collection of files. Formats such as html can be displayed in the requestor's browser, while xml and downloadable zip files allow the integration with other services. Many public data repositories such as FlyBase  and Mouse Genome Database  enable links out from their web sites, if the linked website provides the format of its URL and a list of synonyms for source website identifiers on the linked website. These requirements are easy to manage with a data web service.
As is typical of caching systems, ProxyWS avoids the cost of remote communication at the price of local storage and access. The developer specifies in a configuration file which sites should be cached. Good candidates for caching require multiple remote web service requests rather than a single file download. The ProxyWS can also provide two-level caching for users in a lab or those sharing an intranet. By deploying a commonly-used service through the proxy running on a local server, users with common interests can share downloaded information, improving efficiency and reducing external internet accesses.
An example of the value of SideCache comes from our own experience with InterologFinder , a web application that was originally published prior to the implementation of the SideCache framework. InterologFinder was based on complex HTML display of results that had been computed at the time of publication. To update this information, the authors had to rerun all of the calculations produced for the paper. Recently, the SideCache framework was used to re-implement and enhance InterologFinder. InterologFinder now automatically re-computes its results as new information becomes available and also exposes its results as a web service.
SideCache provides a framework that enables a research organization to manage data more efficiently including gathering and parsing external data and sharing newly published research results. The proxy web service manages timing calls for data sources with developer-created access policies and implements a caching system to optimize web service requests. SideCache also provides a simple framework for deploying data web services by providing added functionality in the form of automatic downloading and parsing of external data combined with the ability to develop in-house data analysis tools that are simple to share through the group's local web server. SideCache similarly makes it relatively straightforward to develop and deploy mechanisms to share research results. The data web services include a simple method for handling coarse grain provenance as the information evolves over time.
Availability and requirements
Project name: SideCache
Project home page: http://visual.cs.utsa.edu/sidecache.html
Operating system(s): Platform-independent with a servlet container (for example Apache Tomcat)
Programming language: Java
License: No license required
Any restrictions to use by non-academics: None
Acknowledgements and Funding
We acknowledge support from NIH Research Centers in Minority Institutions 2G12RR1364-06A1 (KAR) and computational support from the SA Computational Biology Initiative.
- Bhagat J, Tanoh F, Nzuobontane E, Laurent T, Orlowski J, Roos M, Wolstencroft K, Aleksejevs S, Stevens R, Pettifer S, Lopez R, Goble CA: BioCatalogue: a universal catalogue of web services for the life sciences. Nucleic Acids Res. 2010, 38: W689-694. 10.1093/nar/gkq394.PubMedPubMed CentralView ArticleGoogle Scholar
- Acar U, Buneman P, Cheney J, Bussche JVD, Kwasnikowska N, Vansummeren S: A graph model of data and workflow provenance. Book A graph model of data and workflow provenance. 2010, City: USENIX Association, 8-8.Google Scholar
- Bose R, Frew J: Lineage retrieval for scientific data processing: a survey. ACM Comput Surv. 2005, 37: 1-28. 10.1145/1057977.1057978.View ArticleGoogle Scholar
- Moreau L, Freire J, Futrelle J, McGrath R, Myers J, Paulson P: The Open Provenance Model: An Overview. Provenance and Annotation of Data and Processes. Edited by: Freire J, Koop D, Moreau L. 2008, Springer Berlin/Heidelberg, 5272: 323-326. 10.1007/978-3-540-89965-5_31. Lecture Notes in Computer ScienceView ArticleGoogle Scholar
- Hull D, Wolstencroft K, Stevens R, Goble C, Pocock MR, Li P, Oinn T: Taverna: a tool for building and running workflows of services. Nucleic Acids Research. 2006, 34: W729-W732. 10.1093/nar/gkl320.PubMedPubMed CentralView ArticleGoogle Scholar
- Tan W, Madduri R, Nenadic A, Soiland-Reyes S, Sulakhe D, Foster I, Goble C: CaGrid Workflow Toolkit: A taverna based workflow tool for cancer grid. BMC Bioinformatics. 2010, 11: 542-10.1186/1471-2105-11-542.PubMedPubMed CentralView ArticleGoogle Scholar
- Chapman A, Jagadish HV: Understanding provenance black boxes. Distrib Parallel Databases. 2010, 27: 139-167. 10.1007/s10619-009-7058-3.View ArticleGoogle Scholar
- Java Caching System. [http://jakarta.apache.org/jcs/]
- Tomcat homepage. [http://tomcat.apache.org/]
- Doderer MS, Yoon K, Robbins KA: SIDEKICK: Genomic data driven analysis and decision-making framework. BMC Bioinformatics. 2010, 11: 611-10.1186/1471-2105-11-611.PubMedPubMed CentralView ArticleGoogle Scholar
- Grossmann S, Bauer S, Robinson PN, Vingron M: Improved detection of overrepresentation of Gene-Ontology annotations with parent child analysis. Bioinformatics. 2007, 23: 3024-3031. 10.1093/bioinformatics/btm440.PubMedView ArticleGoogle Scholar
- Gene2MeSH [Internet]. [http://gene2mesh.ncibi.org]
- Lowe HJ, Barnett GO: Understanding and Using the Medical Subject Headings (MeSH) Vocabulary to Perform Literature Searches. Journal of the American Medical Association. 1994, 271: 1103-1108. 10.1001/jama.271.14.1103.PubMedView ArticleGoogle Scholar
- Flicek P, Aken BL, Ballester B, Beal K, Bragin E, Brent S, Chen Y, Clapham P, Coates G, Fairley S, Fitzgerald S, Fernandez-Banet J, Gordon L, Graf S, Haider S, Hammond M, Howe K, Jenkinson A, Johnson N, Kahari A, Keefe D, Keenan S, Kinsella R, Kokocinski F, Koscielny G, Kulesha E, Lawson D, Longden I, Massingham T, McLaren W: Ensembl's 10th year. Nucleic Acids Res. 2010, 38: D557-562. 10.1093/nar/gkp972.PubMedPubMed CentralView ArticleGoogle Scholar
- Tweedie S, Ashburner M, Falls K, Leyland P, McQuilton P, Marygold S, Millburn G, Osumi-Sutherland D, Schroeder A, Seal R, Zhang H: FlyBase: enhancing Drosophila Gene Ontology annotations. Nucleic Acids Res. 2009, 37: D555-559. 10.1093/nar/gkn788.PubMedPubMed CentralView ArticleGoogle Scholar
- Bult CJ, Eppig JT, Kadin JA, Richardson JE, Blake JA: The Mouse Genome Database (MGD): mouse biology and model systems. Nucleic Acids Res. 2008, 36: D724-728.PubMedPubMed CentralView ArticleGoogle Scholar
- Doderer M, Wiles AM, Ruan J, Gu TT, Ravi D, Blackman B, Bishop AJ: Building and analyzing protein interactome networks by cross-species comparisons. BMC Syst Biol. 2010, 4: 36-10.1186/1752-0509-4-36.PubMedPubMed CentralView ArticleGoogle Scholar
This article is published under license to BioMed Central Ltd. This is an open access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.