SQL Query Construction from Database Concepts

2018 59th International Scientific Conference on Information Technology and Management Science of Riga Technical University (ITMS 2018) 2018
Henrihs Gorskis

The paper extends on previously proposed database concepts and their use as mapping point to a database in a domain ontology. It describes the process of constructing SQL queries from them. The proposed database concepts allow for the mapping of domain concept to the sources of data from a database. The paper describes the process of traversing the class hierarchy in an ontology. This is done to gather database concepts and to construct a SQL query. The purpose of the constructed SQL query is to obtain data from a database and to populate the ontology. It is populated with instances related to the selected ontology concept. The described process begins with the selection of one ontology concept, continues with obtaining all directly related concepts from the ontology, filtering and collecting database concepts, and y finishes with constructing the SQL query.

Atslēgas vārdi
Databases, Ontologies, Data mining, Structured Query Language, Ontology, database, data access
DOI
10.1109/ITMS.2018.8552953
Hipersaite
http://ieeexplore.ieee.org.resursi.rtu.lv/stamp/stamp.jsp?tp=&arnumber=8552953&isnumber=8552946

Gorskis, H. SQL Query Construction from Database Concepts. No: 2018 59th International Scientific Conference on Information Technology and Management Science of Riga Technical University (ITMS 2018), Latvija, Riga, 10.-12. oktobris, 2018. Piscataway: IEEE, 2018, 50.-53.lpp. ISBN 978-1-7281-0099-9. e-ISBN 978-1-7281-0098-2. Pieejams: doi:10.1109/ITMS.2018.8552953

Publikācijas valoda
English (en)