Title: RETRO +: SQL to SPARQL improvement of the RETRO framework

Authors: Ahmed Abatal; Larbi Alaoui; Mohamed Bahaj

Addresses: Mathematics and Computer Science Department, Hassan 1st University, Settat, 26000, Morocco ' Mathematics and Computer Science Department, International University of Rabat, Sale El Jadida, 11100, Morocco ' Mathematics and Computer Science Department, Hassan 1st University, Settat, 26000, Morocco

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.

Keywords: SPARQL; SQL; SQL-to-SPARQL; QUERY translation; schema mapping; RETRO; RDB; relational databases; RDF; resource description framework; semantic web; allegrograph.

DOI: 10.1504/IJHPSA.2020.113687

International Journal of High Performance Systems Architecture, 2020 Vol.9 No.4, pp.215 - 222

Received: 22 Aug 2019
Accepted: 23 Aug 2020
Published online: 18 Mar 2021 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article