SQL QueRIE recommendations

  • Authors:
  • Javad Akbarnejad;Gloria Chatzopoulou;Magdalini Eirinaki;Suju Koshy;Sarika Mittal;Duc On;Neoklis Polyzotis;Jothi S. Vindhiya Varman

  • Affiliations:
  • San Jose State Univ.;Univ. of California, Riverside;San Jose State Univ.;San Jose State Univ.;San Jose State Univ.;San Jose State Univ.;Univ. of California, Santa Cruz;San Jose State Univ.

  • Venue:
  • Proceedings of the VLDB Endowment
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

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.