Column storage layout optimization method based on deep reinforcement learning

Qin Xiongpai,Chen Yueguo,Du Xiaoyong,Zhao Liping
2021-01-01
Abstract:The invention discloses a column storage layout optimization method based on deep reinforcement learning. The method comprises the steps of receiving a query load; analyzing the query load to generatequery features; obtaining feature data of the data columns according to the query features; determining an output sequence of the columns based on a strategy of the output sequence of the columns andthe feature data of the data columns; performing quantitative evaluation on the output sequence, wherein the quantitative evaluation strategy is adjusted based on the reward of the system; and adjusting the output sequence of the columns according to the quantitative evaluation result. Through the method, the used model parameters can be continuously adjusted in the expected direction of reducingthe disk skip reading time, so that the neural network automatically learns the optimal column sequence according to the characteristic data of the columns, incremental training can be achieved, andthe column sequence does not need to be recalculated during each time of optimization, so that the calculation cost is greatly reduced.
What problem does this paper attempt to address?