{"title":"基于本体的关系数据库模糊双极性连接查询评价","authors":"Nouredine Tamani, L. Lietard, D. Rocacher","doi":"10.1109/ISPS.2013.6581490","DOIUrl":null,"url":null,"abstract":"In the wake of flexible querying system, proposed in [26], [28], [29], in which the bipolarity of the form “and if possible” is used as means to express user preferences over relational databases and ontologies (fuzzy bipolar DLR-Lite), we introduce in this paper the user query evaluation process, under the extension of our flexible querying framework to bipolar conditions of the form “or else” [20], [19]. Queries addressed to our system are bipolar conjunctive queries made of a conjunction of atoms corresponding to concepts of an ontology. The proposed evaluation process is carried out in two main steps. The former consists of query derivation to compute complementary queries, based on substitutions of query's atoms involved in fuzzy bipolar subsumptions expressed in the considered bipolar ontology. The latter deals with the translation of the obtained set of queries from the first step into bipolar SQLf statements, which are finally evaluated over a bipolar relational database managed by PostgreSQLf DBMS extended to bipolar datatypes and functions. Three algorithms are then developed in order to perform applicable substitutions, to derive corresponding complementary queries and to translate them into Bipolar SQLf statements. The feasibility of the approach is shown through a prototype developed in the field of multimodal transport systems.","PeriodicalId":222438,"journal":{"name":"2013 11th International Symposium on Programming and Systems (ISPS)","volume":"156 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2013-04-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Ontology-based evaluation of fuzzy bipolar conjunctive queries over relational databases\",\"authors\":\"Nouredine Tamani, L. Lietard, D. Rocacher\",\"doi\":\"10.1109/ISPS.2013.6581490\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In the wake of flexible querying system, proposed in [26], [28], [29], in which the bipolarity of the form “and if possible” is used as means to express user preferences over relational databases and ontologies (fuzzy bipolar DLR-Lite), we introduce in this paper the user query evaluation process, under the extension of our flexible querying framework to bipolar conditions of the form “or else” [20], [19]. Queries addressed to our system are bipolar conjunctive queries made of a conjunction of atoms corresponding to concepts of an ontology. The proposed evaluation process is carried out in two main steps. The former consists of query derivation to compute complementary queries, based on substitutions of query's atoms involved in fuzzy bipolar subsumptions expressed in the considered bipolar ontology. The latter deals with the translation of the obtained set of queries from the first step into bipolar SQLf statements, which are finally evaluated over a bipolar relational database managed by PostgreSQLf DBMS extended to bipolar datatypes and functions. Three algorithms are then developed in order to perform applicable substitutions, to derive corresponding complementary queries and to translate them into Bipolar SQLf statements. The feasibility of the approach is shown through a prototype developed in the field of multimodal transport systems.\",\"PeriodicalId\":222438,\"journal\":{\"name\":\"2013 11th International Symposium on Programming and Systems (ISPS)\",\"volume\":\"156 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2013-04-22\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2013 11th International Symposium on Programming and Systems (ISPS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ISPS.2013.6581490\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2013 11th International Symposium on Programming and Systems (ISPS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ISPS.2013.6581490","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
在[26],[28],[29]中提出的灵活查询系统中,使用形式“and if possible”的双极性作为表达用户对关系数据库和本体的偏好的手段(模糊双极性DLR-Lite),本文介绍了用户查询评估过程,将我们的灵活查询框架扩展到形式“or else”的双极性条件下[20],[19]。向我们的系统提出的查询是由与本体概念相对应的原子的连接构成的双极连接查询。拟议的评价过程分两个主要步骤进行。前者由查询派生组成,以计算互补查询,基于在考虑的双极性本体中表示的模糊双极性包含中涉及的查询原子的替换。后者处理将从第一步获得的查询集转换为双极性SQLf语句,这些语句最后在扩展为双极性数据类型和函数的PostgreSQLf DBMS管理的双极性关系数据库上进行评估。然后开发了三种算法,以执行适用的替换,派生相应的补充查询并将其转换为Bipolar SQLf语句。通过在多式联运系统领域开发的原型,证明了该方法的可行性。
Ontology-based evaluation of fuzzy bipolar conjunctive queries over relational databases
In the wake of flexible querying system, proposed in [26], [28], [29], in which the bipolarity of the form “and if possible” is used as means to express user preferences over relational databases and ontologies (fuzzy bipolar DLR-Lite), we introduce in this paper the user query evaluation process, under the extension of our flexible querying framework to bipolar conditions of the form “or else” [20], [19]. Queries addressed to our system are bipolar conjunctive queries made of a conjunction of atoms corresponding to concepts of an ontology. The proposed evaluation process is carried out in two main steps. The former consists of query derivation to compute complementary queries, based on substitutions of query's atoms involved in fuzzy bipolar subsumptions expressed in the considered bipolar ontology. The latter deals with the translation of the obtained set of queries from the first step into bipolar SQLf statements, which are finally evaluated over a bipolar relational database managed by PostgreSQLf DBMS extended to bipolar datatypes and functions. Three algorithms are then developed in order to perform applicable substitutions, to derive corresponding complementary queries and to translate them into Bipolar SQLf statements. The feasibility of the approach is shown through a prototype developed in the field of multimodal transport systems.