Skip to main content

Advanced SQL-to-SPARQL Query Transformation Approach

  • Conference paper
  • First Online:
Advanced Information Technology, Services and Systems (AIT2S 2017)

Part of the book series: Lecture Notes in Networks and Systems ((LNNS,volume 25))

  • 871 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Antal, M., Anechitei D., Cuza, A.I.: SQL2SPARQL (2012)

    Google Scholar 

  2. Bechhofer, S.: OWL: Web ontology language. In: Encyclopedia of Database Systems, pp. 2008–2009. Springer US, (2009)

    Google Scholar 

  3. Schmidt, M.: Foundations of SPARQL Query Optimization (Doctoral dissertation, Institut für Informatik) (2009)

    Google Scholar 

  4. World Wide Web Consortium: RDF 1.1 Concepts and Abstract Syntax (2014)

    Google Scholar 

  5. Rachapalli, J., Khadilkar, V., Kantarcioglu, M., Thuraisingham, B.: RETRO: a framework for semantics preserving SQL-to-SPARQL translation. In: EvoDyn Workshop (2011)

    Google Scholar 

  6. Harris, S., Seaborne, A., Prud’hommeaux, E.: SPARQL 1.1 query language. W3C Recommendation, 21 (2013)

    Google Scholar 

  7. 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)

    Google Scholar 

  8. 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

    Google Scholar 

  9. Pérez, J., Arenas, M., Gutierrez, C.: Semantics and complexity of SPARQL. In: International Semantic Web Conference, pp. 30–43. Springer, Berlin, November 2006

    Google Scholar 

  10. Shadbolt, N., Berners-Lee, T., Hall, W.: The semantic web revisited. IEEE Intell. Syst. 21(3), 96–101 (2006)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Nassima Soussi .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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)

Publish with us

Policies and ethics