Please wait a minute...
J4  2009, Vol. 43 Issue (11): 2062-2066    DOI: 10.3785/j.issn.1008-973X.2009.11.022
电气工程     
电力企业通用报表综合管理系统设计与实现
王光增1,2,曹一家1,戚军1,姜新凡3,周明远3,谢培元3
(1.浙江大学 电气工程学院,浙江 杭州 310027; 2.金华电业局,浙江 金华 321000;3.湖南省电力调度通信中心,湖南 长沙 410007)
Design and implementation of general report integrated  management system for power company
WANG Guang-zeng1,2, CAO Yi-jia1, QI Jun1, JIANG Xin-fan3, ZHOU Ming-yuan3, XIE Pei-yuan3
(1.College of Electrical Engineering, Zhejiang University, Hangzhou 310027, China;
2. Jinhua Electric Power Bureau, Jinhua 321000, China;
3. Hunan Power Dispatching and Communications Center, Changsha 410007, China)
 全文: PDF(1949 KB)   HTML
摘要:

基于.Net Remoting客户端/服务器构架,通过组件对象模型与Excel软件交互,以及使用开放式数据库互联连接数据源,设计并开发了电力企业通用报表综合管理系统.在系统设计中提出按照参数、提取集、计算集分类的数据定义方法和数据集作用域概念以及数据定义与映射关系相结合的模板设计模式,设计了报表计算量平台.提出电力企业报表业务分层和报表审核的管理方法,设计了灵活的权限管理方案.该系统实现了基于多数据源的数据挖掘,解决了非技术人员定制报表的难题,实现了报表生产与报表管理的统一,保证了企业数据的安全和报表数据的质量.该系统具有通用、友好、灵活、安全等特点,已经在湖南省电力公司成功投入运行.

Abstract:

A novel general report integrated management system based on .Net Remoting client/server architecture for power company was designed and implemented. This system interacts with Excel via component object model and connects to data source via open database connectivity. Particularly, a novel data definition method which classifies data according to parameter, selection dataset and calculation dataset was proposed, as well as a concept of dataset scope and a template designing mode based on data definition and mapping relationship. Then, a platform of calculation results was designed. A flexible strategy of authority management and a management approach of report service stratification and report censorship for power company were also presented. This system can achieve multiple data sources based data-mining, to resolve the problem of customizing reports by unprofessional employees and to accomplish the combination of report production and report management, which assures the quality of data in reports and the security of company data. Characterized by generality, amity, flexibility and safeness, this system has been successfully applied in Hunan Power Company.

出版日期: 2009-11-01
:  TM 73  
基金资助:

教育部科学技术研究重大资助项目(305008);国家自然科学基金创新群体资助项目(60421002).

通讯作者: 曹一家,男,教授,博导.     E-mail: yijiacao@zju.edu.cn
作者简介: 王光增(1982-),男,山东济南人,博士,从事电力系统稳定性及信息技术在电力系统中的应用研究.
服务  
把本文推荐给朋友
加入引用管理器
E-mail Alert
RSS
作者相关文章  

引用本文:

王光增, 曹一家, 戚军, 等. 电力企业通用报表综合管理系统设计与实现[J]. J4, 2009, 43(11): 2062-2066.

WANG Guang-Ceng, CAO Yi-Jia, CU Jun, et al. Design and implementation of general report integrated  management system for power company. J4, 2009, 43(11): 2062-2066.

链接本文:

http://www.zjujournals.com/eng/CN/10.3785/j.issn.1008-973X.2009.11.022        http://www.zjujournals.com/eng/CN/Y2009/V43/I11/2062

[1] 杨争林,宋燕敏,曹荣章,等. 基于Excel的电力市场报表管理系统[J]. 电力系统自动化, 2003, 27(1): 27-30.
YANG Zheng-lin, SONG Yan-min, CAO Rong-zhang, et al. Excel based PMOS-2000 statement management system [J]. Automation of Electric Power Systems, 2003, 27(1): 27-30.
[2] 石光亮,王拓,弋长青. 电力生产信息统计报表生成器的设计与实现[J]. 电力系统自动化, 2003, 27(21): 86-88.
SHI Guang-liang, WANG Tuo, YI Chang-qing. Design and implementation of the statement generator in an electric power statistics and information system [J]. Automation of Electric Power Systems, 2003, 27(21): 86-88.
[3] 李晓明,高军,杨光糯. 异构电力信息系统柔性动态报表的设计与实现[J]. 电力系统自动化, 2003, 27(24): 56-58.
LI Xiao-ming, GAO Jun, YANG Guang-nuo. Design and implementation of the flexible and dynamic report in the heterogeneous power information system [J]. Automation of Electric Power Systems, 2003, 27(24): 56-58.
[4] 路广,王永福,张伯明,等. 基于Unix/Linux的电力市场综合报表系统[J]. 电力系统自动化, 2002, 26(14): 31-34.
LU Guang, WANG Yong-fu, ZHANG Bo-ming, et al. Unix/Linux-based integrated report system for electricity markets [J]. Automation of Electric Power Systems, 2002, 26(14): 31-34.
[5] RAMMER I, SZPUSZTA M. Advanced .NET Remoting [M]. Berkeley: Apress, 2005: 35.
[6] MCLEAN S, NAFTEL J, WILLIAMS K. Microsoft .Net Remoting [M]. Redmond: Microsoft Corporation, 2003: 1.

No related articles found!