| The data center is designed based on unified data standards and uses technologies of centralized data management.It is an organic combination of site,tools,processes for centralized,integrating,sharing,and analysis of enterprise data resources.This article introduces the status of current electric power enterprise information system.Nowadays,electric power enterprises have established a lot of business information systems.However,these information systems are operated independently,which makes them have several common problems,such as difficulty in information sharing and exchanging,insufficient data analysis and data display,low quality data resources,etc.In order to solve the above problems,this paper discusses the project of designing data center for power enterprises.According to the demand survey,the main function goals of the data center system are determined: realizing data sharing among business systems,implementing display of important data indicators,and achieving data quality management.From the system level,we designed main data source of the data center,including the marketing system,the production system,the financial system,and the human resources system.Data collection methods are also designed that utilize ETL extraction tools and CDC replication tools to collect source data for the data center.The data storage structure is implemented by using the regional structure of ODS(operational data storage)and DW(data warehouse).The module of data display is designed to illustrate important data of four main modules,including marketing,production,finance,human resources.In addition,the data index of these modules is also displaied.Finally,the data quality management is implemented.The data quality express is formed by using the data filtering function of ETL tool to assist data quality improvment.System test of main functions are completed to verify the feasibility of our system design.In the last section,we summary this work and discuss prospect of this topic. |
PDF Full Text Request