Skip to main content

Ranking Database Queries with User Feedback: A Neural Network Approach

  • Conference paper
Database Systems for Advanced Applications (DASFAA 2008)

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

Included in the following conference series:

  • 1017 Accesses

Abstract

Currently, websites on the Internet serving structured data allow users to perform search based on simple equality or range constraints on data attributes. However, to begin with, users may not know what is desirable to them precisely, to be able to express it accurately in terms of primitive equality or range constraints. Additionally, in most websites, the results provided to users can be sorted with respect to values of any one particular attribute at a time. For the user, this is like searching for a needle in a haystack because the user’s notion of interesting objects is generally a function of multiple attributes.

In this paper, we develop an approach to (i) support a family of functions involving multiple attributes to rank the tuples, and (ii) improve the ranking of results returned to the user by incorporating user feedback (to learn user’s notion of interestingness) with the help of a neural network. The user feedback driven approach is effective in modeling a user’s intuitive sense of desirability of a tuple, a notion that is otherwise near impossible to quantify mathematically. To prove the effectiveness of our approach, we have built a middleware for an application domain that implements and evaluates these ideas.

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

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Li, C., Chang, K.C.-C., Ilyas, I., Song, S.: RankSQL: Query Algebra and Optimization for Relational Top-k Queries. In: Proc. of the ACM SIGMOD Conference, Baltimore, Maryland, USA (2005)

    Google Scholar 

  2. Bruno, N., Chaudhuri, S., Gravano, L.: Top-k selection queries over relational databases: Mapping strategies and performance evaluation. ACM Transactions on Database Systems(TODS) 27(2) (2002)

    Google Scholar 

  3. Fagin, R.: Combining fuzzy information from multiple systems. In: Proc. of the 15th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS), Montreal, Canada (1996)

    Google Scholar 

  4. Agrawal, R., Wimmers, E.L.: A framework for expressing and combining preferences. In: Proc. of the ACM SIGMOD Conference, Dallas, Texas, USA (2000)

    Google Scholar 

  5. Re, C., Dalvi, N., Suciu, D.: Efficient Top-k Query Evaluation on Probabilistic Data. In: Proc. of the 23rd International Conference on Data Engineering (ICDE) (2007)

    Google Scholar 

  6. Tao, T., Zhai, C.: Best-k Queries on Database Systems. In: Proc. of the 15th ACM Conference on Information and Knowledge Management (CIKM) (2006)

    Google Scholar 

  7. Agrawal, S., Chaudhuri, S., Das, G., Gionis, A.: Automated Ranking of Database Query Results. In: Proc. of First Biennial Conference on Innovative Data Systems Research (CIDR), Asilomar, California, USA (2003)

    Google Scholar 

  8. Haykin, S.: Neural Networks: A Comprehensive Foundation, 2nd edn. Prentice-Hall, Englewood Cliffs (1998)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Jayant R. Haritsa Ramamohanarao Kotagiri Vikram Pudi

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Agarwal, G., Mallick, N., Turuvekere, S., Zhai, C. (2008). Ranking Database Queries with User Feedback: A Neural Network Approach. In: Haritsa, J.R., Kotagiri, R., Pudi, V. (eds) Database Systems for Advanced Applications. DASFAA 2008. Lecture Notes in Computer Science, vol 4947. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-78568-2_31

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-78568-2_31

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-78567-5

  • Online ISBN: 978-3-540-78568-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics