A New Approach for Fuzzy Classification in Relational Databases

  • Ricardo Hideyuki Tajiri
  • Eduardo Zanoni Marques
  • Bruno Bogaz Zarpelão
  • Leonardo de Souza Mendes
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6861)


This paper presents an easy-to-use and easy-to-implement framework for fuzzy data classification and extraction in relational databases. The main benefits of the framework are: (i) a fuzzy data classification model for relational databases; (ii) flexible membership function configuration; (iii) automatic membership degree computation; (iv) a fuzzy data retrieval mechanism fully supported in SQL queries. In order to validate the proposed framework, a case study is implemented in a social welfare system using RDBMS Oracle 11g and PL/SQL programming language.


Fuzzy classification Relational database SQL query 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13, 377–387 (1970)CrossRefzbMATHGoogle Scholar
  2. 2.
    Galindo, J.: Fuzzy Databases: Modeling. IGI Publishing (2006)Google Scholar
  3. 3.
    Chamberlin, D.D., Boyce, R.F.: SEQUEL: A structured English query language. In: Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control, pp. 249–264. ACM, Ann Arbor (1974)Google Scholar
  4. 4.
    Bordogna, G., Psaila, G.: Customizable Flexible Querying in Classical Relational Databases. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, pp. 191–217. Information Science Reference, Hershey (2008)CrossRefGoogle Scholar
  5. 5.
    Rosado, A., Ribeiro, R., Zadrozny, S., Kacprzyk, J.: Flexible Query Languages for Relational Databases: An Overview. In: Bordogna, G., Psaila, G. (eds.) Flexible Databases Supporting Imprecision and Uncertainty, vol. 203, pp. 3–53. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  6. 6.
    Zadrozny, S., Tré, G.d., Caluwe, R.d., Kacprzyk, J.: An Overview of Fuzzy Approaches to Flexible Database Querying. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, vol. I, pp. 34–54. Information Science Reference, Hershey (2008)CrossRefGoogle Scholar
  7. 7.
    Galindo, J., Medina, J.M., Pons, O., Cubero, J.C.: A Server for Fuzzy SQL Queries. In: Andreasen, T., Christiansen, H., Larsen, H.L. (eds.) FQAS 1998. LNCS (LNAI), vol. 1495, pp. 164–174. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  8. 8.
    Zadrozny, S., Kacprzyk, J.: FQUERY for Access: towards human consistent querying user interface. In: Proceedings of the 1996 ACM Symposium on Applied Computing, pp. 532–536. ACM, Philadelphia (1996)CrossRefGoogle Scholar
  9. 9.
    Veryha, Y.: Implementation of fuzzy classification in relational databases using conventional SQL querying. Information and Software Technology 47, 357–364 (2005)CrossRefGoogle Scholar
  10. 10.
    Veryha, Y., Blot, J.-Y., Coelho, J.: Fuzzy Classification in Shipwreck Scatter Analysis. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, vol. II, pp. 516–537. Information Science Reference, Hershey (2008)CrossRefGoogle Scholar
  11. 11.
    Meier, A., Werro, N., Albrecht, M., Sarakinos, M.: Using a fuzzy classification query language for customer relationship management. In: Proceedings of the 31st International Conference on Very Large Data Bases, pp. 1089–1096. VLDB Endowment, Trondheim (2005)Google Scholar
  12. 12.
    Zadeh, L.A.: Fuzzy Sets. Information and Control 8, 338–353 (1965)MathSciNetCrossRefzbMATHGoogle Scholar
  13. 13.
    Barros, R.P.D., Carvalho, M.D., Franco, S.: O Índice de Desenvolvimento da Família (IDF). In: Aplicada, I.D.P.E. (ed.) Instituto de Pesquisa Econômica Aplicada, Rio de Janeiro (2003)Google Scholar
  14. 14.
    Tilli, M., Panhan, A.M., Lima, O., Mendes, L.S.: A Web-Based Architecture For E-Gov Application Development. In: ICE-B - International Conference on e-Business, Porto – Portugal (2008)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Ricardo Hideyuki Tajiri
    • 1
  • Eduardo Zanoni Marques
    • 1
  • Bruno Bogaz Zarpelão
    • 1
  • Leonardo de Souza Mendes
    • 1
  1. 1.Department of Communication, School of Electrical and Computer EngineeringUniversity of Campinas, Cidade Universitária Zeferino VazCampinasBrazil

Personalised recommendations