2020•International Journal of High Performance Systems ArchitectureRequires access

RETRO +: SQL to SPARQL improvement of the RETRO framework

Larbi Alaoui, Mohamed Bahaj, Ahmed Abatal

Open publisher page 0 citations

Abstract

Semantic web has recently gained a great attention due to its potential for providing a common framework that allows data sharing and reprocessed, relational databases are still the most used. To deal with the variety of modern database formats and query languages, we propose an approach to translate SQL queries into equivalent SPARQL queries for querying resource description framework (RDF) data. The main purpose is to give an extension of the Retro framework by adding a set of algorithms to improve its function. The algorithms in question deal with the conversion of the relevant SQL queries INSERT, UPDATE, DELETE and improve the SELECT query by adding the aggregate function, GROUP BY and ORDER BY in equivalent SPARQL queries and validate all translated queries on allegrograph.

About this research paper

What this paper is about

Semantic web has recently gained a great attention due to its potential for providing a common framework that allows data sharing and reprocessed, relational databases are still the most used. To deal with the variety of modern database formats and query languages, we propose an approach to translate SQL queries into equivalent SPARQL queries for querying resource description framework (RDF) data. The main purpose is to give an extension of the Retro framework by adding a set of algorithms to improve its function. The algorithms in question deal with the conversion of the relevant SQL queries INSERT, UPDATE, DELETE and improve the SELECT query by adding the aggregate function, GROUP BY and ORDER BY in equivalent SPARQL queries and validate all translated queries on allegrograph.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Semantic web has recently gained a great attention due to its potential for providing a common framework that allows data sharing and reprocessed, relational databases are still the most used. To deal with the variety of modern database formats and query languages, we propose an approach to translate SQL queries into equivalent SPARQL queries for querying resource description framework (RDF) data. The main purpose is to give an extension of the Retro framework by adding a set of algorithms to improve its function. The algorithms in question deal with the conversion of the relevant SQL queries INSERT, UPDATE, DELETE and improve the SELECT query by adding the aggregate function, GROUP BY and ORDER BY in equivalent SPARQL queries and validate all translated queries on allegrograph.

Key concepts: SPARQL, Computer science, SQL, RDF, Information retrieval, Query by Example, Spatial query, Query language

Related papers

Back to paper searchBrowse research topicsOriginal source
RETRO +: SQL to SPARQL improvement of the RETRO framework — Research Paper | ScholarLens