SQL QueRIE Recommendations

被引:23
作者
Akbarnejad, Javad [1 ]
Chatzopoulou, Gloria [2 ]
Eirinaki, Magdalini [1 ]
Koshy, Suju [1 ]
Mittal, Sarika [1 ]
On, Duc [1 ]
Polyzotis, Neoklis [2 ]
Varman, Jothi S. Vindhiya [1 ]
机构
[1] San Jose State Univ, Dept Comp Engn, San Jose, CA 95192 USA
[2] Univ Calif Riverside, Dept Comp Sci, Riverside, CA 92521 USA
来源
PROCEEDINGS OF THE VLDB ENDOWMENT | 2010年 / 3卷 / 02期
关键词
recommender systems; collaborative filtering; relational databases; interactive exploration;
D O I
10.14778/1920841.1921048
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页码:1597 / 1600
页数:4
相关论文
共 7 条
[1]  
Chatzopoulou G., SSDBM 09
[2]   Size-estimation framework with applications to transitive closure and reachability [J].
Cohen, E .
JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 1997, 55 (03) :441-453
[3]  
Giacometti A., DAWAK 09
[4]  
Giacometti A., DOLAP 09
[5]  
Khoussainova N., CIDR 09
[6]  
Koutrika G., ICDE 05
[7]  
Mittal S., ICDM 09 IN PRESS