LightPro: Lightweight Probabilistic Workload Prediction Framework for Database-as-a-Service

Nowadays, Database-as-a-Service (DBaaS) has become more and more popular among users as it can largely reduce the complexity of managing databases and applications. Considering the increasing complexity of different applications, system management and automation such as self-provisioning and performance tuning can be challenging. To better achieve autonomous optimization of the system, the ability to predict future workload patterns is of great essence. In this paper, we propose a novel lightweight probabilistic workload forecasting framework (LIGHTPRO) that is easy to train and robust, to help the system predict future workload patterns, leveraging multi-head attention mechanism and convolution operations. Experiments on real-world query traces demonstrate the superiority of LIGHTPRO in reducing training time and capturing both long-term and short-term temporal patterns of the workload compared with other baselines.