The Design And Implementation Of Comprehensive Analysis Subject Module In Power Data Center

The thesis is based on an actual project that is the Data Center system of State Grid "SG186" engineering developed by Shenyang Neusoft Co Ltd Electric Power Department.Through the analysis of relevant technologic about Data Warehouse and OLAP that used in Power Data Center, The thesis is based on the familiarity to the Power business, and discusses the method and the step of Data Warehouse constructed in the Power Enterprise. Meanwhile, according to the analysis of specific Power business, designs data model of Comprehensive Analysis Subject. Through the Conception Model of Comprehensive Analysis Subject, the thesis achieves the logic data model and physical data model, and builds the Data Warehouse system. Based on this Data Warehouse, through the data preparative work, data is transferred by ETL, and then generates the Data CUBE by modeling the numerous data, and OLAP through the CUBE, achieves the analysis of Comprehensive Analysis Subject module. Through the analysis, acquires the the analysis and decision-making information for leaders of all levels in the Power Enterprise. The Implementaion of Comprehensive Analysis Subject Module, proved the feasibility of the Data Warehouse technology in the Power Enterprise.Through the actual application and test by the Power Enterprise, Comprehensive Analysis Subject module is operating well, the data is accurate and the performance satisfies the requirements.