skip to main content
research-article

SQL QueRIE recommendations

Published:01 September 2010Publication History
Skip Abstract Section

Abstract

This demonstration presents QueRIE, a recommender system that supports interactive database exploration. This system aims at assisting non-expert users of scientific databases by tracking their querying behavior and generating personalized query recommendations. The system is supported by two recommendation engines and the underlying recommendation algorithms. The first identifies potentially "interesting" parts of the database related to the corresponding data analysis task by locating those database parts that were accessed by similar users in the past. The second identifies structurally similar queries to the ones posted by the current user. Both approaches result in a recommendation set of SQL queries that is provided to the user to modify, or directly post to the database. The demonstrated system will enable users to query and get real-time recommendations from the SkyServer database, using user traces collected from the SkyServer query log.

References

  1. G. Chatzopoulou, M. Eirinaki, and N. Polyzotis. Collaborative filtering for interactive database exploration. In SSDBM '09. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. E. Cohen. Size-estimation framework with applications to transitive closure and reachability. Journal of Computer and System Sciences, 55:441--453, 1997. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. A. Giacometti, P. Marcel, and E. Negre. Recommending Multidimensional Queries. In DaWaK'09. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. A. Giacometti, P. Marcel, E. Negre, and A. Soulet. Query recommendations for olap discovery driven analysis. In DOLAP '09. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. N. Khoussainova, M. Balazinska, W. Gatterbauer, Y. Kwon, and D. Suciu. A case for a collaborative query management system. In CIDR '09.Google ScholarGoogle Scholar
  6. G. Koutrika and Y. Ioannidis. Personalized queries under a generalized preference model. In ICDE '05. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. S. Mittal, J. S. V. Varman, G. Chatzopoulou, M. Eirinaki, and N. Polyzotis. QueRIE: A Recommender System supporting Interactive Database Exploration. In ICDM '09 (to appear in ICDM '10 proceedings because of editor's error). Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. SQL QueRIE recommendations
      Index terms have been assigned to the content through auto-classification.

      Recommendations

      Comments

      Login options

      Check if you have access through your login credentials or your institution to get full access on this article.

      Sign in

      Full Access

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader