Generalization of strategies for fuzzy query translation in classical relational databases |
| |
| Affiliation: | 1. DESP – Department of Economics, Society and Political Sciences, University of Urbino, Italy;2. Department of Mathematics, DigiPen Institute of Technology, Redmond, WA, USA;1. Department of Mathematics, University of Cádiz, Spain;2. Research Unit Computational Logic, Vienna University of Technology, Wien, Austria;1. College of Mathematics and Computer Science, Hebei University, Baoding 071002, Hebei Province, PR China;2. School of Economics and Management, Hebei University of Engineering, Handan 056038, Hebei Province, PR China;3. College of Physics Sciences of Technology, Hebei University, Baoding 071002, Hebei Province, PR China |
| |
| Abstract: | Users of information systems would like to express flexible queries over the data possibly retrieving imperfect items when the perfect ones, which exactly match the selection conditions, are not available. Most commercial DBMSs are still based on the SQL for querying. Therefore, providing some flexibility to SQL can help users to improve their interaction with the systems without requiring them to learn a completely novel language. Based on the fuzzy set theory and the α-cut operation of fuzzy number, this paper presents the generic fuzzy queries against classical relational databases and develops the translation of the fuzzy queries. The generic fuzzy queries mean that the query condition consists of complex fuzzy terms as the operands and complex fuzzy relations as the operators in a fuzzy query. With different thresholds that the user chooses for the fuzzy query, the user’s fuzzy queries can be translated into precise queries for classical relational databases. |
| |
| Keywords: | |
| 本文献已被 ScienceDirect 等数据库收录！ |
|
