Bao: Making learned query optimization practical

R Marcus, P Negi, H Mao, N Tatbul… - Proceedings of the …, 2021 - dl.acm.org
Recent efforts applying machine learning techniques to query optimization have shown few
practical gains due to substantive training overhead, inability to adapt to changes, and poor …

RadixSpline: a single-pass learned index

A Kipf, R Marcus, A van Renen, M Stoian… - Proceedings of the third …, 2020 - dl.acm.org
Recent research has shown that learned models can outperform state-of-the-art index
structures in size and lookup performance. While this is a very promising result, existing …

Towards dynamic and safe configuration tuning for cloud databases

X Zhang, H Wu, Y Li, J Tan, F Li, B Cui - Proceedings of the 2022 …, 2022 - dl.acm.org
Configuration knobs of database systems are essential to achieve high throughput and low
latency. Recently, automatic tuning systems using machine learning methods (ML) have …

Estimating cardinalities with deep sketches

A Kipf, D Vorona, J Müller, T Kipf, B Radke… - Proceedings of the …, 2019 - dl.acm.org
We introduce Deep Sketches, which are compact models of databases that allow us to
estimate the result sizes of SQL queries. Deep Sketches are powered by a new deep …

Peregrine: Workload optimization for cloud query engines

A Jindal, H Patel, A Roy, S Qiao, Z Yin, R Sen… - Proceedings of the …, 2019 - dl.acm.org
Database administrators (DBAs) were traditionally responsible for optimizing the on-premise
database workloads. However, with the rise of cloud data services, where cloud providers …

Auto-WLM: Machine learning enhanced workload management in Amazon Redshift

G Saxena, M Rahman, N Chainani, C Lin… - Companion of the 2023 …, 2023 - dl.acm.org
There has been a lot of excitement around using machine learning to improve the
performance and usability of database systems. However, few of these techniques have …

[PDF][PDF] Estimating filtered group-by queries is hard: Deep learning to the rescue

A Kipf, M Freitag, D Vorona, P Boncz… - … Workshop on Applied …, 2019 - db.in.tum.de
While estimating the result size of a group-by operation on a base table is hard on its own,
the presence of selections makes this problem increasingly difficult to solve. We show that …

Buffer pool aware query scheduling via deep reinforcement learning

C Zhang, R Marcus, A Kleiman… - arXiv preprint arXiv …, 2020 - arxiv.org
In this extended abstract, we propose a new technique for query scheduling with the explicit
goal of reducing disk reads and thus implicitly increasing query performance. We introduce …

Facilitating SQL query composition and analysis

Z Zolaktaf, M Milani, R Pottinger - Proceedings of the 2020 ACM …, 2020 - dl.acm.org
Formulating efficient SQL queries requires several cycles of tuning and execution. We
examine methods that can accelerate and improve this interaction by providing insights …

Intelligent automated workload analysis for database replatforming

A Aleyasen, M Morcos, L Antova, M Sugiyama… - Proceedings of the …, 2022 - dl.acm.org
Performing a detailed workload analysis is a crucial step in determining the feasibility,
timeline and cost of a major data warehouse replatforming project, ie, migration from one …