{"title":"关系数据库中的模糊查询","authors":"Grzegorz Nowakowski","doi":"10.1109/IIPHDW.2018.8388376","DOIUrl":null,"url":null,"abstract":"This article presents various forms of fuzzy queries, a detailed analysis of these queries and their conversion into standard SQL queries by means of Oracle 11g XE. A qualitative and quantitative study about the use of fuzzy queries on relational databases has been included in this article, as well. Given that fuzzy queries arrange results according to the degree in which they meet the conditions of the query, it is easier to analyze the results and the risk of obtaining an empty result is reduced thanks to an extended interpretation of the conditions of the query. The provided examples of conversion of fuzzy queries into standard SQL queries by means of Oracle 11g XE point to easy to implement methods of obtaining fuzzy information from the database, and thereby expand its functionality.","PeriodicalId":405270,"journal":{"name":"2018 International Interdisciplinary PhD Workshop (IIPhDW)","volume":"21 3-4","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"3","resultStr":"{\"title\":\"Fuzzy queries on relational databases\",\"authors\":\"Grzegorz Nowakowski\",\"doi\":\"10.1109/IIPHDW.2018.8388376\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This article presents various forms of fuzzy queries, a detailed analysis of these queries and their conversion into standard SQL queries by means of Oracle 11g XE. A qualitative and quantitative study about the use of fuzzy queries on relational databases has been included in this article, as well. Given that fuzzy queries arrange results according to the degree in which they meet the conditions of the query, it is easier to analyze the results and the risk of obtaining an empty result is reduced thanks to an extended interpretation of the conditions of the query. The provided examples of conversion of fuzzy queries into standard SQL queries by means of Oracle 11g XE point to easy to implement methods of obtaining fuzzy information from the database, and thereby expand its functionality.\",\"PeriodicalId\":405270,\"journal\":{\"name\":\"2018 International Interdisciplinary PhD Workshop (IIPhDW)\",\"volume\":\"21 3-4\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2018-05-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"3\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2018 International Interdisciplinary PhD Workshop (IIPhDW)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/IIPHDW.2018.8388376\",\"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 International Interdisciplinary PhD Workshop (IIPhDW)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/IIPHDW.2018.8388376","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
This article presents various forms of fuzzy queries, a detailed analysis of these queries and their conversion into standard SQL queries by means of Oracle 11g XE. A qualitative and quantitative study about the use of fuzzy queries on relational databases has been included in this article, as well. Given that fuzzy queries arrange results according to the degree in which they meet the conditions of the query, it is easier to analyze the results and the risk of obtaining an empty result is reduced thanks to an extended interpretation of the conditions of the query. The provided examples of conversion of fuzzy queries into standard SQL queries by means of Oracle 11g XE point to easy to implement methods of obtaining fuzzy information from the database, and thereby expand its functionality.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
