Abstract
No one can deny the emergence of semantic web technologies with their considerable performance in data management offering a better cooperation between people and computers, but unfortunately, relational databases are still the most used; therefore establishing a connection between them becomes an active topic aiming to bridge the gap between the both heterogeneous systems. Regarding the interoperability between their query languages, more precisely, SQL-to-SPARQL query transformation direction, some solutions have been explored to ensure this conversion, but all these approaches have the same gap because they start the mapping process before analyzing and optimizing the input SQL query; this weakness has motivated us to add a pretreatment phase aiming to optimize some SQL components with a specific focus on Left and Right Outer Join command(s) generating the most complex component SPARQL query (Optional pattern(s)) in order to reduce complexity of the output SPARQL query.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Antal, M., Anechitei D., Cuza, A.I.: SQL2SPARQL (2012)
Bechhofer, S.: OWL: Web ontology language. In: Encyclopedia of Database Systems, pp. 2008–2009. Springer US, (2009)
Schmidt, M.: Foundations of SPARQL Query Optimization (Doctoral dissertation, Institut für Informatik) (2009)
World Wide Web Consortium: RDF 1.1 Concepts and Abstract Syntax (2014)
Rachapalli, J., Khadilkar, V., Kantarcioglu, M., Thuraisingham, B.: RETRO: a framework for semantics preserving SQL-to-SPARQL translation. In: EvoDyn Workshop (2011)
Harris, S., Seaborne, A., Prud’hommeaux, E.: SPARQL 1.1 query language. W3C Recommendation, 21 (2013)
Alaoui, L., Abatal, A., Alaoui, K., Bahaj, M., Cherti, I.: SQL to SPARQL mapping for RDF querying based on a new efficient schema conversion technique. Int. J. Eng. Res. Technol. IJERT 4(10), 57–61 (2015)
Ramanujam, S., Gupta, A., Khan, L., Seida, S., Thuraisingham, B.: R2D: A bridge between the semantic web and relational visualization tools. In: IEEE International Conference on Semantic Computing, ICSC 2009, pp. 303–311. IEEE, September 2009
Pérez, J., Arenas, M., Gutierrez, C.: Semantics and complexity of SPARQL. In: International Semantic Web Conference, pp. 30–43. Springer, Berlin, November 2006
Shadbolt, N., Berners-Lee, T., Hall, W.: The semantic web revisited. IEEE Intell. Syst. 21(3), 96–101 (2006)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG
About this paper
Cite this paper
Soussi, N., Bahaj, M. (2018). Advanced SQL-to-SPARQL Query Transformation Approach. In: Ezziyyani, M., Bahaj, M., Khoukhi, F. (eds) Advanced Information Technology, Services and Systems. AIT2S 2017. Lecture Notes in Networks and Systems, vol 25. Springer, Cham. https://doi.org/10.1007/978-3-319-69137-4_33
Download citation
DOI: https://doi.org/10.1007/978-3-319-69137-4_33
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-69136-7
Online ISBN: 978-3-319-69137-4
eBook Packages: EngineeringEngineering (R0)