Open Access   Article Go Back

A Model for Mapping Semantic Web Data with Heterogeneous Data Sources Using SPARQL

R. Gupta1 , S.K. Malik2

Section:Research Paper, Product Type: Journal Paper
Volume-6 , Issue-6 , Page no. 243-254, Jun-2018

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v6i6.243254

Online published on Jun 30, 2018

Copyright © R. Gupta, S.K. Malik . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: R. Gupta, S.K. Malik, “A Model for Mapping Semantic Web Data with Heterogeneous Data Sources Using SPARQL,” International Journal of Computer Sciences and Engineering, Vol.6, Issue.6, pp.243-254, 2018.

MLA Style Citation: R. Gupta, S.K. Malik "A Model for Mapping Semantic Web Data with Heterogeneous Data Sources Using SPARQL." International Journal of Computer Sciences and Engineering 6.6 (2018): 243-254.

APA Style Citation: R. Gupta, S.K. Malik, (2018). A Model for Mapping Semantic Web Data with Heterogeneous Data Sources Using SPARQL. International Journal of Computer Sciences and Engineering, 6(6), 243-254.

BibTex Style Citation:
@article{Gupta_2018,
author = {R. Gupta, S.K. Malik},
title = {A Model for Mapping Semantic Web Data with Heterogeneous Data Sources Using SPARQL},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {6 2018},
volume = {6},
Issue = {6},
month = {6},
year = {2018},
issn = {2347-2693},
pages = {243-254},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=2171},
doi = {https://doi.org/10.26438/ijcse/v6i6.243254}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v6i6.243254}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=2171
TI - A Model for Mapping Semantic Web Data with Heterogeneous Data Sources Using SPARQL
T2 - International Journal of Computer Sciences and Engineering
AU - R. Gupta, S.K. Malik
PY - 2018
DA - 2018/06/30
PB - IJCSE, Indore, INDIA
SP - 243-254
IS - 6
VL - 6
SN - 2347-2693
ER -

VIEWS PDF XML
618 417 downloads 379 downloads
  
  
           

Abstract

Semantic Web is extending web2.0 to web3.0 with an idea of incorporating intelligence or meaning to the existing web. Relational databases have been playing a crucial role in software development since many years. Also rapidly developing semantic web is based on mapping and compatibility of the existing data on the web which may be either in relational or non-relational form. RDF & Web Ontology are two major representations in semantic web, and SPARQL is a query language, used to query data from different semantic web resources like RDF/OWL/LOD (Linked Open Data). SPARQL processing and execution is playing a crucial role in mapping data from different sources. In this paper, first, a brief literature survey is being presented and discussed, focusing on SPARQL usage in mapping. Second, it focuses on various concerns of SPARQL query processing and execution in different domains along with SQL conversions and illustrations. Third, it presents analysis of various approaches and tools for the migration of data into semantic web from other data sources supported by a proposed model for information processing.

Key-Words / Index Term

SPARQL, RDF, OWL, LOD, Hadoop, Relational Databases (RDB), D2RQ, Twinkle, Jena fuseki, Jena ARQ, DBpedia

References

[1] E. Prud`hommeaux, A. Seaborne, “SPARQL Query Language for RDF,” W3C Recommendations , Jan , 2008.
[2] RDF Working Group, “RDF,” W3C Working Group, February 2014.
[3] A. Cuzzocrea, R. Buyya, V. Passanisi and G. Pilato, "MapReduce based Algorithms for managing Big RDF Graphs: State-of-art analysis, paradigms and future directions," in Cluster, Cloud and Grid Computing (CCGRID), 2017.
[4] H. Naacke, O. Curé and B. Amann, "SPARQL query processing with Apache Spark," arXiv.org Database, 2016.
[5] M. Franck, F. Moantagnat and C. Zucker, "A Survey of RDB to RDF translation approaches and Tools," laboratory informatiue, signaux et systems de Sophia antipolis, 2014.
[6] M. Hazber, R. Li, X. Gu, G. Xu and Y. Li, "Semantic SPARQL query in a relational database based on ontology construction," in International conference on Semantics, Knowledge and Grids, IEEE, 2015.
[7] OWL Working Group, "Web Ontology Language," 2012.
[8] S. Harris and A. Seaborne, "SPARQL 1.1 Query Language," 21 March 2013.
[9] A. Schatzle, M. Przyjaciel, S. Skilevic and G. Lausen, "S2RDF:RDF Querying with SPARQL on Spark," in VLDB Endowment, 2016.
[10] M. Grobe, "RDF, Jena, SPARQL and the Semantic Web," in SIGUCCS, Indianapolis, Indiana, USA, 2009.
[11] O. Hartig and G. Pirro, "SPARQL with Property Paths on the Web," Semantic Web Journal IOS Press, 2016.
[12] D. Spanos, P. Stavrou and N. Mitrou, "Bringing relational databases into the Semantic Web: A survey," Semantic Web Journal IOS Press, pp. 169-209, 2012.
[13] B. DuCharme, Learning SPARQL: Querying and.updating with SPARQL 1.1, O’REILLY, 2nd Edition., 2013.
[14] T. White, Hadoop: The Definitive Guide, April: O`REILLY, 2015.
[15] J. Cardoso and A. Pinto, "‘The Web Ontology Language (OWL) and its applications," IGI Global, 2015.
[16] B. Motik, P. Patel-Schneider and B. Grau, "OWL 2 Web Ontology Language," 2012.
[17] O. Hartig and R. Heese, "The SPARQL Query Graph Model for Query Optimization," in In Proceedings of the 4th European Semantic Web Conference (ESWC), Innsbruck, Austria, 2007.
[18] A. Chebotko, S. Lu, H. Jamil and F. Fotouhi, "Semantics Preserving SPARQL-to-SQL Query Translation for Optional Graph Patterns,," Technical Report TR-DB-052006-CLJF., 2016.
[19] P. Nikolaos, K. Ioannis, T. Dimitrios, K. Panagiotis and K. Nectarios, "H2RDF+: High-performance distributed joins over large-scale RDF graphs," in Big Data, 2013 IEEE International Conference on, 2013.
[20] J. Panawong, T. Ruangrajitpakorn and M. Buranarach, "An Automatic Database Generation and Ontology Mapping from OWL File," JIST, 2016.
[21] B. Bellini, P. Nesi and A. Venturi, "Linked open graph: Browsing multiple SPARQL entry points to build your own LOD views," Journal of Visual Languages & Computing, vol. 25, no. 6, pp. 703-716, December 2014.
[22] H. Oh, S. Chun, S. Eom and K. Lee, "Job-Optimized Map-Side Join Processing using MapReduce and HBase with Abstract RDF Data," in International Conference on Web Intelligence and Intelligent Agent Technology, 2015.
[23] T. Garcia and T. Wang, "Analysis of Big Data Technologies and Method - Query Large Web Public RDF Datasets on Amazon Cloud Using Hadoop and Open Source Parsers," in Seventh International Conference Semantic Computing (ICSC), Irvine, CA, USA, 2013.
[24] K. D. Mogotlane and J. Domneu, "Automatic Conversion of Relational databases into Ontologies: A Comparative Analysis of PROTÉGÉ Plug-ins Performances," International Journal of web & Semantic Technology (IJWest), 2016.
[25] K. Anyanwu, "A vision for SPARQL multi-query optimization on MapReduce," in 29th International Conference on Data Engineering Workshops (ICDEW), Brisbane, QLD, Australia, 2013.
[26] J. Lu, F. Cao, L. Ma ,Y. Yu1 and Y. Pan, “An Effective SPARQL Support over Relational Databases”, Springer-Verlag, Berlin Heidelberg, 2008.
[27] D. E. Spanos, P. Stavrou and N. Mitrou, "Bringing Relational Databases into the Semantic Web: A Survey," Semantic Web IOS Press, 2012.
[28] T. Health and C. Bizer, "Linked Data: Evolving the web into a Global Data Space," 2011.
[29] D. Calvanese, B. Cogrel, S. Komla-Ebri, R. Kontchakov, D. Lanti, M. Rezk, M. Rodriguez-Muro and G. Xiao, "Ontop: Answering SPARQL Queries over Relational Databases," Semantic Web Journal,IOS Press., 2016.
[30] Q. Trinh, K. Barker and R. Alhajj, "RDB2ONT: A Tool for Generating OWL Ontologies From Relational Database Systems," in Advanced International Conference on Telecommunications and International Conference on Internet and Web Applications and Services, 2006.
[31] J. Barrasa, O. Corcho and A. Perez, "R2O, an Extensible and Semantically Based Databaseto-ontology Mapping Language," in Second Workshop on Semantic Web and Databases, Springer-Verlag, Canada, 2004.
[32] C. P. d. Laborda and S. Conrad, "Relaional.OWL- A Data and schema representation format based on OWL," in Second Asia-Pacific Conference on Conceptual Modeling (APCCM2005),, 2005.
[33] G. Bumans, "Relational Database information availability to Semantic Web technologies," 2014.
[34] R. Gupta and S. Malik, "SPARQL Usage for Mapping Semantic Web Data (OWL/RDF) from Relational Database: A Revisit," in System Modeling and Advancement in Research Trends (SMART-2017), 2017.
[35] S. B. V. T. Aver, “Linked Open Data-Creating Knowledge out of the Interlinked Data", Springer, 2014.
[36] O. Hartig and J. Pérez, “LDQL: A Query Language for the Web of Linked Data”, Journal of Web Semantics, pp 9-29, 2016.
[37] A. Schätzle, M. Przyjaciel-Zablocki, T. Hornung and G. Lausen, "PigSPARQL: a SPARQL query processing baseline for big data," in ISWC-PD `13 Proceedings of the 12th International Semantic Web Conference (Posters & Demonstrations Track), Sydney, Australia, 2013.
[38] M.Ahmed , “Semantic Based Intelligent Information Retrieval through Data Mining and Ontology”, International Journal of Computer Sciences and Engineering. pp. 210-217, 2017.