Federated SPARQL query performance evaluation for exploring disease model mouse: combining gene expression, orthology, and disease knowledge graphs
Open Access
- 1 March 2025
- journal article
- research article
- Published by Springer Nature in BMC Medical Informatics and Decision Making
- Vol. 25 (S1) , 1
Abstract
Background: The RIKEN BRC develops and maintains the RIKEN BioResource MetaDatabase to help users explore appropriate target bioresources for their experiments and prepare precise and high-quality data infrastructures. The Swiss Institute of Bioinformatics develops two databases across multi-species for the study of gene expression and orthology: Bgee and Orthologous MAtrix (OMA, an orthology database). Methods: This study combines the RIKEN BioResource data with Resource Description Framework (RDF) datasets from Bgee, a gene expression database, the OMA, the DisGeNET, a human gene-disease association, Mouse Genome Informatics (MGI), UniProt, and four disease ontologies in the RIKEN BioResource MetaDatabase. Our aim is to evaluate the distributed SPARQL query performance when exploring which model organisms are most appropriate for specific medical science research applications across the aforementioned interoperable datasets. More precisely in our biomedical use cases, we investigate disease-related genes, as well as anatomical parts where these genes are expressed and subsequently identify appropriate bioresource candidates available for specific disease research applications. Results: We illustrate the above through two use cases targeting either Alzheimer’s disease or melanoma. We identified 14 Alzheimer’s disease-related genes that were expressed in the prefrontal cortex (e.g., APP and APOE) and 55 RIKEN bioresources, which were genetically modified mice related to these genes, predicted to be relevant to Alzheimer’s disease research. Furthermore, executing a transitive search for the Uberon terms by using the Property Paths function, we identified 14 melanoma-related genes (e.g., HRAS and PTEN), and 12 anatomical parts in which these genes were expressed, such as the “skin of limb” as an example. Finally, we compared the performance of the federated SPARQL query via the remote Bgee SPARQL endpoint with the performance of a centralized SPARQL query using the Bgee dataset as part of the RIKEN BioResource MetaDatabase. Conclusions: As a result, we confirmed that the performance of the federated approach degraded. We concluded that we reduced the degradation of the query performance of the federated approach from the BioResource MetaDatabase to the SIB by refining the transferred data through a subquery and enhancing the server specifications thereby optimizing the triple store query evaluation.Keywords
This publication has 32 references indexed in Scilit:
- Mouse Genome Informatics (MGI): latest news from MGD and GXDMammalian Genome, 2021
- The DisGeNET cytoscape app: Exploring and visualizing disease genomics dataComputational and Structural Biotechnology Journal, 2021
- KG-COVID-19: A Framework to Produce Customized Knowledge Graphs for COVID-19 ResponsePatterns, 2021
- The Odyssey Approach for Optimizing Federated SPARQL Queries2017
- HiBISCuS: Hypergraph-Based Source Selection for SPARQL Endpoint Federation2014
- FedX: A Federation Layer for Distributed Query Processing on Linked Open Data2011
- Semantics and Optimization of the SPARQL 1.1 Federation Extension2011
- Cooperative interactions of PTEN deficiency and RAS activation in melanoma metastasisOncogene, 2010
- The mammalian phenotype ontology: enabling robust annotation and comparative analysisWIREs Mechanisms of Disease, 2009
- Querying Distributed RDF Data Sources with SPARQL2008