Cited By
View all- 高 金(2023)Research on Data Transformation Method Based on RDB-RDF Schema MappingHans Journal of Data Mining10.12677/HJDM.2023.13403313:04(335-351)Online publication date: 2023
SQL2SPARQL4RDF: Automatic SQL to SPARQL Conversion for RDF Querying
Article No.: 30, Pages 1 - 9
Abstract
With the progress of RDF data storage technologies and the associated query capabilities using SPARQL, there is a want to permit SQL customers benefit from such competencies for interoperability goals and with none conversion of the RDF facts into relational data.
In this context, we introduce SQL2SPARQL4RDF as an automatic SQL query conversion framework for RDF querying into SPARQL, that extends our previously developed algorithm with relevant SQL elements such as queries with UPDATE, INSERT, DELETE, GROUP BY, ORDER BY and HAVING clauses. in addition, our automatic mapping framework is developed by the java programming language has been extended with the implementation of new mapping features. Moreover, to verify and test the efficiency of our mapping tool, we have also added a layer for the automatic execution of SPARQL queries obtained for viewing to result a graphic interface.
References
[1]
R2RML: RDB to RDF Mapping Language: https://www.w3.org/TR/r2rml/.
[2]
Allegrograph: http://www.franz.com.
[3]
Bioportal, http://sparql.bioontology.org/.
[4]
Chhaya, P. et al.: Using D2RQ and Ontop to publish relational database as Linked Data. In: ICUFN. pp. 694--698 IEEE (2016).
[5]
Kruti Jani, Dr. V.M. Chavda A Study on Semantic Web Framework: JENA and Protégé Indian Journal of Applied Research, Vol.IV, Issue. I - Jan 2014
[6]
F. Alam, S. Ali, M. A. Khan, S. Khusro, A. Rauf, "A Comparative Study of RDF and Topic Maps Development Tools and APIs", BUJICT Journal, Volume 7, Issue 1, December 2014, pp. 1--12.
[7]
W3C: SPARQL Protocol for RDF. http://www.w3.org/TR/rdf-sparql-protocol/.
[8]
W3C: SPARQL Query Language for RDF. http://www.w3.org//TR/rdf-sparql-query/.
[9]
D. J. Abadi, A. Marcus, S. R. Madden, and K. Hollenbach. Scalable semantic web data management using vertical partitioning. In VLDB, pages 411--422, 2007.
[10]
L. Alaoui, A. Abatal, K. Alaoui, M. Bahaj and I. Cherti, (2015). SQL to SPARQL mapping for RDF querying based on a new Efficient Schema Conversion Technique. International Journal of Engineering Research and Technology, 4(10). IJERT.
[11]
S. Anand and A. Verma, (2010). Development of Ontology for Smart Hospital and Implementation using UML and RDF. IJCSI Int. J. of Computer Science Issues, Vol. 7, Issue 5.
[12]
P. Bellini and P. Nesi (2018). Performance assessment of RDF graph databases for smart city services. Journal of Visual Languages and Computing 45, 24--38.
[13]
J. Broekstra, A. Kampman and F. van Harmelen (2002). Sesame: a generic architecture for storing and querying RDF and RDF schema. In: ISWC, pp. 54--68.
[14]
E. I. Chong, S. Das, G. Eadon and J. Srinivasan (2005). An efficient SQL based RDF querying scheme. In: VLDB, pp. 1216--1227.
[15]
G. Garbis, K. Kyzirakos and M. Koubarakis (2013). Geographica: a benchmark for geospatial RDF stores. In Proceedings of the 12th International Semantic Web Conference, 343--359.
[16]
F. Goasdoué, Z. Kaoudi, I. Manolescu, J. A. Quiané-Ruiz and S. Zampetakis (apr 2015). CliqueSquare: Flat plans for massively parallel RDF queries. In: 2015 IEEE 31st International Conference on Data Engineering. pp. 771--782.
[17]
S. Harris, N. Lamb and N. Shadbolt (2009). 4store: The design and implementation of a clustered RDF store. In Proceedings of the 5th Int. Workshop on Scalable Semantic Web Knowledge Base Systems, 16.
[18]
J. Lu, L. Ma, L. Zhang, J.-S. Brunner, C. Wang, Y. Pan and Y. Yu (2007). SOR: A practical system for ontology storage, reasoning and search. In: Proceedings of VLDB, pp. 1402--1405.
[19]
T. Neumann and G. Weikum (2010). The RDF-3X engine for scalable management of RDF data. The VLDB Journal, 19(1):91--113.
[20]
J. Rachapalli, V. Khadilkar, M. Kantarcioglu and B. Thuraisingham (2011). RETRO: a framework for semantics preserving SQL-to-SPARQL translation. In: EvoDyn Workshop.
[21]
[21] K. Rohloff and R. E. Schantz 2010). High-performance, massively scalable distributed systems using the mapreduce software framework: the shard triplestore. In ACM Programming Support Innovations for Emerging Distributed Applications, 2010
Recommendations
On directly mapping relational databases to RDF and OWL
WWW '12: Proceedings of the 21st international conference on World Wide WebMapping relational databases to RDF is a fundamental problem for the development of the Semantic Web. We present a solution, inspired by draft methods defined by the W3C where relational databases are directly mapped to RDF and OWL. Given a relational ...
D2RQ/update: updating relational data via virtual RDF
WWW '12 Companion: Proceedings of the 21st International Conference on World Wide WebD2RQ is a popular RDB-to-RDF mapping platform that supports mapping relational databases to RDF and posing SPARQL queries to these relational databases. However, D2RQ merely provides a read-only RDF view on relational databases. Thus, we introduce D2RQ/...
A complete translation from SPARQL into efficient SQL
IDEAS '09: Proceedings of the 2009 International Database Engineering & Applications SymposiumThis paper presents a feature-complete translation from SPARQL, the proposed standard for RDF querying, into efficient SQL. We propose "SQL model"-based algorithms that implement each SPARQL algebra operator via SQL query augmentation, and generate a ...
Comments
Information & Contributors
Information
Published In
October 2019
476 pages
ISBN:9781450372404
DOI:10.1145/3372938
- Conference Chairs:
- Mohamed Lazaar,
- Claude Duvallet,
- Mohammed Al Achhab,
- Oussama Mahboub,
- Hassan Silkan
Copyright © 2019 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 07 January 2020
Check for updates
Author Tags
Qualifiers
- Research-article
- Research
- Refereed limited
Conference
BDIoT'19
BDIoT'19: The 4th International Conference On Big Data and Internet of Things
October 23 - 24, 2019
Rabat, Morocco
Acceptance Rates
BDIoT '19 Paper Acceptance Rate 75 of 136 submissions, 55%;
Overall Acceptance Rate 75 of 136 submissions, 55%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 206Total Downloads
- Downloads (Last 12 months)8
- Downloads (Last 6 weeks)0
Reflects downloads up to 10 Nov 2024
Other Metrics
Citations
Cited By
View all- 高 金(2023)Research on Data Transformation Method Based on RDB-RDF Schema MappingHans Journal of Data Mining10.12677/HJDM.2023.13403313:04(335-351)Online publication date: 2023
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in