基于多线程并行强化学习的数据库索引推荐  

Database index recommendation based on multi-thread parallelreinforcement learning

作　　者：牛祥虞 游进国[1,2] 虞文波 Niu Xiangyu;You Jinguo;Yu Wenbo(Faculty of Information Engineering&Automation,Kunming University of Science&Technology,Kunming 650000,China;Yunnan Key Laboratory of Artificial Intelligence,Kunming 650000,China)

机构地区：[1]昆明理工大学信息工程与自动化学院,昆明650000 [2]云南省人工智能重点实验室,昆明650000

出　　处：《计算机应用研究》2023年第12期3742-3746,3765,共6页Application Research of Computers

基　　金：国家自然科学基金资助项目(62062046);CCF信息系统开放资助项目(HZ2021F0055A)。

摘　　要：建立索引是提高数据库性能的一个重要方法。目前随着强化学习算法的发展,出现了一系列使用强化学习解决索引推荐问题(index selection problem, ISP)的方法。针对现有的深度强化学习索引推荐算法训练时间长、训练不够稳定的问题,提出了一个基于A2C的索引推荐算法PRELIA。该算法加入负载索引扫描行数特征矩阵,并对奖励值进行归一化处理,旨在提高索引选择的准确性和效率,减少索引空间占用。在不同数据集上的实验结果表示,该算法可以在保证与比较算法相当的索引推荐质量的同时,推荐出的索引占用更小的存储空间,其训练时间比基线算法时间提高了4倍以上。Indexing is an important method to improve database performance.At present,with the development of reinforcement learning algorithm,there are a series of methods to solve the index recommendation problem by reinforcement learning.Aiming at the problem that the existing deep reinforcement learning index recommendation algorithm has long training time and unstable training,this paper proposed an index recommendation algorithm based on A2C(advantage actor-critical),called PRELIA(parallel compensation learning index advisor).In order to improve the accuracy and efficiency of index selection and reduce the occupation of index space,the algorithm added the characteristic matrix of the number of rows scanned by load index and normalized the reward value.Experimental results on different data sets show that the proposed algorithm can gua-rantee the index recommendation quality equivalent to that of the compared algorithms,while the recommended index occupies less storage space,and the training time is more than 4 times longer than that of the baseline algorithms.

关 键 词：数据库 索引推荐 强化学习 查询优化 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]