Cloud-Native Databases: A Survey

H Dong, C Zhang, G Li, H Zhang - IEEE Transactions on …, 2024 - ieeexplore.ieee.org
Cloud databases have been widely accepted and deployed due to their unique advantages,
such as high elasticity, high availability, and low cost. Many new techniques, such as …

A learned cost model for big data query processing

Y Li, L Wang, S Wang, Y Sun, B Zheng, Z Peng - Information Sciences, 2024 - Elsevier
The efficiency of query processing in the Spark SQL big data processing engine is
significantly affected by execution plans and allocated resources. However, existing cost …

Automating localized learning for cardinality estimation based on XGBoost

J Feng, Z Li, Q Chen, H Liu - Knowledge and Information Systems, 2024 - Springer
For cardinality estimation in DBMS, building multiple local models instead of one global
model can usually improve estimation accuracy as well as reducing the effort to label large …

PACE: Poisoning Attacks on Learned Cardinality Estimation

J Zhang, C Zhang, G Li, C Chai - … of the ACM on Management of Data, 2024 - dl.acm.org
Cardinality estimation (CE) plays a crucial role in database optimizer. We have witnessed
the emergence of numerous learned CE models recently which can outperform traditional …

DACE: A Database-Agnostic Cost Estimator

Z Liang, X Chen, Y Xia, R Ye, H Chen… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
Cost estimation is of great importance in query optimization. However, traditional optimizers
compute the cost based on heuristics, sacrificing accuracy for efficiency. In recent years …

Towards Exploratory Query Optimization for Template-Based SQL Workloads

J Feng, Z Li, Q Chen - 2024 IEEE 40th International Conference …, 2024 - ieeexplore.ieee.org
SQL query optimization aims to choose an optimal Query Execution Plan (QEP) for a query.
The existing optimizers usually choose the plan with the minimal execution cost. However, in …

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 …

HTAP Databases: A Survey

C Zhang, G Li, J Zhang, X Zhang… - IEEE Transactions on …, 2024 - ieeexplore.ieee.org
Since Gartner coined the term, Hybrid Transactional and Analytical Processing (HTAP),
numerous HTAP databases have been proposed to combine transactions with analytics in …

Enhancing the performance of selectivity estimation with machine learning techniques

Z Meng - 2024 - dr.ntu.edu.sg
Selectivity estimation is a fundamental task in database management systems and has been
studied for decades. Given a SQL query, selectivity estimation returns the number of records …