Can llm already serve as a database interface? a big bench for large-scale database grounded text-to-sqls

J Li, B Hui, G Qu, J Yang, B Li, B Li… - Advances in …, 2024 - proceedings.neurips.cc
Text-to-SQL parsing, which aims at converting natural language instructions into executable
SQLs, has gained increasing attention in recent years. In particular, GPT-4 and Claude-2 …

Survey on performance optimization for database systems

S Huang, Y Qin, X Zhang, Y Tu, Z Li, B Cui - Science China Information …, 2023 - Springer
The performance optimization of database systems has been widely studied for years. From
the perspective of the operation and maintenance personnel, it mainly includes three topics …

AI meets database: AI4DB and DB4AI

G Li, X Zhou, L Cao - Proceedings of the 2021 International Conference …, 2021 - dl.acm.org
Database and Artificial Intelligence (AI) can benefit from each other. On one hand, AI can
make database more intelligent (AI4DB). For example, traditional empirical database …

opengauss: An autonomous database system

G Li, X Zhou, J Sun, X Yu, Y Han, L Jin, W Li… - Proceedings of the …, 2021 - dl.acm.org
Although learning-based database optimization techniques have been studied from
academia in recent years, they have not been widely deployed in commercial database …

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 …

Automatic database knob tuning: a survey

X Zhao, X Zhou, G Li - IEEE Transactions on Knowledge and …, 2023 - ieeexplore.ieee.org
Knob tuning plays an important role in database optimization, which tunes knob settings to
optimize the database performance or improve resource utilization. However, there are …

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 …

Budget-aware index tuning with reinforcement learning

W Wu, C Wang, T Siddiqui, J Wang… - Proceedings of the …, 2022 - dl.acm.org
Index tuning aims to find the optimal index configuration for an input workload. It is a
resource-intensive task since it requires making multiple expensive" what-if" calls to the …

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 …

Are updatable learned indexes ready?

C Wongkham, B Lu, C Liu, Z Zhong, E Lo… - arXiv preprint arXiv …, 2022 - arxiv.org
Recently, numerous promising results have shown that updatable learned indexes can
perform better than traditional indexes with much lower memory space consumption. But it is …