-
Something wrong with this record ?
A comparison of approaches to accessing existing biological and chemical relational databases via SPARQL
J. Galgonek, J. Vondrášek
Status not-indexed Language English Country England, Great Britain
Document type Journal Article, Review
Grant support
LM2018131
Ministerstvo Školství, Mládeže a Tělovýchovy
RVO:61388963
Institute of Organic Chemistry and Biochemistry, Czech Republic
NLK
BioMedCentral
from 2009-12-01
BioMedCentral Open Access
from 2009
Directory of Open Access Journals
from 2009
Free Medical Journals
from 2009
PubMed Central
from 2009
Europe PubMed Central
from 2009
ProQuest Central
from 2009-01-01
Open Access Digital Library
from 2009-01-01
Open Access Digital Library
from 2009-01-01
Health & Medicine (ProQuest)
from 2009-01-01
ROAD: Directory of Open Access Scholarly Resources
from 2009
Springer Journals Complete - Open Access
from 2009-01-12
Springer Nature OA/Free Journals
from 2009-01-12
Springer Nature OA/Free Journals
from 2009-12-01
- Publication type
- Journal Article MeSH
- Review MeSH
Current biological and chemical research is increasingly dependent on the reusability of previously acquired data, which typically come from various sources. Consequently, there is a growing need for database systems and databases stored in them to be interoperable with each other. One of the possible solutions to address this issue is to use systems based on Semantic Web technologies, namely on the Resource Description Framework (RDF) to express data and on the SPARQL query language to retrieve the data. Many existing biological and chemical databases are stored in the form of a relational database (RDB). Converting a relational database into the RDF form and storing it in a native RDF database system may not be desirable in many cases. It may be necessary to preserve the original database form, and having two versions of the same data may not be convenient. A solution may be to use a system mapping the relational database to the RDF form. Such a system keeps data in their original relational form and translates incoming SPARQL queries to equivalent SQL queries, which are evaluated by a relational-database system. This review compares different RDB-to-RDF mapping systems with a primary focus on those that can be used free of charge. In addition, it compares different approaches to expressing RDB-to-RDF mappings. The review shows that these systems represent a viable method providing sufficient performance. Their real-life performance is demonstrated on data and queries coming from the neXtProt project.
References provided by Crossref.org
- 000
- 00000naa a2200000 a 4500
- 001
- bmc23009505
- 003
- CZ-PrNML
- 005
- 20230721095555.0
- 007
- ta
- 008
- 230707s2023 enk f 000 0|eng||
- 009
- AR
- 024 7_
- $a 10.1186/s13321-023-00729-5 $2 doi
- 035 __
- $a (PubMed)37340506
- 040 __
- $a ABA008 $b cze $d ABA008 $e AACR2
- 041 0_
- $a eng
- 044 __
- $a enk
- 100 1_
- $a Galgonek, Jakub $u Institute of Organic Chemistry and Biochemistry of the CAS, Flemingovo náměstí 2, 166 10, Prague 6, Czech Republic. jakub.galgonek@uochb.cas.cz
- 245 12
- $a A comparison of approaches to accessing existing biological and chemical relational databases via SPARQL / $c J. Galgonek, J. Vondrášek
- 520 9_
- $a Current biological and chemical research is increasingly dependent on the reusability of previously acquired data, which typically come from various sources. Consequently, there is a growing need for database systems and databases stored in them to be interoperable with each other. One of the possible solutions to address this issue is to use systems based on Semantic Web technologies, namely on the Resource Description Framework (RDF) to express data and on the SPARQL query language to retrieve the data. Many existing biological and chemical databases are stored in the form of a relational database (RDB). Converting a relational database into the RDF form and storing it in a native RDF database system may not be desirable in many cases. It may be necessary to preserve the original database form, and having two versions of the same data may not be convenient. A solution may be to use a system mapping the relational database to the RDF form. Such a system keeps data in their original relational form and translates incoming SPARQL queries to equivalent SQL queries, which are evaluated by a relational-database system. This review compares different RDB-to-RDF mapping systems with a primary focus on those that can be used free of charge. In addition, it compares different approaches to expressing RDB-to-RDF mappings. The review shows that these systems represent a viable method providing sufficient performance. Their real-life performance is demonstrated on data and queries coming from the neXtProt project.
- 590 __
- $a NEINDEXOVÁNO
- 655 _2
- $a časopisecké články $7 D016428
- 655 _2
- $a přehledy $7 D016454
- 700 1_
- $a Vondrášek, Jiří $u Institute of Organic Chemistry and Biochemistry of the CAS, Flemingovo náměstí 2, 166 10, Prague 6, Czech Republic
- 773 0_
- $w MED00181723 $t Journal of cheminformatics $x 1758-2946 $g Roč. 15, č. 1 (2023), s. 61
- 856 41
- $u https://pubmed.ncbi.nlm.nih.gov/37340506 $y Pubmed
- 910 __
- $a ABA008 $b sig $c sign $y p $z 0
- 990 __
- $a 20230707 $b ABA008
- 991 __
- $a 20230721095548 $b ABA008
- 999 __
- $a ok $b bmc $g 1958392 $s 1195769
- BAS __
- $a 3
- BAS __
- $a PreBMC-PubMed-not-MEDLINE
- BMC __
- $a 2023 $b 15 $c 1 $d 61 $e 20230620 $i 1758-2946 $m Journal of cheminformatics $n J Cheminform $x MED00181723
- GRA __
- $a LM2018131 $p Ministerstvo Školství, Mládeže a Tělovýchovy
- GRA __
- $a RVO:61388963 $p Institute of Organic Chemistry and Biochemistry, Czech Republic
- LZP __
- $a Pubmed-20230707