Skip to main content

Finding Similar Objects in Relational Databases — An Association-Based Fuzzy Approach

  • Conference paper
Flexible Query Answering Systems (FQAS 2013)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 8132))

Included in the following conference series:

Abstract

This paper deals with the issue of extending the scope of a user query in order to retrieve objects which are similar to its “strict answers”. The approach proposed exploits associations between database items, corresponding, e.g., to the presence of foreign keys in the database schema. Fuzzy concepts such as typicality, similarity and linguistic quantifiers are at the heart of the approach and make it possible to obtain a ranked list of similar answers.

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

Access this chapter

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. Agrawal, S., Chaudhuri, S., Das, G.: DBXplorer: A system for keyword-based search over relational databases. In: Proc. of ICDE 2002, pp. 5–16 (2002)

    Google Scholar 

  2. Andreasen, T., Bulskov, H.: Query expansion by taxonomy. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, pp. 325–349. Information Science Reference, Hershey (2008)

    Chapter  Google Scholar 

  3. Bhalotia, G., Hulgeri, A., Nakhe, C., Chakrabarti, S., Sudarshan, S.: Keyword searching and browsing in databases using BANKS. In: Proc. of ICDE 2002, pp. 431–440 (2002)

    Google Scholar 

  4. Bosc, P., Pivert, O.: On the comparison of imprecise values in fuzzy databases. In: Proc. of the 6th IEEE International Conference on Fuzzy Systems (FUZZ-IEEE 1997), Barcelona, Spain, pp. 707–712 (1997)

    Google Scholar 

  5. Bouchon-Meunier, B., Coletti, G., Lesot, M.-J., Rifqi, M.: Towards a conscious choice of a fuzzy similarity measure: A qualitative point of view. In: Hüllermeier, E., Kruse, R., Hoffmann, F. (eds.) IPMU 2010. LNCS, vol. 6178, pp. 1–10. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  6. Chakrabarti, K., Ganti, V., Han, J., Xin, D.: Ranking objects based on relationships. In: Proc. of SIGMOD 2006, pp. 371–382 (2006)

    Google Scholar 

  7. Dubois, D., Prade, H.: Weighted minimum and maximum operations in fuzzy set theory. Information Sciences 39, 205–210 (1986)

    Article  MathSciNet  MATH  Google Scholar 

  8. Dubois, D., Prade, H.: On data summarization with fuzzy sets. In: Proc. of IFSA 1993, pp. 465–468 (1993)

    Google Scholar 

  9. Gaasterland, T.: Relaxation as a platform for cooperative answering. Journal of Intelligent Information Systems 1(3-4), 296–321 (1992)

    Article  Google Scholar 

  10. Hristidis, V., Papakonstantinou, Y.: DISCOVER: Keyword search in relational databases. In: Proc. of VLDB 2002, pp. 670–681 (2002)

    Google Scholar 

  11. Koutrika, G., Bercovitz, B., Garcia-Molina, H.: Flexrecs: expressing and combining flexible recommendations. In: Proc. of SIGMOD 2009, pp. 745–758 (2009)

    Google Scholar 

  12. Pappis, C., Karacapilidis, N.: A comparative assessment of measures of similarity of fuzzy values. Fuzzy Sets and Systems (1993)

    Google Scholar 

  13. Stefanidis, K., Drosou, M., Pitoura, E.: You may also like” results in relational databases. In: Proc. of PersDB 2009 (2009)

    Google Scholar 

  14. Sun, Y., Han, J., Yan, X., Yu, P.S., Wu, T.: Pathsim: Meta path-based top-k similarity search in heterogeneous information networks. PVLDB 4(11), 992–1003 (2011)

    Google Scholar 

  15. Yager, R.: General multiple-objective decision functions and linguistically quantified statements. International Journal of Man-Machine Studies 21(5), 389–400 (1984)

    Article  MATH  Google Scholar 

  16. Yager, R.: Interpreting linguistically quantified propositions. International Journal of Intelligent Systems 9(6), 541–569 (1994)

    Article  MathSciNet  MATH  Google Scholar 

  17. Zadeh, L.: A computational approach to fuzzy quantifiers in natural languages. Computing and Mathematics with Applications 9, 149–183 (1983)

    Article  MathSciNet  MATH  Google Scholar 

  18. Zadeh, L.: A computational theory of dispositions. International Journal of Intelligent Systems 2, 39–63 (1987)

    MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pivert, O., Smits, G., Jaudoin, H. (2013). Finding Similar Objects in Relational Databases — An Association-Based Fuzzy Approach. In: Larsen, H.L., Martin-Bautista, M.J., Vila, M.A., Andreasen, T., Christiansen, H. (eds) Flexible Query Answering Systems. FQAS 2013. Lecture Notes in Computer Science(), vol 8132. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-40769-7_37

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-40769-7_37

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-40768-0

  • Online ISBN: 978-3-642-40769-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics