A Server for Fuzzy SQL Queries

The client-server model is being used mostly in the actual DataBase Management Systems (DBMS). However, these DBMS do not allow either to make flexible queries to the database or to store vague information in it. We have developed a FSQL Server for a Fuzzy Relational Database (FRDB). The FSQL language (Fuzzy SQL) is an extension of the SQL language that allows us to write flexible conditions in our queries. This Server has been developed for Oracle, following the model GEFRED, a theoric model for FRDB that includes fuzzy attributes to store vague information in the tables. The FSQL Server allows us to make flexible queries about traditional (crisp) or fuzzy attributes and we can use linguistic labels defined on any attribute.

[1]  L. Zadeh.  Fuzzy sets as a basis for a theory of possibility , 1999 .

[2]  Donald D. Chamberlin,et al.  SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control , 1976, IBM J. Res. Dev..

[3]  Frederick E. Petry,et al.  Extending the fuzzy database with fuzzy numbers , 1984, Inf. Sci..

[4]  José Galindo,et al.  How to Obtain the Fulfilment Degrees of a Query Using Fuzzy Relational Calculus , 2000 .

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

[6]  Henri Prade,et al.  Fuzzy relational databases: Representational issues and reduction using similarity measures , 1987 .

[7]  M. Gupta,et al.  FUZZY INFORMATION AND DECISION PROCESSES , 1981 .

[8]  Patrick Bosc,et al.  Integrating fuzzy queries into an existing database management system: An example , 1994, Int. J. Intell. Syst..

[9]  Donald D. Chamberlin,et al.  SEQUEL: A structured English query language , 1974, SIGFIDET '74.

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

[11]  Claudia Testemale,et al.  Fuzzy relational databases—a key to expert systems , 1986 .

[12]  Abraham Kandel,et al.  Fuzzy relational data bases : a key to expert systems , 1984 .

[13]  Olga Pons,et al.  GEFRED: A Generalized Model of Fuzzy Relational Databases , 1994, Inf. Sci..

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

[15]  B. Buckles,et al.  A fuzzy representation of data for relational databases , 1982 .