基于电厂燃料管理系统的数据库迁移方案

Database migration scheme based on power plant fuel management system

电厂燃料管理系统作为火电厂燃煤管理的核心,进行国产化替代是电站信息化建设的必经之路,数据库国产化是其中的关键。数据迁移承担了新旧系统交接的重要环节。基于对数据迁移方法的充分研究,针对电厂燃料管理系统数据特点,提出了优化的数据迁移方案。重点对校验数据一致性的方法进行了测试,分析了逐行对比和二分法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.This paper proposes an optimized data migration scheme based on a thorough study of 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.We design and implement a data migration tool for plant fuel management system,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.