返回
Scalable and data-aware SQL query recommendations
DOI:10.1016/j.is.2020.101646.png)
摘要
En 中文
SQL query recommendation suggests an SQL statement to a user, based on his submitted requests and on queries of other users stored in a log. Such methods need to be scalable and data-aware. Data awareness means that the filtering condition, the most crucial element of the recommendation, contains actual values. Otherwise, the query is not directly executable. Existing approaches do not satisfy the above requirements or are limited regarding the query types supported. We in turn propose DASQR, a data-aware and scalable SQL query recommender, which also outperforms competitors regarding quality and runtimes. For the evaluation, existing approaches have proposed adaptations of metrics such as precision or recall for the SQL domain, but then only use their measures. Our comparison is broader, including new adaptations of those measures and also several existing ones. (C) 2020 Published by Elsevier Ltd.
Keyword:
Data-aware
SQL query recommendation
Evaluation
AI总结
对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
3.9
论文数:
2.8K
被引数:
1.8K
机构
引用论文
Characterization of polymer matrix and low melting point solder for anisotropic conductive film各向异性导电膜用聚合物基体及低熔点焊料的表征
Toward the next generation of recommender systems: A survey of the state-of-the-art and possible extensions走向下一代推荐系统: 对最新技术和可能扩展的调查
没有更多内容

