{"title":"模糊查询技术在蒙药处方数据分析中的应用","authors":"Lin Qingming, Lan Zhanjiang, Z. Chunsheng","doi":"10.1109/ICSESS54813.2022.9930234","DOIUrl":null,"url":null,"abstract":"Standard SQL statements can only perform exact information queries and do not meet the needs of the real world. Constructing query statement with fuzzy function based on fuzzy mathematics theory has certain application value. Define the fuzzy query statement format first, and then build the fuzzy knowledge table and data dictionary. Finally, a general fuzzy query parser is constructed based on fuzzy theory. Fuzzy Query Parser converts a fuzzy query statement into a standard SQL query statement to achieve a true fuzzy query and adapt to the needs of flexible queries. The validity of the Fuzzy Query Parser is verified by a simple case and the technology is applied to the data query of Mongolian medicine prescriptions. Universal fuzzy query technology can achieve user’s fuzzy query requirements and can be converted to standard SQL statements. It provides a new way for data query and data analysis and has certain application value.","PeriodicalId":265412,"journal":{"name":"2022 IEEE 13th International Conference on Software Engineering and Service Science (ICSESS)","volume":"107 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-10-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Application of Fuzzy Query Technology in Data Analysis of Mongolian Medicine Prescriptions\",\"authors\":\"Lin Qingming, Lan Zhanjiang, Z. Chunsheng\",\"doi\":\"10.1109/ICSESS54813.2022.9930234\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Standard SQL statements can only perform exact information queries and do not meet the needs of the real world. Constructing query statement with fuzzy function based on fuzzy mathematics theory has certain application value. Define the fuzzy query statement format first, and then build the fuzzy knowledge table and data dictionary. Finally, a general fuzzy query parser is constructed based on fuzzy theory. Fuzzy Query Parser converts a fuzzy query statement into a standard SQL query statement to achieve a true fuzzy query and adapt to the needs of flexible queries. The validity of the Fuzzy Query Parser is verified by a simple case and the technology is applied to the data query of Mongolian medicine prescriptions. Universal fuzzy query technology can achieve user’s fuzzy query requirements and can be converted to standard SQL statements. It provides a new way for data query and data analysis and has certain application value.\",\"PeriodicalId\":265412,\"journal\":{\"name\":\"2022 IEEE 13th International Conference on Software Engineering and Service Science (ICSESS)\",\"volume\":\"107 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-10-21\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2022 IEEE 13th International Conference on Software Engineering and Service Science (ICSESS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICSESS54813.2022.9930234\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 IEEE 13th International Conference on Software Engineering and Service Science (ICSESS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICSESS54813.2022.9930234","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Application of Fuzzy Query Technology in Data Analysis of Mongolian Medicine Prescriptions
Standard SQL statements can only perform exact information queries and do not meet the needs of the real world. Constructing query statement with fuzzy function based on fuzzy mathematics theory has certain application value. Define the fuzzy query statement format first, and then build the fuzzy knowledge table and data dictionary. Finally, a general fuzzy query parser is constructed based on fuzzy theory. Fuzzy Query Parser converts a fuzzy query statement into a standard SQL query statement to achieve a true fuzzy query and adapt to the needs of flexible queries. The validity of the Fuzzy Query Parser is verified by a simple case and the technology is applied to the data query of Mongolian medicine prescriptions. Universal fuzzy query technology can achieve user’s fuzzy query requirements and can be converted to standard SQL statements. It provides a new way for data query and data analysis and has certain application value.