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