Aiops solutions for incident management: Technical guidelines and a comprehensive literature review

Y Remil, A Bendimerad, R Mathonat… - arXiv preprint arXiv …, 2024 - arxiv.org
The management of modern IT systems poses unique challenges, necessitating scalability,
reliability, and efficiency in handling extensive data streams. Traditional methods, reliant on …

Next-step suggestions for modern interactive data analysis platforms

T Milo, A Somech - Proceedings of the 24th ACM SIGKDD International …, 2018 - dl.acm.org
Modern Interactive Data Analysis (IDA) platforms, such as Kibana, Splunk, and Tableau, are
gradually replacing traditional OLAP/SQL tools, as they allow for easy-to-use data …

A collaborative filtering approach for recommending OLAP sessions

J Aligon, E Gallinucci, M Golfarelli, P Marcel… - Decision Support …, 2015 - Elsevier
While OLAP has a key role in supporting effective exploration of multidimensional cubes, the
huge number of aggregations and selections that can be operated on data may make the …

Similarity metrics for SQL query clustering

G Kul, DTA Luong, T Xie, V Chandola… - … on Knowledge and …, 2018 - ieeexplore.ieee.org
Database access logs are the starting point for many forms of database administration, from
database performance tuning, to security auditing, to benchmark design, and many more …

Cube query interestingness: Novelty, relevance, peculiarity and surprise

D Gkitsakis, S Kaloudis, E Mouselli, V Peralta… - Information Systems, 2024 - Elsevier
In this paper, we discuss methods to assess the interestingness of a query in an
environment of data cubes. We assume a hierarchical multidimensional database, storing …

PreQR: pre-training representation for SQL understanding

X Tang, S Wu, M Song, S Ying, F Li… - Proceedings of the 2022 …, 2022 - dl.acm.org
Recently, the learning-based models are shown to outperform the conventional methods for
many database tasks such as cardinality estimation, join order selection and performance …

Comprehensive and efficient workload compression

S Deep, A Gruenheid, P Koutris, J Naughton… - arXiv preprint arXiv …, 2020 - arxiv.org
This work studies the problem of constructing a representative workload from a given input
analytical query workload where the former serves as an approximation with guarantees of …

Automatic generation of comparison notebooks for interactive data exploration

A Chanson, N Labroche, P Marcel, S Rizzi… - Advances in Database …, 2022 - cris.unibo.it
We consider the problem of generating SQL notebooks of comparison queries for
Exploratory Data Analysis (EDA). A comparison query allows to find insights in a dataset by …

An automatic clustering technique for query plan recommendation

E Azhir, NJ Navimipour, M Hosseinzadeh, A Sharifi… - Information …, 2021 - Elsevier
The query optimizer is responsible for identifying the most efficient Query Execution Plans
(QEP's). The distributed database relations may be kept in several places. These results in a …

Interest-based recommendations for business intelligence users

K Drushku, J Aligon, N Labroche, P Marcel, V Peralta - Information Systems, 2019 - Elsevier
It is quite common these days for experts, casual analysts, executives and data enthusiasts,
to analyze large datasets through user-friendly interfaces on top of Business Intelligence (BI) …