4 papers · 1 filter
Can Large Language Models be a Cardinality Estimator? An Empirical study
Liangzu Liu, Yiyan Wang, Yinjun Wu +8
Cardinality estimation (CardEst) still remains a challenging problem for DBMS. Recent years have witnessed the success of ML-based cardinality estimators in outperforming tradition…
LLMIA: An Out-of-the-Box Index Advisor via In-Context Learning with LLMs
Xinxin Zhao, Xinmei Huang, Haoyang Li +7
Index recommendation is crucial for optimizing database performance. However, existing heuristic- and learning-based methods often rely on inefficient exhaustive search and estimat…
VIDEX: A Disaggregated and Extensible Virtual Index for the Cloud and AI Era
Rong Kang, Shuai Wang, Tieying Zhang +6
Virtual index, also known as hypothetical indexes, play a crucial role in database query optimization. However, with the rapid advancement of cloud computing and AI-driven models f…
PLM4NDV: Minimizing Data Access for Number of Distinct Values Estimation with Pre-trained Language Models
Xianghong Xu, Xiao He, Tieying Zhang +3
Number of Distinct Values (NDV) estimation of a multiset/column is a basis for many data management tasks, especially within databases. Despite decades of research, most existing m…