Learning database optimization techniques: the state-of-the-art and prospects.
Gespeichert in:
| Titel: | Learning database optimization techniques: the state-of-the-art and prospects. |
|---|---|
| Autoren: | Qiao, Shao-Jie, Fan, Han-Lin, Han, Nan, Du, Lan, Peng, Yu-Han, Tang, Rong-Min, Qin, Xiao |
| Quelle: | Frontiers of Computer Science; Dec2025, Vol. 19 Issue 12, p1-24, 24p |
| Abstract: | Artificial intelligence-enabled database technology, known as AI4DB (Artificial Intelligence for Databases), is an active research area attracting significant attention and innovation. This survey first introduces the background of learning-based database techniques. It then reviews advanced query optimization methods for learning databases, focusing on four popular directions: cardinality/cost estimation, learning-based join order selection, learning-based end-to-end optimizers, and text-to-SQL models. Cardinality/cost estimation is classified into supervised and unsupervised methods based on learning models, with illustrative examples provided to explain the working mechanisms. Detailed descriptions of various query optimizers are also given to elucidate the working mechanisms of each component in learning query optimizers. Additionally, we discuss the challenges and development opportunities of learning query optimizers. The survey further explores text-to-SQL models, a new research area within AI4DB. Finally, we consider the future development prospects of learning databases. [ABSTRACT FROM AUTHOR] |
| Copyright of Frontiers of Computer Science is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Datenbank: | Complementary Index |
Full Text Finder 
Nájsť tento článok vo Web of Science Schreiben Sie den ersten Kommentar!