Detail
Article
Online article
FT
Medvik - BMC
  • Something wrong with this record ?

A comparison of approaches to accessing existing biological and chemical relational databases via SPARQL

J. Galgonek, J. Vondrášek

. 2023 ; 15 (1) : 61. [pub] 20230620

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

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

Find record

Citation metrics

Loading data ...

Archiving options

Loading data ...