Cardinality estimation in dbms: A comprehensive benchmark evaluation

Y Han, Z Wu, P Wu, R Zhu, J Yang, LW Tan… - arxiv preprint arxiv …, 2021 - arxiv.org
Cardinality estimation (CardEst) plays a significant role in generating high-quality query
plans for a query optimizer in DBMS. In the last decade, an increasing number of advanced …

Automatic database knob tuning: A survey

X Zhao, X Zhou, G Li - IEEE Transactions on Knowledge and …, 2023 - ieeexplore.ieee.org
Knob tuning plays an important role in database optimization, which tunes knob settings to
optimize the database performance or improve resource utilization. However, there are …

FactorJoin: a new cardinality estimation framework for join queries

Z Wu, P Negi, M Alizadeh, T Kraska… - Proceedings of the ACM …, 2023 - dl.acm.org
Cardinality estimation is one of the most fundamental and challenging problems in query
optimization. Neither classical nor learning-based methods yield satisfactory performance …

UniDM: a Unified framework for data manipulation with large language models

Y Qian, Y He, R Zhu, J Huang, Z Ma… - Proceedings of …, 2024 - proceedings.mlsys.org
Designing effective data manipulation methods is a long standing problem in data lakes.
Traditional methods, which rely on rules or machine learning models, require extensive …

A comparative study and component analysis of query plan representation techniques in ML4DB studies

Y Zhao, Z Li, G Cong - Proceedings of the VLDB Endowment, 2023 - dl.acm.org
Query plan is widely used as input in machine learning for databases (ML4DB) research,
with query plan representation as a critical step. However, existing studies typically focus on …

ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads (Extended)

P Li, W Wei, R Zhu, B Ding, J Zhou, H Lu - arxiv preprint arxiv:2310.05349, 2023 - arxiv.org
For efficient query processing, DBMS query optimizers have for decades relied on delicate
cardinality estimation methods. In this work, we propose an Attention-based LEarned …

Detect, distill and update: Learned DB systems facing out of distribution data

M Kurmanji, P Triantafillou - Proceedings of the ACM on Management of …, 2023 - dl.acm.org
Machine Learning (ML) is changing DBs as many DB components are being replaced by ML
models. One open problem in this setting is how to update such ML models in the presence …

Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems

WS Lim, L Ma, W Zhang, M Butrovich, S Arch… - Proceedings of the …, 2024 - dl.acm.org
Autonomous database management systems (DBMSs) aim to optimize themselves
automatically without human guidance. They rely on machine learning (ML) models that …

Learned query optimizer: what is new and what is next

R Zhu, L Weng, B Ding, J Zhou - Companion of the 2024 International …, 2024 - dl.acm.org
In recent times, learned query optimizer has becoming a hot research topic in learned
databases. It serves as the most suitable experimental plots for utilizing numerous machine …

[PDF][PDF] Blueprinting the Cloud: Unifying and Automatically Optimizing Cloud Data Infrastructures with BRAD

XY Geoffrey, Z Wu, F Kossmann, T Li… - Proceedings of the …, 2024 - vldb.org
Modern organizations manage their data with a wide variety of specialized cloud database
engines (eg, Aurora, BigQuery, etc.). However, designing and managing such infrastructures …