Recommending Join Queries based on Path Frequency

摘要：

　　Real databases often consist of hundreds of innerlinked tables, which makes posing a complex join query a really hard task for common users.Join query recommendation is an effective technique to help users formulate better join queries and explore their information demand.In this paper, we propose a novel approach to automatically create join query recommendations based on path frequency.Our approach generates recommendations by analyzing the database schema and underlying data.First, we exploit join queries which are likely to be queried by considering both the importance and the connectivity of tables.Second, we provide users two recommendation forms.One needs no input information and the other allows users to input incomplete information.Users can choose one according to their knowledge.Extensive evaluations demonstrate the effectiveness of our approach and show that our method is helpful to formulate good join queries in practice.

关键词： Join Query Recommendation Database Schema Path Frequency

作者: Man Yu Shupeng Han Yale Chai Ying Zhang Yanlong Wen

作者单位: College of Computer and Control Engineering, Nankai University College of Computer and Control Engineering, Nankai University;College of Software, Nankai Universit

会议类型: 国际会议

会议名称: The 12th Web Information System and Application Conference第十二届全国Web信息系统及其应用学术会议(WISA2015)、全国第十次语义Web 与本体论学术研讨会(SWON2015)、全国第九次电子政务技术及应用学术研讨会(EGTA2015)

会议地点: 济南

会议语种:英文

页码: 21-26

在线出版日期: 2015-09-11（万方平台首次上网日期，不代表论文的发表时间）