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 …

Towards dynamic and safe configuration tuning for cloud databases

X Zhang, H Wu, Y Li, J Tan, F Li, B Cui - Proceedings of the 2022 …, 2022 - dl.acm.org
Configuration knobs of database systems are essential to achieve high throughput and low
latency. Recently, automatic tuning systems using machine learning methods (ML) have …

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 …

HUNTER: an online cloud database hybrid tuning system for personalized requirements

B Cai, Y Liu, C Zhang, G Zhang, K Zhou, L Liu… - Proceedings of the …, 2022 - dl.acm.org
Recently, using machine learning for performance tuning of cloud database (CDB) service
has shown great potentials. However, facing personalized requirements such as various …

Make your database system dream of electric sheep: towards self-driving operation

A Pavlo, M Butrovich, L Ma, P Menon, WS Lim… - Proceedings of the …, 2021 - dl.acm.org
Database management systems (DBMSs) are notoriously difficult to deploy and administer.
Self-driving DBMSs seek to remove these impediments by managing themselves …

Learnedsqlgen: Constraint-aware sql generation using reinforcement learning

L Zhang, C Chai, X Zhou, G Li - … of the 2022 International Conference on …, 2022 - dl.acm.org
Many database optimization problems, eg, slow SQL diagnosis, database testing, optimizer
tuning, require a large volume of SQL queries. Due to privacy issues, it is hard to obtain real …

Sagedb: An instance-optimized data analytics system

J Ding, R Marcus, A Kipf, V Nathan… - Proceedings of the …, 2022 - par.nsf.gov
Modern data systems are typically both complex and general-purpose. They are complex
because of the numerous internal knobs and parameters that users need to manually tune in …

The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto …

W Zhang, WS Lim, M Butrovich, A Pavlo - Proceedings of the VLDB …, 2024 - dl.acm.org
Existing machine learning (ML) approaches to automatically optimize database
management systems (DBMSs) only target a single configuration space at a time (eg, knobs …

Machine learning for data management: A system view

G Li, X Zhou - 2022 IEEE 38th International Conference on …, 2022 - ieeexplore.ieee.org
Machine learning techniques have been proposed to optimize data management in recent
years. Compared with traditional empirical data management, learning-based methods …