Similarity of Query Results in Similarity-Based Databases

  • Radim Belohlavek
  • Lucie Urbanova
  • Vilem Vychodil
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6954)


We study estimations of similarity of query results in a similarity-based database model. The model results as extension of Codd’s model of data in which domains are additionally equipped with similarity relations and tuples in data tables have ranks indicating degrees to which tuples match similarity-based queries. We present ranked-based and tuple-based similarity of data tables, similarity closures, prove that relational operations in our model preserve similarity, and provide formulas for estimating similarity of query results based on similarity of input data. Most of the proofs are only sketched or omitted because of the limited scope of the paper.


queries ranks relational databases residuated lattices similarity closures similarities over domains 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Abiteboul, S., et al.: The Lowell database research self-assessment. Communications of the ACM 48(5), 111–118 (2005)CrossRefGoogle Scholar
  2. 2.
    Belohlavek, R.: Fuzzy closure operators. Journal of Mathematical Analysis and Appl. 262, 473–489 (2001)MathSciNetCrossRefzbMATHGoogle Scholar
  3. 3.
    Belohlavek, R.: Fuzzy Relational Systems: Foundations and Principles. Kluwer, Academic/Plenum Publishers, New York (2002)CrossRefzbMATHGoogle Scholar
  4. 4.
    Belohlavek, R.: Fuzzy closure operators induced by similarity. Fundamenta Informaticae 58(2), 79–91 (2003)MathSciNetzbMATHGoogle Scholar
  5. 5.
    Belohlavek, R., Vychodil, V.: Logical foundations for similarity-based databases. In: Chen, L., Liu, C., Liu, Q., Deng, K. (eds.) DASFAA 2009. LNCS, vol. 5667, pp. 137–151. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  6. 6.
    Belohlavek, R., Vychodil, V.: Query systems in similarity-based databases: logical foundations, expressive power, and completeness. In: ACM SAC 2010, pp. 1648–1655 (2010)Google Scholar
  7. 7.
    Belohlavek, R., Vychodil, V.: Codd’s relational model from the point of view of fuzzy logic. J. Logic and Computation (to appear), doi:10.1093/logcom/exp056 Google Scholar
  8. 8.
    Buckles, B.: P., Petry F.E.: Fuzzy databases in the new era. In: ACM SAC 1995, Nashville, TN, pp. 497–502 (1995)Google Scholar
  9. 9.
    Codd, E.F.: A relational model of data for large shared data banks. Communications of the ACM 13(6), 377–387 (1970)CrossRefzbMATHGoogle Scholar
  10. 10.
    Fagin, R.: Combining fuzzy information: an overview. ACM SIGMOD Record 31(2), 109–118 (2002)CrossRefGoogle Scholar
  11. 11.
    Gottwald, S.: A Treatise on Many-Valued Logics. Research Studies Press, Beldock (2001)zbMATHGoogle Scholar
  12. 12.
    Gottwald, S.: Mathematical fuzzy logics. Bull. Symbolic Logic 14(2), 210–239 (2008)MathSciNetCrossRefzbMATHGoogle Scholar
  13. 13.
    Hájek, P.: Metamathematics of Fuzzy Logic. Kluwer, Dordrecht (1998)CrossRefzbMATHGoogle Scholar
  14. 14.
    Hájek, P.: On very true. Fuzzy Sets and Syst. 124, 329–333 (2001)MathSciNetCrossRefzbMATHGoogle Scholar
  15. 15.
    Klawonn, F., Castro, J.L.: Similarity in fuzzy reasoning. Mathware & Soft Computing 2, 197–228 (1995)MathSciNetzbMATHGoogle Scholar
  16. 16.
    Li, C., Chang, K.C.-C., Ilyas I.F., Song, S.: RankSQL: Query Algebra and Optimization for Relational top-k queries. In: ACM SIGMOD 2005, pp. 131–142 (2005)Google Scholar
  17. 17.
    Maier, D.: The Theory of Relational Databases. Comp. Sci. Press, Rockville (1983)zbMATHGoogle Scholar
  18. 18.
    Prade, H., Testemale, C.: Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries. Inf. Sci. 34, 115–143 (1984)MathSciNetCrossRefzbMATHGoogle Scholar
  19. 19.
    Raju, K.V.S.V.N., Majumdar, A.K.: Fuzzy functional dependencies and lossless join decomposition of fuzzy relational database systems. ACM Trans. Database Systems 13(2), 129–166 (1988)Google Scholar
  20. 20.
    Takahashi, Y.: Fuzzy database query languages and their relational completeness theorem. IEEE Trans. Knowledge and Data Engineering 5, 122–125 (1993)CrossRefGoogle Scholar
  21. 21.
    Shenoi, S., Melton, A.: Proximity relations in the fuzzy relational database model. Fuzzy Sets and Syst. 100, 51–62 (1999)CrossRefzbMATHGoogle Scholar
  22. 22.
    Valverde, L.: On the structure of F-indistinguishability operators. Fuzzy Sets and Systems 17, 313–328 (1985)MathSciNetCrossRefzbMATHGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Radim Belohlavek
    • 1
  • Lucie Urbanova
    • 1
  • Vilem Vychodil
    • 1
  1. 1.DAMOL (Data Analysis and Modeling Laboratory), Dept. Computer SciencePalacky UniversityOlomoucCzech Republic

Personalised recommendations