| With the continuous development of information technology in various industries,the amount of data storage is increasing rapidly.The amount of data that needs to be processed daily in the database for storing data in enterprises is increasing,and the requirements for response time are getting higher and higher.In the face of increasing data volume,the need for overall optimization of the underlying database structure of different information systems is imminent.In this context,based on the user operation database log of DZY information system,this paper uses the association analysis method to perform data mining on database logs,obtain the specific rules existing in user operations,and provide enterprise system database performance optimization decision support to improve the overall Database performance.The specific work of this paper is as follows:This paper analyzes the current development of database,database performance optimization and database log research,combined with the actual situation and business characteristics of DZY information system,and finally through the association analysis method for data mining of database logs,and using the evaluation method of extenics The mining results are evaluated to obtain an optimal indexing method to optimize the database performance.This paper first calculates the algorithm cost of the database according to the execution plan of the MySQL database,the CBO cost calculation method,and the structure of different query algorithms.Analyze and compare the advantages and disadvantages between different query algorithms.According to the actual operation of the DZY information system,the B+tree query algorithm is selected to optimize the user query,and the applicable scene and the inapplicable scene of the B+tree query algorithm are introduced.A database operation log data mining model is established for the DZY information system database log.The formatted database log is analyzed by Apriori algorithm to obtain the association rules existing in the database log.The association rules obtained from the association analysis are evaluated by the extenics evaluation method.The matter-element model of the association rules is established by the calculation formula of the query algorithm obtained by CBO cost accounting,and finally the superiority of different association rules is compared to obtain the optimal result.To optimize the performance of the DZY information system database.Through the simulation experiment,the time required for indexing and indexing user query is compared with the time required to insert the same amount of data,and the scientific result of the experiment is verified.Finally,in order to realize the efficient analysis of database operation log data mining,the database operation log data mining model is visually designed to realize the database log data mining system.The system realizes data integration,data warehousing,data analysis,and data display,enabling users to analyze database operation logs more conveniently and provide database performance optimization decision support. |
