arrow
返回

Scalable and data-aware SQL query recommendations

delete2021-02-01
delete3
PRE
AI
N
Natalia Arzamasova *
K
Klemens Böhm
DOI:10.1016/j.is.2020.101646delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

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总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

Enterprise Information Systems 封面图
Enterprise Information Systems
IF:
3.9
论文数:
2.8K
被引数:
1.8K

机构

H
Helmholtz Association
学者数:
13.2W
论文数: 10.7W
被引数: 145
引用论文

引用论文

err分享
err收藏
Fab: Content-based, collaborative recommendation
err1997-03-01
err2.0K
errOAAI
errBalabanovic, M; Shoham, Y
err分享
err收藏
QueRIE: Collaborative Database Exploration
err2014-07-01
err46
PREAI
errEirinaki, Magdalini; Abraham, Suju; Polyzotis, Neoklis; Shaikh, Naushin
err分享
err收藏
The Cost of Complications Following Major Resection of Malignant Neoplasia
err2018-11-01
err0
errOAAI
errCheryl K. Zogg; Taylor D. Ottesen; Kareem J. Kebaish; Anoop Galivanche; Shilpa Murthy; Navin R. Changoor; Donald L. Zogg; Timothy M. Pawlik; Adil H. Haider
err分享
err收藏
err分享
err收藏
A collaborative filtering approach for recommending OLAP sessions
err2015-01-01
err44
errOAAI
errAligon, Julien; Gallinucci, Enrico; Golfarelli, Matteo; Marcel, Patrick; Rizzi, Stefano
err分享
err收藏
没有更多内容