{"title":"不精确数据的高效查询处理","authors":"","doi":"10.30534/ijatcse/2022/031142022","DOIUrl":null,"url":null,"abstract":"In real world applications we often need to test the queries based on fuzzy data. For example, some one can specify as “find students’ whose age is around 17 years old.”; “find tall person”. “find employee with high salary”; “find country with low population” etc. This fuzziness in measurement is captured in this paper. To test such fuzzy queries, we have developed an algorithm that is applicable universally to any type of database. In this paper first we have designed architecture to test fuzzy query. In the architecture we have defined an algorithm to find the membership value for each tuple of the relation based on the fuzzy attributes on which fuzzy query is made. Next Decision Maker (DM) will supply a threshold value or -cut based on which corresponding SQL of the given fuzzy query will be generated. This SQL will retrieve the resultant tuples from the database. Finally we have tested our algorithm with an example.","PeriodicalId":129636,"journal":{"name":"International Journal of Advanced Trends in Computer Science and Engineering","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-08-10","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Efficient Query Processing For Imprecise Data\",\"authors\":\"\",\"doi\":\"10.30534/ijatcse/2022/031142022\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In real world applications we often need to test the queries based on fuzzy data. For example, some one can specify as “find students’ whose age is around 17 years old.”; “find tall person”. “find employee with high salary”; “find country with low population” etc. This fuzziness in measurement is captured in this paper. To test such fuzzy queries, we have developed an algorithm that is applicable universally to any type of database. In this paper first we have designed architecture to test fuzzy query. In the architecture we have defined an algorithm to find the membership value for each tuple of the relation based on the fuzzy attributes on which fuzzy query is made. Next Decision Maker (DM) will supply a threshold value or -cut based on which corresponding SQL of the given fuzzy query will be generated. This SQL will retrieve the resultant tuples from the database. Finally we have tested our algorithm with an example.\",\"PeriodicalId\":129636,\"journal\":{\"name\":\"International Journal of Advanced Trends in Computer Science and Engineering\",\"volume\":\"1 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-08-10\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Journal of Advanced Trends in Computer Science and Engineering\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.30534/ijatcse/2022/031142022\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Journal of Advanced Trends in Computer Science and Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.30534/ijatcse/2022/031142022","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
In real world applications we often need to test the queries based on fuzzy data. For example, some one can specify as “find students’ whose age is around 17 years old.”; “find tall person”. “find employee with high salary”; “find country with low population” etc. This fuzziness in measurement is captured in this paper. To test such fuzzy queries, we have developed an algorithm that is applicable universally to any type of database. In this paper first we have designed architecture to test fuzzy query. In the architecture we have defined an algorithm to find the membership value for each tuple of the relation based on the fuzzy attributes on which fuzzy query is made. Next Decision Maker (DM) will supply a threshold value or -cut based on which corresponding SQL of the given fuzzy query will be generated. This SQL will retrieve the resultant tuples from the database. Finally we have tested our algorithm with an example.