The Design And Application Of Analysis System Based On The Power Dispatching

This paper analyzes the characteristics of data analysis system based on the power dispatching needs, introduces a statistical analysis based on data warehouse system design and implementation of the entire process.The main work done in this paperis divided into system requirements analysis, system design and system implementation in three parts.First, the analysis of needs, through the full research user needs and business processes, research results on the basis of inductive analysis, summed up the business system functional requirements and non-business functional requirements; in the system design, the paper through a combination of the current Advanced system design of the system architecture, database structure, metadata management, and other aspects of security, comprehensive and integrated design. Among them, the database structure design, this theory based on data warehouse design, including the ODS(Operational Data Store), DW(Data Warehouse) and DM(data mart) three-tier structure.ODS area which has some of the characteristics of data warehouse and OLAP systems some of the characteristics, it is "subject-oriented, integrated, current or near current, ever-changing" data; data warehouse store more data and a summary of the necessarydata To support the company’s business analysis and decision-making; data sets of data from the data warehouse urban area data are converted to form, directly support the front-end application requirements; in the system implementation, the paper by using OWB(ETL tool) and BIEE(front-end Show tools) are two very mature product is currently implemented ETL processes and data to show the contents of implementation. In this paper, the development of ideas has a certain universal significance, in most statistical analysis system can be applied.