电力企业中数据仓库的构建与应用

Construction and Application of Data Warehouse in Electric Powe r Enterprise

随着电力企业的信息化建设的发展,运行的事务管理系统保存了海量的运行数据,成为电力企业决策管理的最有价值的原始资源。然而,各地区及部门间信息化建设的不平衡性和独立性致使无法构建有效的知识管理系统,难以提供企业级的决策分析支持。数据仓库的建立可以解决为电力企业提供决策分析信息存在的困难。本文引入了数据仓库的概念,详细介绍了数据仓库的构成、内容和技术特点。研究了数据仓库建模的方法。结合电力系统的特点,提取出适合于数据仓库建立的主题概念。通过数据处理技术对电力系统事务管理系统保存的海量数据进行整合,构造面向决策的电力系统数据仓库。

With the development of information construction of power enterprises,the running transaction management system has saved a large amount of operation data,and has become the most valuable original resource for decision-making and management of power enterprises.However,due to the imbalance and independence of information construction among regions and departments,it is difficult to build an effective knowledge management system and provide enterprise level decision analysis support.The establishment of data warehouse can solve the difficulty of providing decision analysis information for power enterprises.This paper introduces the concept of data warehouse,introduces the structure,content and technical characteristics of data warehouse in detail.The method of data warehouse modeling is studied.Combined with the characteristics of power system,the topic concept suitable for data warehouse is extracted.Through the data processing technology,the massive data stored in the power system transaction management system are integrated,and the decision-making oriented power system data warehouse is constructed.