Fuzzy query interface for a business database

Managers, in today's corporations, rely increasingly on the use of databases to obtain insights and updated information to make their decisions. This paper describes a flexible query interface based on fuzzy logic. Hence, queries in natural language with pre-defined syntactical structures are performed, and the system uses a fuzzy natural language process to provide answers. This process uses the fuzzy translation rules of the meaning representation language PRUF, proposed by Zadeh (Intern. J. Man-Machine Studies 10 (1978) 395). The interface was built for a relational database of the 500 biggest non-financial Portuguese companies. The attributes considered are the economic and financial indicators. Examples of pseudonatural language queries, such as "is company X very profitable?" or "are most private companies productive?", are presented to show the capabilities of this human-oriented interface.

[1]  Patrick Bosc,et al.  Aggregate operators in database flexible querying , 2001, 10th IEEE International Conference on Fuzzy Systems. (Cat. No.01CH37297).

[2]  Lotfi A. Zadeh,et al.  Test-score semantics as a basis for a computational approach to the representation of meaning , 1986 .

[3]  Patrick Bosc,et al.  Fuzzy queries against regular and fuzzy databases , 1997 .

[4]  Janusz Kacprzyk,et al.  Management decision support systems using fuzzy sets and possibility theory , 1985 .

[5]  R. Yager.  Connectives and quantifiers in fuzzy sets , 1991 .

[6]  Trevor P Martin,et al.  Fril- Fuzzy and Evidential Reasoning in Artificial Intelligence , 1995 .

[7]  Didier Dubois,et al.  Using fuzzy sets in flexible querying: why and how? , 1997 .

[8]  Ronald R. Yager,et al.  Interpreting linguistically quantified propositions , 1994, Int. J. Intell. Syst..

[9]  L. Zadeh,et al.  Fuzzy sets and applications : selected papers , 1987 .

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

[11]  B. Reusch,et al.  Computational intelligence in theory and practice , 2001 .

[12]  Stephen Cole Kleene,et al.  On notation for ordinal numbers , 1938, Journal of Symbolic Logic.

[13]  Marlene Goncalves,et al.  SQLf flexible querying language extension by means of the norm SQL2 , 2001, 10th IEEE International Conference on Fuzzy Systems. (Cat. No.01CH37297).

[14]  Patrick Bosc,et al.  SQLf: a relational database language for fuzzy querying , 1995, IEEE Trans. Fuzzy Syst..

[15]  L. Zadeh.  A Fuzzy-Set-Theoretic Interpretation of Linguistic Hedges , 1972 .

[16]  Efraim Turban,et al.  Decision support and expert systems , 1993 .

[17]  Lotfi A. Zadeh,et al.  PRUF—a meaning representation language for natural languages , 1978 .

[18]  Henri Prade,et al.  Generalizing Database Relational Algebra for the Treatment of Incomplete/Uncertain Information and Vague Queries , 1984, Inf. Sci..

[19]  Patrick Bosc,et al.  On the comparison of aggregates over fuzzy sets , 2003 .

[20]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[21]  Y. Takahashi.  A fuzzy query language for relational databases , 1991 .

[22]  Bernadette Bouchon-Meunier,et al.  IPMU '92 : advanced methods in artificial intelligence : 4th International Conference on Information Processing and Management of Uncertainty in Knowledge-Based Systems, Palma de Mallorca, Spain, July 6-10, 1992 : proceedings , 1993 .

[23]  T. Ross.  Fuzzy Logic with Engineering Applications , 1994 .

[24]  Ronald R. Yager.  Quantifiers in the formulation of multiple objective decision functions , 1983, Inf. Sci..

[25]  Janusz Kacprzyk,et al.  Database Queries with Fuzzy Linguistic Quantifiers , 1986, IEEE Transactions on Systems, Man, and Cybernetics.

[26]  Valiollah Tahani,et al.  A conceptual framework for fuzzy query processing - A step toward very intelligent database systems , 1977, Inf. Process. Manag..

[27]  L. Zadeh.  A COMPUTATIONAL APPROACH TO FUZZY QUANTIFIERS IN NATURAL LANGUAGES , 1983 .