Application Of Data Warehouse And Data Mining Techniques To Power System

In the past half century, information technology, computer technology, network technology dramatically impacted the power system in almost every aspect. Varieties of information system such as SCADA, EMS, GIS etc have been constructed. However, such problems as data un-sharable, lowly integration, difficulty to extract characteristic in mass data, hard to monitor current service and trend unpredicted occurs. A solution based on data warehouse and data mining is put forward seems can well done.Data warehouse is a subject oriented, integrated, non-volatile and time-variant collection of data, which contains consistent data used in enterprise decision support. Data Mining is a data-analyzing and knowledge-acquiring procedure by use of artificial intelligence.This paper researches the application of data warehouse and data mining techniques in power systems. After introduces the background of the question of study, the paper discuss the architecture of corporate information factory, its components and relations between is as well, which emphasized is decision support system, data warehouse and data mining technology.To the problem of ineffective use of huge datum in power system, a solution based on data warehouse within procedures of cleaning, extracting, transforming is brought forward, with which support rapid, efficient response.Finally, three main applications of data warehouse are depicted in detail. To the subject of electricity load, OLAP is used to analyze and find out the feature of curve and data mining helps to prediction of the load values, with which some valuable results are dropped and experiences are gained for work in future.