Database Replication Engine for Automatic DDL Alignment
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data replication tools across heterogeneous systems are complex, expensive, and require continuous maintenance, complicating the process of data movement and transformation.
Innovation Solution
A data replication tool with an integrated API and manager engine supports multiple data instances on a single virtual machine, automatically adjusts data description language (DDL) differences, and exports data to a target database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If specialized data replication tools are employed to facilitate data replication between heterogeneous systems, then data replication capability is improved, but device complexity increases
Solution Approach 1:
The patent introduces a data replication tool as an intermediary component that sits between source and target databases, automatically handling the complexity of data movement, transformation, and DDL adjustments. This mediator abstracts the complexity from the user while providing robust replication capability across heterogeneous systems.
Solution Approach 2:
The replication tool performs self-service by automatically detecting DDL differences between source and target databases and adjusting them without manual intervention. The tool autonomously manages schema migrations, data type conversions, and replication configuration, eliminating the need for complex manual setup and maintenance.
2Adaptability or versatility
If specialized data replication tools are used for data movement and transformation, then data replication functionality is improved, but ease of operation deteriorates
Solution Approach 1:
The tool autonomously manages replication by automatically detecting DDL differences and adjusting schemas without manual intervention. Administration tasks such as monitoring, maintenance, and configuration adjustments are performed automatically, significantly reducing the operational burden on users.
Solution Approach 2:
The replication tool performs preliminary actions by automatically detecting and preparing DDL adjustments before data replication begins. Schema migrations and data type conversions are prepared in advance, ensuring smooth replication operations without requiring manual preconfiguration or ongoing maintenance.
3Manufacturing precision
If manual DDL adjustments are performed for data replication, then data transfer accuracy is improved, but time consumption increases
Solution Approach 1:
The tool autonomously detects DDL differences between source and target databases and automatically generates appropriate migration scripts. This self-service approach eliminates manual DDL adjustment while maintaining high accuracy through automated schema comparison and transformation.
Solution Approach 2:
The replication tool continuously monitors DDL changes in the source database and automatically adjusts the target database schema in response. This feedback mechanism ensures data transfer accuracy by keeping schemas synchronized without requiring manual intervention or time-consuming adjustments.
Data Source
AI summary
A system can include one or more processors, coupled with memory, to automatically execute a data replication tool on at least one data instance to generate at least one replicated data instance, push a status of a data instance of the at least one data instance to a data stream associated with the data replication tool, detect a difference between a first structure of a replicated data instance of the at least one replicated data instance and a second structure of a target database, identify a model configured to update the first structure of the replicated data instance to correspond to the second structure of the target database, provide the replicated data instance to the target database, and store, in a data storage, configuration information regarding a status, owner, or action associated with the target database.