电力企业通用报表综合管理系统设计与实现

Design and implementation of general report integrated management system for power company

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

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.