FBO: Cloud Database Knob-tuning Technique Based on Federated learning
Author:
Affiliation:

Clc Number:

TP311

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    In recent years, with the development of software and hardware, migrating databases to the cloud has become an emerging development trend and can reduce database operation and maintenance costs for small and medium-sized enterprises and individual users. Furthermore, the development of cloud databases has led to a massive market demand for database operation and maintenance. Researchers have proposed many database self-tuning technologies to support automatic optimization of database knobs. To improve tuning efficiency, existing technologies have shifted from focusing solely on the tuning problem itself to focusing on how to reuse historical experience to find the optimal parameter configuration for the current database instance. However, with the development of cloud databases, users have gradually increased their requirements for privacy protection, hoping to avoid privacy leakage while having efficient data access efficiency. Existing methods do not consider protecting the privacy of users’ historical tuning experience, which may cause user load characteristics to be perceived, causing economic losses. This study analyzes the characteristics of cloud database tuning tasks in detail, organically combines the server side and the user side, and proposes a cloud database knob tuning technology based on federated learning. First, to solve data heterogeneity in federated learning, this study proposes an experience screening method based on meta-feature matching to eliminate historical experiences with large differences in data distribution in advance to improve the efficiency of federated learning. To protect user privacy, this study organically combines the characteristics of cloud database services and proposes a federated Bayesian optimization algorithm with the node end as the training center. Through random Fourier features, it achieves user privacy protection without distorting the tuning experience. The results on extensive public benchmarks present that the proposed method could achieve competitive tuning performance compared with existing tuning methods. Moreover, due to the reuse of historical experience, it can greatly improve tuning efficiency.

    Reference
    Related
    Cited by
Get Citation

燕钰,戴志宇,吕泽楷,王宏志. FBO: 基于联邦学习的云数据库旋钮调优技术.软件学报,2025,36(3):1-20

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:May 27,2024
  • Revised:July 16,2024
  • Adopted:
  • Online: September 13,2024
  • Published:
You are the firstVisitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-4
Address:4# South Fourth Street, Zhong Guan Cun, Beijing 100190,Postal Code:100190
Phone:010-62562563 Fax:010-62562533 Email:jos@iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063