Recurrent neural network-based database query time prediction method

Wu Sai,Bi Liyuan,Chen Ke,Chen Gang,Shou Lidan,Hu Tianlei
2017-01-01
Abstract:The invention discloses a recurrent neural network-based database query time prediction method. The method comprises the following steps of: firstly extracting query plans from database history query records so as to form original data, wherein each query plan comprises operation information and operation time; classifying the original data according to the lengths of the operation time to ensure that the quantities of the query plans in various types are the same; specially processing the query plans to obtain an operation sequence and an operation time sequence; taking the operation sequence as a feature vector, taking the operation time sequence as a label, inputting the feature vector and the label into a neural network, and carrying out training to obtain a model; for a to-be-predicted query plan, repeating the steps to obtain an operation sequence, inputting the operation sequence into the model, and outputting the operation time sequence to complete the prediction of a database query time. The method is capable of obtaining favorable effect in the aspect of relational database query time prediction, and the correctness of the model under simulated data training is higher than 78%. The method can be used for solving the key problems in query optimization and load management.
What problem does this paper attempt to address?