Volume 13 Number 11 (Nov. 2018)
Home > Archive > 2018 > Volume 13 Number 11 (Nov. 2018) >
JSW 2018 Vol.13(11): 573-599 ISSN: 1796-217X
doi: 10.17706/jsw.13.11.573-599

An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology

Mohamed A. G. Hazber1*, Bing Li1, Guandong Xu2, Mohammed A. S. Mosleh3, Xiwu Gu4, and Yuhua Li4

1School of Computer Science, Wuhan University, Wuhan, China
2Advanced Analytics Institute, University of Technology Sydney, Australia
3School of IT & Science, Dr. G.R.Damodaran College of Science, Coimbatore, India
4School of Computer Science and Technology, Huazhong University of Science and Technology, Wuhan, China

Abstract— Semantic web is a web of linked RDF data that can exchange and reuse data allowing for more use of traditional web documents. However, the huge amount of data on the web are still formed and stored in relational databases (RDBs), such data cannot be used directly via the Semantic Web. Consequently, construction of ontology (Semantic Web -side) from relational schema and data (RDBs -side) and querying of constructed ontology semantically are fundamental challenges for the development and integration of the Semantic Web from the data source (i.e. database). This paper proposes an approach for providing a formulated operation rules to express semantic queries against structured graph ontology in the relational query language SQL. This approach applied by rewriting SPARQL queries over generated ontology (i.e. RDF triples) corresponding to advantages of SQLrelational algebra operation queries in RDBs and performed by two phases. The first phase focused on proposing and improving rules of extracting ontology directly from the important concepts in the relational database with considering database containing null-values to avoid data losses during the transformation process. The generated ontology represented in the form of OWL-RDFS/RDF triples to ensure its availability at Semantic Web, thus help semantic query engines to answer more queries. Furthermore, thefirst phase providing additional rules to generate the Internationalized Resource Identifiers (IRIs) for RDB schema and data. In the second phase, we proposed a set of rules inspired by fundamental operations of relational algebra (SQL algebra) for rewriting a relational algebra for SPARQL over RDBs that represented in RDF triples. In other words, translating SQL relational algebra operation queries into equivalent graph semantic queries (SPARQL). The proposed approach is demonstrated with examples, validated, implemented and compared with existing approach methods. The effectiveness of the proposed approach is evaluated by experimental results.

Index Terms—Semantic web, ontology, semantic query, SPARQL, transformation rule, relational database, SQL, relational algebra.


Cite: Mohamed A. G. Hazber 1*, Bing Li, Guandong Xu, Mohammed A. S. Mosleh, Xiwu Gu, and Yuhua Li, "An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology," Journal of Software vol. 13, no. 11, pp. 573-599, 2018.

General Information

ISSN: 1796-217X (Online)
Frequency:  Quarterly
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, CNKIGoogle Scholar, ProQuest, INSPEC(IET), ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsweditorialoffice@gmail.com
  • Mar 01, 2024 News!

    Vol 19, No 1 has been published with online version    [Click]

  • Jan 04, 2024 News!

    JSW will adopt Article-by-Article Work Flow

  • Apr 01, 2024 News!

    Vol 14, No 4- Vol 14, No 12 has been indexed by IET-(Inspec)     [Click]

  • Apr 01, 2024 News!

    Papers published in JSW Vol 18, No 1- Vol 18, No 6 have been indexed by DBLP   [Click]

  • Nov 02, 2023 News!

    Vol 18, No 4 has been published with online version   [Click]