Efficient Query Workload Prediction Algorithm Based on TCN-A
The query workload prediction algorithm based on a novel time series prediction model is proposed to address the pro-blem of database management system cannot be optimized in time due to the dynamic change of query workload and the difficulty of forecasting effectively in the field of big data querying.First of all,the algorithm preprocesses the original historical users'queries by filtering,temporal interval partition and query workload construction to obtain the query workload sequence which is convenient for the network model to analyze and process.Secondly,the algorithm constructs a time series prediction model with temporal convolution network as the core,extracts the historical trend and auto-correlation characteristics of query workload,and realizes the time series prediction efficiently.At the same time,the algorithm integrates the designed temporal attention mecha-nism to weight the important query workloads to ensure that the query workload sequence can be analyzed and calculated effi-ciently by the model,and thus improving the performance of prediction algorithm.Finally,the algorithm uses the above time se-ries prediction model to make full use of the query interval time to accurately predict the future query workloads,so that the data-base management system can achieve self-performance tuning in advance to adapt to the dynamic change of the workloads.Expe-rimental results show that the designed query workload prediction algorithm exhibits good prediction performance on several evaluation metrics and is able to predict future query workload accurately over the query time interval.
NETL
NSTL
万方数据
