News Updates - DSG Updates
Global leading provider of data management software and unified application development solutions, dedicated to serving enterprise-level large data centers.
From Oracle to TDSQL: DSG accelerates the bulk migration of the Retail Core Batch Library of China Merchants Bank.
发布时间：2023.10.30

In line with the important direction of domestic substitution and independent controllable digital development, China Merchants Bank has conducted in-depth cooperation with DSG and successfully completed the migration of a retail core batch running library, taking a key step from Oracle to TDSQL.



In recent years, global trade tensions have escalated, and the demand for domestic and controllable digital construction in the financial field has become increasingly urgent. Reducing reliance on external suppliers, improving national information security, and enhancing the stability of the financial system have become the necessary path for enterprise development.

As a Chinese software company with comprehensive data management with independent intellectual property rights, Digiwise has always adhered to the concept of independent innovation. It is committed to developing globally leading information data management software products and solutions, and has become a partner in the digital transformation of many leading enterprises, jointly promoting their digital transformation development.

As one of China's leading commercial banks, China Merchants Bank has been awarded "China's Best Bank" for five consecutive years and has been listed in the Fortune Global 500 for 12 consecutive years. In recent years, China Merchants Bank has positioned itself as a "fintech bank" and continuously explores the path of digital transformation by introducing advanced technology and innovative thinking.

With the continuous development and expansion of China Merchants Bank's business, domestic substitution and independent controllability have become the core direction of its current digital development. As the cornerstone of storing data and supporting business operations, databases are facing the challenge of updating and upgrading.

Basic information on migration

The retail core batch library of China Merchants Bank has a total of 64 sub-libraries and 1 grey library. Except for the grey library, which is relatively small, each sub-library is approximately 1TB in size.



Requirements for migration synchronization

  1. Does not affect the production business system, including initialization;
  2. The migration tool has a fast comparison function, which can meet the switching time window on the same evening within half an hour;
  3. The business is migrated from the Oracle database to the TDSQL database, and after the switch, it needs to be synchronously synchronized back to the Oracle database from the TDSQL database;
  4. The migration tool has platform management capabilities and SDK interface functions, which can meet the integration of third-party platforms;
  5. The migration tool has alarm docking function, monitoring synchronization status, delay, and other automatic functions;
  6. The migration tool has an interface function for batch deployment, which can deploy and switch migration capabilities in batches.


CMB migration platform interface diagram



Customer of China Merchants Bank can customize interface development and use SDK to call the underlying DSG synchronous tools.。



Migration architecture






Deployment Instructions

For this database migration, a high availability (HA) solution is utilized through the use of an intermediate machine. The migration tool, comparison program, and SDK interface are all deployed. The business will be migrated from the Oracle database to the TDSQL database. After the migration is completed, data will need to be synchronized back from the TDSQL database to the Oracle database. The forward link source will synchronize data from the ADG standby database, while the reverse link will write directly to the production master database. During the migration process, strict control over data quality is maintained to ensure the integrity and accuracy of the data.


Architecture description

  1. There are 64 sub-databases in the Oracle source, which need to be migrated and synchronized to 64 shards in TDSQL.

  2. According to the distribution of tables, two channels are allocated for synchronization for each sub-database, and three comparison channels are allocated for comparison according to different comparison strategies for each sub-database.

    3.Providing automated operation and maintenance sh script (Dsgadm) for monitoring, and integrating with the SMS alarm platform.


During the period, the data migration work proceeded day and night, with 3-4 databases being fully synchronized in a single day and 8-12 databases being switched on the same night. To ensure data consistency, a method of full table content comparison was used during the day, completing the comparison of a large table with a scale of 1 billion within just 2 hours. And on the night of the switch, a partition comparison method was used to ensure the switch was completed within 20 minutes, with impressive and reliable performance data.

In the end, with the joint efforts of all project personnel, this domestic database migration also came to a successful conclusion.

This successful cooperation not only provided strong support for the digital transformation of China Merchants Bank, but also validated the wide application of innovative achievements in domestic independent database technology in the banking sector, marking an important milestone in the development of DSG technology. It is of great significance for improving the level of data management services, ensuring data security and stability, and promoting independent and controllable data in the field.

热门动态
警告弹窗