Scalable and data-aware SQL query recommendations
作者：
Highlights：
• The paper study SQL query recommendation. We highlight the specifics of your domain.
• We list differences between SQL query recommendations and ”classical” ones, in, say, e-commerce.
• We propose collaborative filtering and content-based recommendations of SQL queries.
• To evaluate recommendations of SQL queries, we propose new precision-recall based metrics.
• We perform extensive experiments on the real-world query log, SkyServer.
摘要
•The paper study SQL query recommendation. We highlight the specifics of your domain.•We list differences between SQL query recommendations and ”classical” ones, in, say, e-commerce.•We propose collaborative filtering and content-based recommendations of SQL queries.•To evaluate recommendations of SQL queries, we propose new precision-recall based metrics.•We perform extensive experiments on the real-world query log, SkyServer.
论文关键词：Data-aware,SQL query recommendation,Evaluation
论文评审过程：Received 4 December 2019, Revised 31 August 2020, Accepted 14 September 2020, Available online 18 September 2020, Version of Record 14 October 2020.
论文官网地址：https://doi.org/10.1016/j.is.2020.101646
