文献类型： 会议论文

第一作者： Jiangqing Wang

作者： Jiangqing Wang ¹ ; Shipeng Cao ¹ ; Chong Sun ² ; Huili Zhang ² ; Zhiqing Luo ³ ; Bowen Zhang ¹ ; Hongyan Zhao ² ;

作者机构： 1.College of Computer Science, South-Central Minzu University, Wuhan, China|Hubei Provincial Engineering Research Center for Intelligent Management of Manufacturing Enterprise, Wuhan, China

2.College of Computer Science, South-Central Minzu University, Wuhan, China|Hubei Provincial Engineering Research Center of Agricultural Blockchain and Intelligent Management, Wuhan, China

3.Institute of Agricultural Economics and Technology, Hubei Academy of Agricultural Sciences, Wuhan, China

关键词： Training;Attention mechanisms;Accuracy;Databases;Query processing;Predictive models;Encoding;Stability analysis;Convolutional neural networks;Thermal stability

会议名称： [ "International Conference on E-Business Engineering" , "IEEE International Conference on e-Business Engineering"]

主办单位：

页码： 67-73

摘要： With the development of modern database services and artificial intelligence technology, learning-based query optimizers are receiving increasing attention from researchers. Compared to traditional database query optimizers, learning-based query optimizers offer better performance but still face critical issues with query performance stability. This paper introduces three improvements to the COOOL system, proposing Saro(a Simplified Attention-based Learning-to-Rank Query Qptimizer). Firstly, Saro integrates a lightweight attention mechanism (Tree-CBAM) based on the tree convolutional neural network to more accurately identify effective features in physical execution plans, thereby enhancing the model's inference accuracy. Secondly, the encoding of physical execution plans is optimized by adding depth information of the nodes and supporting bitmap scanning of the encoded plans. Additionally, we improved the loss function using the Plackett-Luce model. Experimental results on the TPC-H and JOB datasets show that Saro achieves certain improvements in prediction accuracy and query speed compared to current mainstream learning-based query optimizers. It also demonstrates better performance compared to the query optimizer of PostgreSQL. Furthermore, we explore the reasons behind poor model performance when workloads change, leading to excessively high query times for some queries, and we significantly improved performance through model fine-tuning.

分类号： tp393