Method for migrating electric power data from MySQL to domestic database

• Main Authors: WANG JIEFENG, WU ZHONG, KANEWAKI, WANG CE, LONG YUJIANG, LONG NA, LI XUN, GAN RUNDONG, WEI WEI
• Format: Patent
• Language: Chinese; English
• Published: 10.11.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR

The invention discloses a method for migrating electric power data from MySQL to a domestic database. The method comprises the following steps: carrying out data deduplication and simplification; migrating the data subjected to the duplicate removal and simplification processing from the MySQL to an OceanBase database; performing grammar compatibility check and feasibility evaluation of migration; configuring and verifying a migration scheme; data migration: after the data migration from the MySQL to the OceanBase is triggered, the DDL operation is forbidden in the source MySQL; and data consistency verification: after the data is synchronized to the OceanBase from the MySQL, verifying the consistency. According to the method, data is migrated from a traditional non-distributed database to a distributed database, management of larger-scale data is facilitated, expansion of the database is facilitated, and repeated and low-value non-structured data is removed and simplified in the data migration process. 本发明公开