Database Replication Tool for Automatic DDL Synchronization

Resolve Bottlenecks,
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 moving data between different databases.

Innovation Solution

A data replication tool that supports real-time data replication and DDL changes through an integrated API and UI, allowing for onboarding, orchestration, and real-time notifications, with a manager engine that handles multiple data instances on a single virtual machine and automatically adjusts DDLs to match the target database.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If specialized data replication tools are used to facilitate data replication between heterogeneous systems, then data replication capability is improved, but device complexity and cost increase

Engineering Contradiction:

Improvedata replication capabilityVSAvoidtool complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the data replication process into distinct modular components: an API layer for receiving requests, a manager engine for orchestrating replication, and support for multiple data instances. This modular architecture reduces overall system complexity while maintaining replication capabilities across heterogeneous systems.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The manager engine is designed to support multiple data instances on a single virtual machine instance, providing multi-functionality. This universal approach allows a single tool to handle various replication scenarios across different database systems, reducing the need for multiple specialized tools and thereby decreasing device complexity.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If specialized data replication tools are used to facilitate data replication between heterogeneous systems, then data replication capability is improved, but cost increases

Engineering Contradiction:

Improvedata replication capabilityVSAvoidimplementation cost

Core Design Contradiction:

Adaptability or versatilityVSEase of manufacture

Solution Approach 1:

The patent merges multiple replication functions into a single integrated tool that can handle multiple data instances on one virtual machine. This consolidation reduces the need for multiple separate tools and infrastructure resources, thereby lowering implementation and operational costs while maintaining comprehensive replication capability.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

By designing a universal manager engine that can replicate data across heterogeneous systems while supporting multiple data instances simultaneously, the patent reduces the total cost of ownership compared to using multiple specialized tools, each requiring separate licensing and maintenance.

Inventive Principle:

Principle #6Universality (Multi-functionality)

3Adaptability or versatility

If specialized data replication tools are used to facilitate data replication between heterogeneous systems, then data replication capability is improved, but maintenance workload increases

Engineering Contradiction:

Improvedata replication capabilityVSAvoidmaintenance workload

Core Design Contradiction:

Adaptability or versatilityVSEase of repair

Solution Approach 1:

The segmented modular architecture with distinct API and manager engine components allows for easier maintenance and updates of individual modules without affecting the entire system, reducing the maintenance workload compared to monolithic specialized tools.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The automatic DDL synchronization feature allows the system to self-adjust and maintain compatibility between source and target databases without requiring manual intervention for schema changes, significantly reducing ongoing maintenance efforts.

Inventive Principle:

Principle #25Self-service

4Adaptability or versatility

If automatic DDL synchronization is implemented, then adaptability to target database is improved, but processing time increases

Engineering Contradiction:

ImproveDDL compatibilityVSAvoidreplication setup time

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The system performs preliminary DDL analysis and synchronization during the initial replication setup phase, automatically detecting and resolving schema differences between source and target databases. This preliminary action ensures DDL compatibility is established before data replication begins, avoiding delays during ongoing operations.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS12450254B2Database data replication tool

Publication Date: 2025.10.21 ADP INC

AI summary

Data replication between databases is provided. The method comprises receiving, through an API integrated into a data replication tool, a request from a system of record (SoR) application for a replication setup and initialization. A number of data instances are imported through the API from a source database associated with the SoR. A manager engine integrated into the data replication tool initiates a separate replication process for each data instance. The manager engine is configured to support multiple data instances on a single virtual machine instance. If a difference between a data description language (DDL) of the replicated data instances and a DDL of a target database is detected, the DDL of the replicated data instances is automatically changed to the DDL of the target database. The replicated data instances are then exported to the target database.