SQL to SPARQL conversion for direct RDF querying

Abatal, Ahmed; Alaoui, Khadija; Bahaj, Mohamed; Alaoui, Larbi

doi:http://dx.doi.org/10.14569/IJACSA.2019.0101180

SQL to SPARQL conversion for direct RDF querying

License

Citation

Abatal A, Alaoui K, Bahaj M, Alaoui L. SQL to SPARQL conversion for direct RDF querying. Int J Adv Comput Sci Appl. 2019;10(11):599-604. DOI: 10.14569/IJACSA.2019.0101180

Abstract

With the advances in native storage means of RDF data and associated querying capabilities using SPARQL, there is a need to let SQL users benefit from such capabilities for interoperability objectives and without any conversion of the RDF data into relational data. In this sense, this work present SQL2SPARQL4RDF an automatic conversion algorithm of SQL queries into SPARQL queries for querying RDF data, which extends the previously established algorithm with relevant SQL elements such as queries with INSERT, DELETE, GROUP BY and HAVING clauses. SQL users are provided with a relational schema of their RDF data against which they can formulate their SQL queries that are then converted into SPARQL equivalent ones with respect to the provided schema. This avoids the birding of translating instances and data replication and thus saving load-ing times and guaranteeing fast execution especially in the case of massive amounts of data. In addition, the automatic mapping framework developed by the java programming language, and implement many new mapping functionalities. Furthermore, to test and validate the efficiency of the mapping approach and adding a module for automatic execution and evaluation of the various obtained SPARQL queries on Allegrograph.