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:
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.
Database migration scheme based on power plant fuel management system
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.