Integration of data selection and classification by fuzzy logic

Highlights? We examine flexible data querying of relational databases by fuzzy logic. ? We also examine fuzzy data classification by fuzzy queries. ? It leads to integration of both processes into one entity. ? Access to relational database and database scheme do not have to be modified. A concept of integration of fuzzy data selection and classification by fuzzy Generalized Logical Condition (GLC) is presented in this paper. The GLC that extends SQL queries with fuzzy logic was developed for the purpose of fuzzy data selection. In order to classify data by generating fuzzy queries from fuzzy rules, the extension of the GLC was created. The proposed methodology leads to the integration of data selection and data classification into one entity, while the access to relational databases remains unchanged. The obtained approach was presented on data from the municipal and urban statistical database. Data selection and classification problems can often be described more naturally in terms of natural language rather than by crisp numbers.

[1]  Hamid Behbahani,et al.  Pavement rehabilitation and maintenance prioritization of urban roads using fuzzy logic , 2011, Expert Syst. Appl..

[3]  J. Buckley,et al.  Fuzzy expert systems and fuzzy reasoning , 2004 .

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

[5]  Miroslav Hudec,et al.  An approach to fuzzy database querying, analysis and realization , 2009, Comput. Sci. Inf. Syst..

[6]  Guy De Tré,et al.  An Overview of Fuzzy Approaches to Flexible Database Querying , 2009, Database Technologies: Concepts, Methodologies, Tools, and Applications.

[7]  J. Kacprzyk,et al.  Fquery for Access: Fuzzy Querying for a Windows-Based DBMS , 1995 .

[8]  Ronald R. Yager,et al.  Summary SQL - A Fuzzy Tool For Data Mining , 1997, Intell. Data Anal..

[9]  Omar López-Ortega Java Fuzzy Kit (JFK): A shell to build fuzzy inference systems according to the generalized principle of extension , 2008, Expert Syst. Appl..

[10]  Exploration of applying fuzzy logic for official statistics , 2011 .

[11]  Nikos Papadakis,et al.  A tool for access to relational databases in natural language , 2011, Expert Syst. Appl..

[12]  Janusz Kacprzyk,et al.  Flexible Query Languages for Relational Databases: An Overview , 2006 .

[13]  Cornelia Tudorie Qualifying Objects in Classical Relational Database Querying , 2008, Handbook of Research on Fuzzy Information Processing in Databases.

[14]  George J. Klir,et al.  Fuzzy sets and fuzzy logic - theory and applications , 1995 .

[15]  Andreas Meier,et al.  Concept and Implementation of a Fuzzy Classification Query Language , 2005, DMIN.

[16]  Andreas Meier,et al.  Using a Fuzzy Classification Query Language for Customer Relationship Management , 2005, VLDB.

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

[18]  Miroslav Hudec,et al.  A fuzzy system for municipalities classification , 2004, 7th Seminar on Neural Network Applications in Electrical Engineering, 2004. NEUREL 2004. 2004.

[19]  Slawomir Zadrozny,et al.  Fuzzy querying: issues and perspectives , 2000, Kybernetika.

[20]  Chun-Ming Chen,et al.  INTELLIGENT QUERIES BASED ON FUZZY SET THEORY AND SQL , 2007 .