Research on Compatibility and Performance Verification Method of Domestic Database for Electronic Operation and Maintenance System Migration

How to ensure seamless connection, maintain optimal stability and data consistency in the process of database replacement has become a major challenge. This paper proposes a method for verifying the compatibility and performance of domestic databases for the migration of electronic operation and maintenance systems. Based on Replay technology, through in-depth analysis of the differences between Oracle database and domestic database, a set of verification framework suitable for heterogeneous database replacement is designed. The framework includes five key steps : workload capture, environment construction, data migration, Replay execution and result analysis. It aims to comprehensively evaluate the compatibility and performance of domestic databases after replacing Oracle.The experimental results show that through Kreplay technology, after discovering and solving compatibility problems, SQL tuning and database kernel parameter tuning are performed, and the performance of KES database is significantly improved, which proves that KES database is excellent in carrying EOMS service peak workload. This study provides an efficient and reliable verification method for database migration of electronic operation and maintenance system.