Fuzzy query translation for relational database systems

Author

Chen, Shyi-Ming ; Jong, Woei-Tzy

Author_Institution

Dept. of Comput. & Inf. Sci., Nat. Chiao Tung Univ., Hsinchu, Taiwan

Volume

27

Issue

4

fYear

1997

fDate

8/1/1997 12:00:00 AM

Firstpage

714

Lastpage

721

Abstract

The paper presents a new method for fuzzy query translation based on the α-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

Keywords

database theory; fuzzy set theory; query processing; relational databases; α-cuts operations; SQL queries; fuzzy numbers; fuzzy query translation; fuzzy terms; precise queries; relational database systems; retrieval conditions; retrieval threshold values; Deductive databases; Fuzzy logic; Fuzzy set theory; Fuzzy sets; Fuzzy systems; Information retrieval; Information systems; Intelligent systems; Query processing; Relational databases;

fLanguage

English

Journal_Title

Systems, Man, and Cybernetics, Part B: Cybernetics, IEEE Transactions on

Publisher

ieee

ISSN

1083-4419

Type

jour

DOI

10.1109/3477.604117

Filename

604117