| The sewage reuse system is an important part of the sewage treatment plant.If the hardware equipment of the sewage reuse system fails,it will cause serious impact.In order to maintain the stable operation of the wastewater reuse system,it is necessary to design a data mining system.The existing sewage reuse system is still in a relatively backward level in recording data information by manually entering data into Excel tables.In order to improve the digital level of sewage reuse system,a software system suitable for sewage reuse system is designed.At the same time,the software system can ensure the stable input and storage of data,providing a guarantee for data mining.Firstly,the software architecture and database architecture of the sewage reuse system are designed.The framework of the software system adopts Python Django.According to the requirements of the sewage reuse system,the equipment management module,the spot check implementation module,the maintenance plan management module,the purchase plan module,the inventory management module,the laboratory management module,the employee data module and the data mining module are designed.The database table is designed for the daily demand module.The database structure is designed,and the database table is designed,including the unit table,equipment table,spot check implementation table,maintenance plan table,spare parts table,warehousing table,ex-warehouse table,employee data table,test table,post-purchase plan table and purchase plan detail table,which is used to store the data generated during the daily operation of the software system.Finally,the data mining system of the sewage reuse system is designed,and the analysis and prediction of the mutual influence of periodic failures between the hardware equipment of the sewage reuse system are carried out.First of all,the data mining system receives the spot check and maintenance data from the spot check implementation module and the maintenance plan management module in the software system,and carries out the data preprocessing work.Then,the linear regression model and the autoregressive model are used to model the hardware equipment of the sewage recycling system respectively,and the engineering innovation is carried out.Use the linear regression model to model the hardware in the sewage reuse system,and draw the fitting line to get the pseudo-Rsquare value of the linear regression model.However,the value of the pseudo-R-square value obtained is relatively small.Then,through the analysis of the data set,we know that the data of the hardware failure of the sewage recycling system is more suitable for the autoregressive model.In the process of algorithm modeling using autoregressive model,the negative binomial regression model and Poisson regression model in the autoregressive model are used to model the sewage reuse system.First,the data set is divided into training set and test set.The training set is trained,the test set is predicted,and the pseudo-R-square value of the autoregressive model is obtained,and the final prediction result chart is obtained.The experimental results of linear regression model and autoregressive model are compared,and it is found that autoregressive model is better in the data set of sewage reuse system. |