SQL Query Construction from Ontology Concept Descriptions
Author(s) -
Henrihs Gorskis
Publication year - 2018
Publication title -
information technology and management science
Language(s) - English
Resource type - Journals
eISSN - 2255-9094
pISSN - 2255-9086
DOI - 10.7250/itms-2018-0013
Subject(s) - computer science , query by example , information retrieval , sql , ontology , database , data definition language , process ontology , ontology based data integration , web search query , semantic web , philosophy , epistemology , search engine
Based on the usage of previously proposed database concepts as mapping point to a database in a domain ontology, the present paper describes the process of constructing SQL queries from them. The proposed database concepts allow for the mapping of domain concept to the source of data from a database. The paper describes the process of traversing the class hierarchy in an ontology for gathering these database concepts and constructing the SQL query. The purpose of the constructed SQL query is to obtain data from a database to populate the ontology with instances related to a selected ontology concept. The described process begins with the selection of one ontology concept, obtaining all directly related concepts, filtering and collecting database concepts, and finally constructing the SQL query.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom