Research And Application Of Data Warehouse In Power Plant E Equipment Management

Construction of information technology plays an increasingly important role in the electricity enterprise. Database technology has been widely used in power plants information technology. The use of historical data of the power plant equipment operation based on database technology is becoming increasingly important. With a large amount of historical data equipment in electric power enterprise operation accumulation of relational data, traditional methods, has been difficult to meet the needs of users. The traditional data processing, only conducted a preliminary analysis of the data, does not dig out the data contains a wealth of knowledge, not from the time and space significance of deep understanding and effective use of historical data. Because of the limitations of knowledge can not be mined valuable information from a large number of "Treasure trove of data".According to the historical data of the power plant enterprises face is not effectively utilized, combining the knowledge of data warehouse, OLAP and data mining technology, design a solution to meet power plant equipment management for effective management of power plant equipment. Based on in-depth understanding of power plant equipment operation principle, combined with the related theory knowledge of data warehouse, using Microsoft SQL Server 2005 SQL Server Integration Services ETL for the historical data (data extraction, data conversion and data loading) operation, building the data warehouse subject oriented power plant equipment. In the SQL Server Analysis Services Construction of data source, data source view, the cube, the fact table and dimension table display, OLAP and multidimensional to the Power plant date warehouse, Complete data slices, diced, roll-up, drill-down and rotating operations, from the observation of point data measured in different angles of the fact table, use the association rule mining algorithm of data analysis of historical data of the power plant, finds out the existing historical data in the given knowledge, rules, to analyze and judge the vacuum of the condenser in power plant equipment degree, find out the main factors on the vacuum of condenser effect historical data show, and gives maintenance measures.