Declarative Fuzzy Linguistic Queries on Relational Databases

  • Clemente Rubio-Manzano
  • Pascual Julián-Iranzo
  • Esteban Salazar-Santis
  • Eduardo San Martín-Villarroel
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8132)


In this paper we propose a declarative method to formulate fuzzy linguistic queries on Relational Database Management Systems. That is, flexible queries containing linguistic terms associate to the attributes of a table of a relational database. To this end, we adapt techniques originate from a proximity-based Logic Programming Language called Bousi~Prolog.


Relational databases Information retrieval Fuzzy Linguistic Queries Proximity/Similarity Relations Fuzzy Logic Programming 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bosc, P., Pivert, O.: SQLf: a relational database language for fuzzy querying. IEEE T. Fuzzy Syst. 3(1), 1–17 (1995)MathSciNetCrossRefGoogle Scholar
  2. 2.
    Balamurugan, V., Kannan, K.S.: A Framework for Computing Linguistic Hedges in Fuzzy Queries. The Int. J. of Database Management Systems 2(1) (2010)Google Scholar
  3. 3.
    Buckles, B., Petry, F.: A fuzzy model for relational databases. Fuzzy Sets and Syst. 7, 213–226 (1985)CrossRefGoogle Scholar
  4. 4.
    Chen, S.M., Hsiao, H.R.: A New Approach for Fuzzy Query Processing Based on Automatic Clustering Techniques. Information and Management Sciences 18(3), 223–240 (2007)zbMATHGoogle Scholar
  5. 5.
    Codd, E.F.: A Relational Model of Data for Large Shared Data Banks. Communications of the ACM 13(6), 377–387 (1970)zbMATHCrossRefGoogle Scholar
  6. 6.
    Julián-Iranzo, P., Rubio-Manzano, C.: A similarity-based WAM for bousi~Prolog. In: Cabestany, J., Sandoval, F., Prieto, A., Corchado, J.M. (eds.) IWANN 2009, Part I. LNCS, vol. 5517, pp. 245–252. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  7. 7.
    Julián, P., Rubio, C.: An Efficient Fuzzy Unification Method and its Implementation into the Bousi~Prolog System. In: FUZZ-IEEE 2010, pp. 658–665 (2010)Google Scholar
  8. 8.
    Julián, P., Rubio, C., Gallardo, J.: Bousi~Prolog: a Prolog Extension Language for Flexible Query Answering. Electronic Notes in Theoretical Computer Science 248, 131–147 (2009)CrossRefGoogle Scholar
  9. 9.
    Kamel, M., et al.: Fuzzy Query using Clustering techniques. Information Processing and Management 26(2), 279–293 (1990)CrossRefGoogle Scholar
  10. 10.
    Lee, R.C.T.: Fuzzy Logic and the Resolution Principle. Journal of the ACM 19(1), 119–129 (1972)CrossRefGoogle Scholar
  11. 11.
    Lloyd, J.W.: Foundations of Logic Programming. Springer, Berlin (1987)zbMATHCrossRefGoogle Scholar
  12. 12.
    Orchard, R.A.: FuzzyClips Version 6.04A. User’s Guide. Integrated Reasoning. Institute for Information Technology. Canada (1998)Google Scholar
  13. 13.
    Prade, H., Testemale, C.: Generalizing database relational algebra for the treatment of incomplete/uncertain information and vague queries. Information Science 34, 115–143 (1984)MathSciNetzbMATHCrossRefGoogle Scholar
  14. 14.
    Rios-Filho, L.G., Sandri, S.A.: Contextual Fuzzy Unification. In: Proc. of IFSA 1995, pp. 81–84 (1995)Google Scholar
  15. 15.
    Sessa, M.I.: Approximate reasoning by similarity-based SLD resolution. Theoretical Computer Science 275(1-2), 389–426 (2002)MathSciNetzbMATHCrossRefGoogle Scholar
  16. 16.
    Shenoi, S., Melton, A.: Proximity relations in the fuzzy relational database model. Fuzzy Sets and Systems 100, 51–62 (1999)CrossRefGoogle Scholar
  17. 17.
    Tahami, V.: A conceptual framework for fuzzy query processing - a step toward very intelligent databases systems. Information Processing and Management 13, 289–303 (1977)CrossRefGoogle Scholar
  18. 18.
    Takahashi, Y.: A fuzzy query language for relational databases. In: Kacprzyk, J., Bosc, P. (eds.) Fuzziness in Database Management Systems. Physica-Verlag, Berlin (1995)Google Scholar
  19. 19.
    Zadeh, L.A.: Fuzzy Sets. Information and Control 8(3), 338–353 (1965)MathSciNetzbMATHCrossRefGoogle Scholar
  20. 20.
    Zadeh, L.A.: The Concept of a Linguistic Variable and its Applications to Approximate Reasoning I, II and III. J. of Information Sciences 8 & 9 (1975)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Clemente Rubio-Manzano
    • 1
  • Pascual Julián-Iranzo
    • 2
  • Esteban Salazar-Santis
    • 1
  • Eduardo San Martín-Villarroel
    • 1
  1. 1.Dep. of Information SystemsUniv. of the Bío-BíoChile
  2. 2.Dep. of Information Technologies and SystemsUniv. of Castilla-La ManchaSpain

Personalised recommendations