Skip to main content
SpringerLink
Log in

A New Approach for Fuzzy Classification in Relational Databases

  • Conference paper
Database and Expert Systems Applications (DEXA 2011)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 6861))

Included in the following conference series:

  • 1245 Accesses

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13, 377–387 (1970)

    Article  MATH  Google Scholar 

  2. Galindo, J.: Fuzzy Databases: Modeling. IGI Publishing (2006)

    Google Scholar 

  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. 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)

    Chapter  Google Scholar 

  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)

    Chapter  Google Scholar 

  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)

    Chapter  Google Scholar 

  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)

    Chapter  Google Scholar 

  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)

    Chapter  Google Scholar 

  9. Veryha, Y.: Implementation of fuzzy classification in relational databases using conventional SQL querying. Information and Software Technology 47, 357–364 (2005)

    Article  Google Scholar 

  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)

    Chapter  Google Scholar 

  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. Zadeh, L.A.: Fuzzy Sets. Information and Control 8, 338–353 (1965)

    Article  MathSciNet  MATH  Google Scholar 

  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. 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 

Download references

Author information

Authors and Affiliations

  1. Department of Communication, School of Electrical and Computer Engineering, University of Campinas, Cidade Universitária Zeferino Vaz, Campinas, SP, Brazil

    Ricardo Hideyuki Tajiri, Eduardo Zanoni Marques, Bruno Bogaz Zarpelão & Leonardo de Souza Mendes

Authors
  1. Ricardo Hideyuki Tajiri
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Eduardo Zanoni Marques
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Bruno Bogaz Zarpelão
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Leonardo de Souza Mendes
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. IRIT Institut de Recherche en Informatique de Toulouse, Paul Sabatier University, 118, route de Narbonne, 31062, Toulouse Cedex, France

    Abdelkader Hameurlain

  2. Brigham Young University, 784 TNRB, 84602, Provo, UT, USA

    Stephen W. Liddle

  3. Software Competence Center Hagenberg and Johannes-Keppler-University Linz, Softwarepark 21, 4232, Hagenberg, Austria

    Klaus-Dieter Schewe

  4. School of Information Technology and Electrical Engineering, University of Queensland, QLD 4072, Brisbane, Australia

    Xiaofang Zhou

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Tajiri, R.H., Marques, E.Z., Zarpelão, B.B., de Souza Mendes, L. (2011). A New Approach for Fuzzy Classification in Relational Databases. In: Hameurlain, A., Liddle, S.W., Schewe, KD., Zhou, X. (eds) Database and Expert Systems Applications. DEXA 2011. Lecture Notes in Computer Science, vol 6861. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-23091-2_45

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-23091-2_45

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-23090-5

  • Online ISBN: 978-3-642-23091-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation