A New Upgrade to SQLf: Towards a Standard in Fuzzy Databases

One remarkable fuzzy set based extension to SQL is SQLf. It allows fuzzy conditions in any place where SQL allows a Boolean one. At present time SQLf development is not up to date with SQL standard. Latest SQLf revision was with the SQL:1999 standard.New features of SQL:2003 standard have not been yet extended to the fuzzy case in SQLf. In this paper, we make a contribution towards a standard in Fuzzy Databases, upgrading SQLf according SQL:2003standard, proposing these new fuzzy features: fuzzy table storage,fuzzy multiset data type and fuzzy merge statement.

[1]  José Galindo,et al.  Fuzzy Databases: Modeling, Design, and Implementation , 2006 .

[2]  R. Yager.  ON THE THEORY OF BAGS , 1986 .

[3]  Hiroshi Nakajima,et al.  Fuzzy database language and library-fuzzy extension to SQL , 1993, [Proceedings 1993] Second IEEE International Conference on Fuzzy Systems.

[4]  Francois Connan.  Interrogation flexible de bases de donnees multimedias , 1999 .

[5]  Jim Melton,et al.  SQL:2003 has been published , 2004, SGMD.

[6]  Zongmin Ma,et al.  Generalization of strategies for fuzzy query translation in classical relational databases , 2007, Inf. Softw. Technol..

[7]  José Galindo,et al.  New characteristics in FSQL, a fuzzy SQL for fuzzy databases , 2005 .

[8]  Gloria Bordogna,et al.  Customizable Flexible Querying in Classical Relational Databases , 2008, Handbook of Research on Fuzzy Information Processing in Databases.

[9]  Grace SauLan Loo,et al.  An Interface to Databases for Flexible Query Answering: A Fuzzy-Set Approach , 2000, DEXA.

[10]  Patrick Bosc,et al.  SQLf Query Functionality on Top of a Regular Relational Database Management System , 2000 .

[11]  Adnan Yazici,et al.  Fuzzy Database Modeling , 1998, J. Database Manag..

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

[13]  Motohide Umano,et al.  Fuzzy relational algebra for possibility-distribution-fuzzy-relational model of fuzzy data , 1994, Journal of Intelligent Information Systems.

[14]  Marlene Goncalves,et al.  SQLf3: an extension of SQLf with SQL3 features , 2001, 10th IEEE International Conference on Fuzzy Systems. (Cat. No.01CH37297).

[15]  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).

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

[17]  Marlene Goncalves,et al.  Derivation Principle in Advanced Fuzzy Queries , 2005, The 14th IEEE International Conference on Fuzzy Systems, 2005. FUZZ '05..