火力发电企业燃料信息报表自定义系统  

User-Defined System of Fuel Information Report in Coal-Fired Power Generation Enterprise

作　　者：闫冬 张晖 余军[3] 何云峰[3] 于俊清[3] 唐九飞[3] 

机构地区：[1]中国电建集团湖北工程有限公司,湖北武汉430070 [2]国电汉川发电有限公司,湖北汉川431614 [3]华中科技大学网络与计算中心,湖北武汉430074

出　　处：《电力信息与通信技术》2017年第4期47-53,共7页Electric Power Information and Communication Technology

基　　金：国家自然科学基金项目(61202300)

摘　　要：报表管理是发电企业燃料信息系统中的重要功能,现有系统所采用的静态报表具有流程繁杂、开发困难、难以维护等缺点。通过分析燃料报表的特点及报表软件的国内外研究现状,发现中英文映射和多表关联是自定义燃料报表的关键。针对燃料报表采用拼音首字母缩写这种"英文字段"形式来存储信息的情况,提出建立"英文字段"到"中文含义"的映射。多表关联主要涉及表关联关系的存储和连接条件的生成,针对燃料报表数据表关联复杂的特性,在"最小生成树"的基础上提出基于普里姆的"最大生成树"算法,该算法为关联设置对应的权值,得到权重之和最大的生成树,也就是多表查询的连接条件。实验结果表明,文章提出的方法能够有效解决多表查询关联条件的自动生成,具有较高的效率,已经成功应用在实际的燃料信息管理系统中。Report management is an important function in fuel information system of power generation enterprise. However, static report in existed fuel information management system is complex and difficult to be developed and maintained. Based on the analysis of the fuel report characteristics and the current research status of report software in China and abroad, it is concluded that the mapping from English to Chinese and the multi-table relevance are the key issues for user-defined fuel report. According to the situation that information in the fuel report is stored in the form of the acronym of the first letter pinyin, we proposed the mapping from English to Chinese. Multi-table relevance is mainly related to the storage and connection condition generation of table relation. For the complex characteristics of the fuel report relevance, we propose a Prim Maximum Spanning Tree algorithm based on the concept of the Minimum Spanning Tree. The algorithm sets the weights corresponding to the association set, and gets the maximal spanning tree of weights, which is the connection condition of multi table queries. Experimental results show that the method proposed in this paper can effectively solve the multi table query association conditions automatically generation with high efficiency, and has been successfully applied in the actual fuel information management system.

关 键 词：中英文映射 多表关联 最小生成树 普里姆算法 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]