Hydro: Adaptive Query Processing of ML Queries

GT Kakkar, J Cao, A Sengupta, J Arulraj… - arXiv preprint arXiv …, 2024 - arxiv.org
Query optimization in relational database management systems (DBMSs) is critical for fast
query processing. The query optimizer relies on precise selectivity and cost estimates to …

Fastgres: Making learned query optimizer hinting effective

L Woltmann, J Thiessat, C Hartmann… - Proceedings of the …, 2023 - dl.acm.org
The traditional and well-established cost-based query optimizer approach enumerates
different execution plans for each query, assesses each plan with costs, and selects the plan …

Extending relational query processing with ML inference

K Karanasos, M Interlandi, D Xin, F Psallidas… - arXiv preprint arXiv …, 2019 - arxiv.org
The broadening adoption of machine learning in the enterprise is increasing the pressure for
strict governance and cost-effective performance, in particular for the common and …

Roq: Robust Query Optimization Based on a Risk-aware Learned Cost Model

A Kamali, V Kantere, C Zuzarte, V Corvinelli - arXiv preprint arXiv …, 2024 - arxiv.org
Query optimizers in relational database management systems (RDBMSs) search for
execution plans expected to be optimal for a given queries. They use parameter estimates …

Base: Bridging the gap between cost and latency for query optimization

X Chen, Z Wang, S Liu, Y Li, K Zeng, B Ding… - Proceedings of the …, 2023 - dl.acm.org
Some recent works have shown the advantages of reinforcement learning (RL) based
learned query optimizers. These works often use the cost (ie, the estimation of cost model) or …

Exploring learned join algorithm selection in relational database management systems

LP Nguyen - 2021 - dspace.mit.edu
Query optimizers, crucial components of relational database management systems, are
responsible for generating efficient query execution plans. Despite many advances in the …

RobOpt: A Tool for Robust Workload Optimization Based on Uncertainty-Aware Machine Learning

A Kamali, V Kantere, C Zuzarte… - Companion of the 2024 …, 2024 - dl.acm.org
Relational database management systems (RDBMSs) employ query optimizers to search for
execution plans deemed optimal for specific queries. Classical optimizers rely on inaccurate …

HRDBMS: Combining the best of modern and traditional relational databases

J Arnold, B Glavic, I Raicu - arXiv preprint arXiv:1901.08666, 2019 - arxiv.org
HRDBMS is a novel distributed relational database that uses a hybrid model combining the
best of traditional distributed relational databases and Big Data analytics platforms such as …

Leon: A new framework for ml-aided query optimization

X Chen, H Chen, Z Liang, S Liu, J Wang… - Proceedings of the …, 2023 - dl.acm.org
Query optimization has long been a fundamental yet challenging topic in the database field.
With the prosperity of machine learning (ML), some recent works have shown the …

Steering query optimizers: A practical take on big data workloads

P Negi, M Interlandi, R Marcus, M Alizadeh… - Proceedings of the …, 2021 - dl.acm.org
In recent years, there has been tremendous interest in research that applies machine
learning to database systems. Being one of the most complex components of a DBMS, query …