Abstract:Motivation: Integrating heterogeneous data across distributed sources is a major requirement for in silico bioinformatics supporting translational research. For example, genome-scale data on patterns of gene expression in the fruit fly Drosophila melanogaster are widely used in functional genomic studies in many organisms to inform candidate gene selection and validate experimental results. However, current data integration solutions tend to be heavy weight, and require significant initial and ongoing investment of effort. Development of a common Web-based data integration infrastructure (a.k.a. data web), using Semantic Web standards, promises to alleviate these difficulties, but little is known about the feasibility, costs, risks or practical means of migrating to such an infrastructure. Results: We describe the development of OpenFlyData, a proof-of-concept system integrating gene expression data on D. melanogaster, combining Semantic Web standards with light-weight approaches to Web programming based on Web 2.0 design patterns. To support researchers designing and validating functional genomic studies, OpenFlyData includes user-facing search applications providing intuitive access to and comparison of gene expression data from FlyAtlas, the BDGP in situ database, and FlyTED, using data from FlyBase to expand and disambiguate gene names. OpenFlyData's services are also openly accessible, and are available for reuse by other bioinformaticians and application developers. Semi-automated methods and tools were developed to support labour- and knowledge-intensive tasks involved in deploying SPARQL services. These include methods for generating ontologies and relational-to-RDF mappings for relational databases, which we illustrate using the FlyBase Chado database schema; and methods for mapping gene identifiers between databases. The advantages of using Semantic Web standards for biomedical data integration are discussed, as are open issues. In particular, although the performance of open source SPARQL implementations is sufficient to query gene expression data directly from user-facing applications such as Web-based data fusions (a.k.a. mashups), we found open SPARQL endpoints to be vulnerable to denial-of-service-type problems, which must be mitigated to ensure reliability of services based on this standard. These results are relevant to data integration activities in translational bioinformatics. Availability: The gene expression search applications and SPARQL endpoints developed for OpenFlyData are deployed at http://openflydata.org. FlyUI, a library of JavaScript widgets providing re-usable user-interface components for Drosophila gene expression data, is available at http://flyui.googlecode.com. Software and ontologies to support transformation of data from FlyBase, FlyAtlas, BDGP and FlyTED to RDF are available at http://openflydata.googlecode.com. SPARQLite, an implementation of the SPARQL protocol, is available at http://sparqlite.googlecode.com. All software is provided under the GPL version 3 open source license.

FlyBase 2.0: the next generation

FlyBase: updates to the Drosophila melanogaster knowledge base

FlyBase: updates to the Drosophila genes and genomes database

FlyBase: a guided tour of highlighted features

FlyAtlas 2: a new version of the Drosophila melanogaster expression atlas with RNA-Seq, miRNA-Seq and sex-specific data

FlyRNAi.org 2025 update-expanded resources for new technologies and species

OpenFlyData: an exemplar data web integrating gene expression data on the fruit fly Drosophila melanogaster

A new experimental evidence-weighted signaling pathway resource in FlyBase

FlyBase: introduction of the Drosophila melanogaster Release 6 reference genome assembly and large-scale migration of genome annotations

Flynet: A Genomic Resource For Drosophila Melanogaster Transcriptional Regulatory Networks

Fly Cell Atlas: A single-nucleus transcriptomic atlas of the adult fruit fly

100 Years of Drosophila Research and Its Impact on Vertebrate Neuroscience: a History Lesson for the Future

Next-generation Large-Scale Binary Protein Interaction Network for Drosophila Melanogaster

FlyVar: a database for genetic variation in Drosophila melanogaster.

Flynotyper 2.0: An updated tool for rapid quantitative assessment of Drosophila eye phenotypes

Fly Me to the Micron: Microtechnologies for Drosophila Research

Using FlyAtlas to identify better Drosophila melanogaster models of human disease

FlyNet: a Versatile Network Prioritization Server for the Drosophila Community.

FlyPrimerBank: an Online Database for Drosophila Melanogaster Gene Expression Analysis and Knockdown Evaluation of RNAi Reagents