{"title":"从数据库概念构造SQL查询","authors":"Henrihs Gorskis","doi":"10.1109/ITMS.2018.8552953","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":367060,"journal":{"name":"2018 59th International Scientific Conference on Information Technology and Management Science of Riga Technical University (ITMS)","volume":"19 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2018-10-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"SQL query construction from database concepts\",\"authors\":\"Henrihs Gorskis\",\"doi\":\"10.1109/ITMS.2018.8552953\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":367060,\"journal\":{\"name\":\"2018 59th International Scientific Conference on Information Technology and Management Science of Riga Technical University (ITMS)\",\"volume\":\"19 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2018-10-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2018 59th International Scientific Conference on Information Technology and Management Science of Riga Technical University (ITMS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ITMS.2018.8552953\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2018 59th International Scientific Conference on Information Technology and Management Science of Riga Technical University (ITMS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ITMS.2018.8552953","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
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.