本文已被:浏览 1632次 下载 3366次
Received:July 13, 2011 Revised:August 20, 2011
Received:July 13, 2011 Revised:August 20, 2011
中文摘要: 为了满足对生产管理进行决策分析的业务需求,对某电网公司生产管理进行了需求分析,对生产管理数据仓库进行了总体设计,制定了数据从源系统到数据仓库中进行存储的ETL 技术方案,最后利用展现工具查询和分析数据,实现决策支持,为生产管理的决策提供了可靠的依据,同时也验证了数据仓库的设计。
Abstract:In order to meet the business needs of decision analysis for production management. In this paper, a grid company conducted a needs analysis production management for the overall data warehouse design to develop ETL technology solutions for the data stored from source systems to a data warehouse, and finally make use of the display tools to query and analyze data so that achieve decision-making support, for production management decisions to provide a reliable basis, and also verify the data warehouse design.
keywords: grid production management data warehouse general design ETL(extraction-transformation-loading)
文章编号: 中图分类号: 文献标志码:
基金项目:
引用文本:
张平,吕立,孙大嵬.电网生产管理数据仓库的设计与实现.计算机系统应用,2012,21(3):36-41
ZHANG Ping,LV Li,SUN Da-Wei.Design of Grid Production Management Data Warehouse and Its Implementation.COMPUTER SYSTEMS APPLICATIONS,2012,21(3):36-41
张平,吕立,孙大嵬.电网生产管理数据仓库的设计与实现.计算机系统应用,2012,21(3):36-41
ZHANG Ping,LV Li,SUN Da-Wei.Design of Grid Production Management Data Warehouse and Its Implementation.COMPUTER SYSTEMS APPLICATIONS,2012,21(3):36-41