首页    期刊浏览 2024年11月30日 星期六
登录注册

文章基本信息

  • 标题:An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology
  • 本地全文:下载
  • 作者:Mohamed A. G. Hazber ; Bing Li ; Guandong Xu
  • 期刊名称:Journal of Software
  • 印刷版ISSN:1796-217X
  • 出版年度:2018
  • 卷号:13
  • 期号:11
  • 页码:573-599
  • DOI:10.17706/jsw.13.11.573-599
  • 出版社:Academy Publisher
  • 摘要: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.
  • 其他关键词:Semantic web, ontology, semantic query, SPARQL, transformation rule, relational database, SQL, relational algebra.
国家哲学社会科学文献中心版权所有