Fuzzy query translation for relational database systems

The paper presents a new method for fuzzy query translation based on the alpha-cuts operations of fuzzy numbers. This proposed method allows the retrieval conditions of SQL queries to be described by fuzzy terms represented by fuzzy numbers. It emphasizes friendliness and flexibility for inexperienced users. The authors have implemented a fuzzy query translator to translate user's fuzzy queries into precise queries for relational database systems. Because the proposed method allows the user to construct his fuzzy queries intuitively and to choose different retrieval threshold values for fuzzy query translation, the existing relational database systems will be more friendly and more flexible to the users.

[1]  Madan M. Gupta,et al.  Fuzzy mathematical models in engineering and management science , 1988 .

[2]  Ronald R. Yager,et al.  Essentials of fuzzy modeling and control , 1994 .

[3]  H. Zimmermann,et al.  Fuzzy Set Theory and Its Applications , 1993 .

[4]  Yoshikane Takahashi A fuzzy query language for relational databases , 1991, IEEE Trans. Syst. Man Cybern..

[5]  Hans-Jürgen Zimmermann,et al.  Fuzzy Set Theory - and Its Applications , 1985 .

[6]  Jyh-Sheng Ke,et al.  Database Skeleton and Its Application to Fuzzy Query Translation , 1978, IEEE Trans. Software Eng..

[7]  Abraham Kandel,et al.  Implementing Imprecision in Information Systems , 1985, Inf. Sci..

[8]  Lotfi A. Zadeh,et al.  Fuzzy Sets , 1996, Inf. Control..

[9]  Bill P. Buckles,et al.  Information-theoretical characterization of fuzzy relational databases , 1983, IEEE Transactions on Systems, Man, and Cybernetics.

[10]  Shyi-Ming Chen,et al.  Document retrieval using knowledge-based fuzzy information retrieval techniques , 1995, IEEE Trans. Syst. Man Cybern..

[11]  Dario Lucarella,et al.  FIRST: Fuzzy Information Retrieval SysTem , 1991, J. Inf. Sci..

[12]  Shi-Kuo Chang,et al.  Translation of Fuzzy Queries for Relational Database System , 1979, IEEE Transactions on Pattern Analysis and Machine Intelligence.

[13]  Lotfi A. Zadeh,et al.  The Concepts of a Linguistic Variable and its Application to Approximate Reasoning , 1975 .

[14]  Mohamed A. Ismail,et al.  Fuzzy query processing using clustering techniques , 1990, Inf. Process. Manag..