Semantic SPARQL query in a relational database based on ontology construction

被引:3
|
作者
Hazber, Mohamed A. G. [1 ]
Li, Ruixuan [1 ]
Gu, Xiwu [1 ]
Xu, Guandong [2 ]
Li, Yuhua [1 ,3 ]
机构
[1] Huazhong Univ Sci & Technol, Sch Comp Sci & Technol, Wuhan, Peoples R China
[2] Univ Technol Sydney, Fac Engn & IT, Adv Analyt Inst, Sydney, NSW, Australia
[3] Wuhan Univ, State Key Lab Software Engn, Wuhan, Peoples R China
关键词
Relational database; Ontology; SQL algebra; SPARQL; Mapping rule;
D O I
10.1109/SKG.2015.14
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
Constructing an ontology from RDBs and its query through ontologies is a fundamental problem for the development of the semantic web. This paper proposes an approach to extract ontology directly from RDB in the form of OWL/RDF triples, to ensure its availability at semantic web. We automatically construct an OWL ontology from RDB schema using direct mapping rules. The mapping rules provide the basic rules for generating RDF triples from RDB data even for column contents null value, and enable semantic query engines to answer more relevant queries. Then we rewriting SPARQL query from SQL by translating SQL relational algebra into an equivalent SPARQL. The proposed method is demonstrated with examples and the effectiveness of the proposed approach is evaluated by experimental results.
引用
收藏
页码:25 / 32
页数:8
相关论文
共 50 条
  • [1] RETRACTED: Semantic query in a relational database using a local ontology construction (Retracted Article)
    Sedighi, Saeed M.
    Javidan, Reza
    [J]. SOUTH AFRICAN JOURNAL OF SCIENCE, 2012, 108 (11-12) : 76 - 85
  • [2] SPARQL query processing with conventional relational database systems
    Harris, S
    Shadbolt, N
    [J]. WEB INFORMATION SYSTEMS ENGINEERING - WISE 2005 WORKSHOPS, PROCEEDINGS, 2005, 3807 : 235 - 244
  • [3] Ontology based heterogeneous materials database integration and semantic query
    Zhao, Shuai
    Qian, Quan
    [J]. AIP ADVANCES, 2017, 7 (10):
  • [4] Construction method of domain ontology based on a relational database
    Jing, Xu
    [J]. AGRO FOOD INDUSTRY HI-TECH, 2017, 28 (01): : 2080 - 2084
  • [5] Usage of the Jess Engine, Rules and Ontology to Query a Relational Database
    Bak, Jaroslaw
    Jedrzejek, Czeslaw
    Falkowski, Maciej
    [J]. RULE INTERCHANGE AND APPLICATIONS, PROCEEDINGS, 2009, 5858 : 216 - 230
  • [6] Research of Oracle Bone Inscriptions Ontology Construction Based on Relational Database
    Xiong Jing
    Liu Yong-ge
    Gao Feng
    Wang Ji-peng
    [J]. 2011 2ND INTERNATIONAL CONFERENCE ON CHALLENGES IN ENVIRONMENTAL SCIENCE AND COMPUTER ENGINEERING (CESCE 2011), VOL 11, PT A, 2011, 11 : 447 - 451
  • [7] A On-demand mapping method on query request in Relational Database Semantic Query
    Zhang, Haifei
    [J]. INFORMATION TECHNOLOGY APPLICATIONS IN INDUSTRY II, PTS 1-4, 2013, 411-414 : 341 - 344
  • [8] Ontology-based Semantic Annotation in Semantic Query
    Wu, Chengwen
    Jin, Kezhong
    Huang, Changcheng
    Liu, Wenbin
    [J]. ACC 2009: ETP/IITA WORLD CONGRESS IN APPLIED COMPUTING, COMPUTER SCIENCE, AND COMPUTER ENGINEERING, 2009, : 280 - 283
  • [9] MDX2SPARQL: Semantic query mapping of OLAP query language to SPARQL
    Boumhidi, Haytem
    Nfaoui, El Habib
    Oubenaalla, Younes
    [J]. 2018 INTERNATIONAL CONFERENCE ON INTELLIGENT SYSTEMS AND COMPUTER VISION (ISCV2018), 2018,
  • [10] Relational Schemata for Distributed SPARQL Query Processing
    Arrascue, Victor Anthony A.
    Koleva, Polina
    Alzogbi, Anas
    Cossu, Matteo
    Faerber, Michael
    Philipp, Patrick
    Schievelbein, Guilherme
    Taxidou, Io
    Lausen, Georg
    [J]. PROCEEDINGS OF THE INTERNATIONAL WORKSHOP ON SEMANTIC BIG DATA (SBD 2019), 2019,