Intelligent optimization method and system based on database performance

The invention discloses an intelligent optimization method and system based on database performance, and relates to the technical field of database performance optimizing.When the system operates, operation related information of a database and inherent data of the database are collected through an information collection module, and the collected data are sent to an analysis module; the analysis module is responsible for classifying the collected data, integrating the data into corresponding data sets and then sending the data sets to the data processing module, the processing module carries out model selection on the obtained classified data sets and then carries out training and calculation to obtain a data table coefficient Sjbxs, an SQL statement coefficient Yjxs and an optimization index Yhzs, the optimization index Yhzs is compared with a preset threshold value, and the data table coefficient Sjbxs, the SQL statement coefficient Yjxs and the optimization index Yhzs are obtained. The method comprises the