.png){kind=icon}
.png){kind=icon}
Return
Mining SQL workloads for learning analysis behavior
.png){kind=icon}
OA
AI
DOI：10.1016/j.is.2022.102004.png)
.png){kind=icon}
.png){kind=icon}
Share.png){kind=icon}
Save
Abstract
En 中文
This paper presents a set of analyses aiming at better understanding the SQLShare workload Jain et al. (2016) and learning users' analysis behavior. SQLShare is a database-as-a-service platform targeting scientists and data scientists with minimal database experience, whose workload was made available to the research community. According to the authors of Jain et al. (2016), this workload is the only one containing primarily ad-hoc hand-written queries over user-uploaded datasets. In this paper we analyze this workload, by comparing users' explorations (sequences of queries), looking for common SQL operations performed by the users during data analysis and studying query complexity. We use a clustering algorithm to retrieve groups of similar explorations and we analyze the obtained clusters through many statistical and visual indicators for explaining analysis patterns inside clusters. To our knowledge, this is the first attempt to characterize human analysis behavior in SQL workloads. (c) 2022 Elsevier Ltd. All rights reserved.
Keywords:
Data exploration
SQLShare
Human analysis behavior
Sequence analysis
Statistical explainability
Visual indicators
AI Summary
Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.
Journal
IF:
3.9
Papers:
2.8K
Citations:
1.8K