The Design And Implementation Of Data Storage Management Of Upper Monitor Server

This paper chooses Wind Turbines’s upper monitoring server as the object of research. The server has data storage function besides data display function. It mainly storage the state data,alarm data and user data. These data reaches a record period of seconds or even subtle level,then data quantity will increase over time. It not only affects the operation efficiency of the database,but also increases the difficulty of maintaining database.First, the paper chooses SQL Server2005relational database to store data. According to the variable of the Wind Turbines to create the work table,alarm table and user table and write the corresponding function in Visual C++to insert the simulated data generated by random function into the work table. The number of records of the work table will increase over time,when expanded to a massive data,query,insert and delete operations will become very slowly. To solve above problem,backup solution of work table was determined by the experiment. Judge the capacity of the work table before backuping,migrate the data from work table to history table before influencing the speed of access. It will not only improve the access speed of working database,but also save the monitoring data completely,in order to query and analyse in future.In addition,this paper provides a variety of method to query historical data. Visual C++6.0using list box,button and time control,Teechat control and CrystalReportViewer control are designed and implemented respectively the historical data query,the history curve query and report query module.