Lero: A learning-to-rank query optimizer

R Zhu, W Chen, B Ding, X Chen, A Pfadler… - arxiv preprint arxiv …, 2023 - arxiv.org
A recent line of works apply machine learning techniques to assist or rebuild cost-based
query optimizers in DBMS. While exhibiting superiority in some benchmarks, their …

Queryformer: A tree transformer model for query plan representation

Y Zhao, G Cong, J Shi, C Miao - Proceedings of the VLDB Endowment, 2022 - dl.acm.org
Machine learning has become a prominent method in many database optimization problems
such as cost estimation, index selection and query optimization. Translating query execution …

Data lakes: A survey of functions and systems

R Hai, C Koutras, C Quix… - IEEE Transactions on …, 2023 - ieeexplore.ieee.org
Data lakes are becoming increasingly prevalent for Big Data management and data
analytics. In contrast to traditional 'schema-on-write'approaches such as data warehouses …

Zero-shot cost models for out-of-the-box learned cost prediction

B Hilprecht, C Binnig - arxiv preprint arxiv:2201.00561, 2022 - arxiv.org
In this paper, we introduce zero-shot cost models which enable learned cost estimation that
generalizes to unseen databases. In contrast to state-of-the-art workload-driven approaches …

Spatial Query Optimization With Learning

X Zhang, A Eldawy - Proceedings of the VLDB Endowment, 2024 - dl.acm.org
Query optimization is a key component in database management systems (DBMS) and
distributed data processing platforms. Recent research in the database community …

Pilotscope: Steering databases with machine learning drivers

R Zhu, L Weng, W Wei, D Wu, J Peng, Y Wang… - Proceedings of the …, 2024 - dl.acm.org
Learned databases, or AI4DB techniques, have rapidly developed in the last decade.
Deploying machine learning (ML) and AI4DB algorithms into actual databases is the gold …

Machine learning for databases

G Li, X Zhou, L Cao - Proceedings of the First International Conference …, 2021 - dl.acm.org
Machine learning techniques have been proposed to optimize the databases. For example,
traditional empirical database optimization techniques (eg, cost estimation, join order …

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 …

Machine unlearning in learned databases: An experimental analysis

M Kurmanji, E Triantafillou, P Triantafillou - Proceedings of the ACM on …, 2024 - dl.acm.org
Machine learning models based on neural networks (NNs) are enjoying ever-increasing
attention in the Database (DB) community, both in research and practice. However, an …

Modeling shifting workloads for learned database systems

P Wu, ZG Ives - Proceedings of the ACM on Management of Data, 2024 - dl.acm.org
Learned database systems address several weaknesses of traditional cost estimation
techniques in query optimization: they learn a model of a database instance, eg, as queries …