A system and method for fast and automatic data migration of multi-source heterogeneous databases

By building data migration Pipeline task flow and task scheduling tools in a multi-source heterogeneous database system, rapid automatic data migration between heterogeneous databases is realized, and the complexity and insufficient monitoring of manual development configuration files in the existing technology are solved. Problem, improving data migration efficiency and reliability.

CN114741375BActive Publication Date: 2024-12-24JIANGSU UNITED CREDIT REFERENCE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202210541924.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-05-18
Publication Date
2024-12-24
Estimated Expiration
2042-05-18

AI Technical Summary

Technical Problem

The prior art requires a large number of manual development configuration files during the data migration between heterogeneous databases, and it is impossible to realize timed scheduling and task monitoring, which increases the development cost and the possibility of errors, especially when the data volume is large.

Method used

Design a multi-source heterogeneous database fast automatic data migration system. By building a data migration Pipeline task flow, automatically converting the source database tables, and integrating task scheduling tools to realize the rapid automatic generation and automatic scheduling and execution of data migration tasks, supporting Automatic check and failure alarm.

Benefits of technology

It realizes rapid automatic data migration between multiple databases, reduces development costs, improves data migration efficiency, reduces human resource investment, and enhances the reliability and maintainability of migration tasks.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114741375B_ABST
    Figure CN114741375B_ABST
Patent Text Reader

Abstract

The present invention provides a system and method for fast and automatic data migration of multi-source heterogeneous databases. By integrating data migration tools and task scheduling platforms, data migration tasks are quickly and automatically generated and automatically scheduled for execution. The execution results support automatic inspection, and failed tasks are automatically warned via email or instant messaging. The present invention can support the conversion of multiple different types of databases, and supports the expansion of new databases. In the scenario of migrating a large number of data tables between heterogeneous databases, the present invention can enable developers to quickly implement data migration in a low-code manner, which reduces the technical threshold for developers, improves the efficiency of data migration, saves R&D labor costs, and enhances the reliability and maintainability of data migration.
Need to check novelty before this filing date? Find Prior Art