ByteCard: Enhancing ByteDance's Data Warehouse with Learned Cardinality Estimation

Y Han, H Wang, L Chen, Y Dong, X Chen… - Companion of the 2024 …, 2024 - dl.acm.org
Cardinality estimation is a critical component and a longstanding challenge in modern data
warehouses. ByteHouse, ByteDance's cloud-native engine for extensive data analysis in …

ByteCard: Enhancing Data Warehousing with Learned Cardinality Estimation

Y Han, H Wang, L Chen, Y Dong, X Chen, B Yu… - arXiv preprint arXiv …, 2024 - arxiv.org
Cardinality estimation is a critical component and a longstanding challenge in modern data
warehouses. ByteHouse, ByteDance's cloud-native engine for big data analysis in exabyte …

Sample-Efficient Cardinality Estimation Using Geometric Deep Learning

S Reiner, M Grossniklaus - 2023 - kops.uni-konstanz.de
In database systems, accurate cardinality estimation is a cornerstone of effective query
optimization. In this context, estimators that use machine learning have shown significant …

NeuroCard: one cardinality estimator for all tables

Z Yang, A Kamsetty, S Luan, E Liang, Y Duan… - arXiv preprint arXiv …, 2020 - arxiv.org
Query optimizers rely on accurate cardinality estimates to produce good execution plans.
Despite decades of research, existing cardinality estimators are inaccurate for complex …

ASM in Action: Fast and Practical Learned Cardinality Estimation

S Lee, K Kim, WS Han - … of the 2024 International Conference on …, 2024 - dl.acm.org
Learned cardinality estimators have shown remarkable improvements in estimation
accuracy by exploiting machine learning techniques, yet suffer from inefficiency or sub …

Warper: Efficiently adapting learned cardinality estimators to data and workload drifts

B Li, Y Lu, S Kandula - … of the 2022 International Conference on …, 2022 - dl.acm.org
Recent learned cardinality estimation (CE) models are vulnerable when query predicates or
the underlying datasets drift from what the models were trained upon. We propose a system …

A unified deep model of learning from both data and queries for cardinality estimation

P Wu, G Cong - Proceedings of the 2021 International Conference on …, 2021 - dl.acm.org
Cardinality estimation is a fundamental problem in database systems. To capture the rich
joint data distributions of a relational table, most of the existing work either uses data as …

Ceda: learned cardinality estimation with domain adaptation

Z Wang, Q Zeng, N Wang, H Lu, Y Zhang - Proceedings of the VLDB …, 2023 - dl.acm.org
Cardinality Estimation (CE) is a fundamental but critical problem in DBMS query
optimization, while deep learning techniques have made significant breakthroughs in the …

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 …

Bayescard: Revitilizing bayesian frameworks for cardinality estimation

Z Wu, A Shaikhha, R Zhu, K Zeng, Y Han… - arXiv preprint arXiv …, 2020 - arxiv.org
Cardinality estimation (CardEst) is an essential component in query optimizers and a
fundamental problem in DBMS. A desired CardEst method should attain good algorithm …