登录
English 
学术文献
当期目录
过刊浏览
优先出版作者中心
投稿指南
出版道德声明无数据

登录
English 
学术文献
当期目录
过刊浏览
优先出版作者中心
投稿指南
出版道德声明无数据

1. 西安热工研究院有限公司
2. 华能铜川照金煤电有限公司
纸质出版:2024
移动端阅览
马晨曦, 陈建平, 柴硕, 等. 基于电厂燃料管理系统的数据库迁移方案[J]. 热力发电, 2024,53(11):112-118.
MA Chenxi, CHEN Jianping, CHAI Shuo, et al. Database migration scheme based on power plant fuel management system[J]. Thermal Power Generation, 2024, 53(11): 112-118.
马晨曦, 陈建平, 柴硕, 等. 基于电厂燃料管理系统的数据库迁移方案[J]. 热力发电, 2024,53(11):112-118. DOI: 10.19666/j.rlfd.202403152.
MA Chenxi, CHEN Jianping, CHAI Shuo, et al. Database migration scheme based on power plant fuel management system[J]. Thermal Power Generation, 2024, 53(11): 112-118. DOI: 10.19666/j.rlfd.202403152.
电厂燃料管理系统作为火电厂燃煤管理的核心,进行国产化替代是电站信息化建设的必经之路,数据库国产化是其中的关键。数据迁移承担了新旧系统交接的重要环节。基于对数据迁移方法的充分研究,针对电厂燃料管理系统数据特点,提出了优化的数据迁移方案。重点对校验数据一致性的方法进行了测试,分析了逐行对比和二分法2种数据校验方法的特点,发现在问题数据占比较小、分布较集中时二分法具备一定的性能优势,随着问题数据量的增加、分布的均匀化,二分法耗时显著增加。设计开发了适于电厂燃料管理系统的数据迁移工具,实现数据校验的可视化,对校验规则配置、执行方式设置、校验结果反馈等功能支持批量操作,丰富校验规则种类,支持自定义校验规则,增加校验异常处理机制等。该数据迁移工具划分为用户层、服务层和数据层,可实现电厂燃料管理系统数据迁移。
The fuel management system of power plants is the core of coal management in thermal power plants
of which domestic substitution is a necessary path for the power plant informatization
and the localization of databases is the key. Data migration plays an important role of the handover between the old system and the new one. An optimized data migration scheme is proposed based on a thorough study on data migration methods and the data characteristics of fuel management system in power plants. Focusing on the test study of methods for verifying data consistency
the characteristics of sequential comparison and dichotomy are analyzed
and it is proved that dichotomy has certain performance advantages when the proportion of corrupt data is relatively small and the distribution is concentrated. Enlarging the proportion and decentralizing the distribution
dichotomy costs more time obviously. A data migration tool for plant fuel management system is designed and implemented
which realizes visualization of data verification. The tool supports batch operations for functions like configuring verification rules
setting execution methods and providing feedback on results. It also enriches verification rules
supports customized rules and adds the mechanism for exceptions and so on. Divided into user layer
service layer and data layer
this tool achieves data migration of plant fuel management system.
0
浏览量
74
下载量
0
CSCD
关联资源
相关文章
相关作者
相关机构
京公网安备11010802024621