Remote CDC Control via Dynamic UDF Installation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current change data capture systems require extensive user intervention and resource allocation at both source and target systems, leading to inefficiencies and increased complexity in managing data changes between relational systems.
Innovation Solution
A control system that dynamically installs User-Defined Functions (UDF) in both source and target computing systems to coordinate agents for change data capture, minimizing pre-installations and configurations by using predefined interfaces and SQL commands to manage the propagation of changes, thereby centralizing computing efforts and reducing resource usage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If CDC systems use predefined agents at both source and target systems, then data change propagation can be achieved, but user intervention and configuration complexity increase
Solution Approach 1:
The patent introduces a control system as an intermediary that centrally manages CDC operations. Instead of requiring configuration at both source and target systems, the control system installs UDF functions and coordinates agents remotely, simplifying the configuration process while maintaining reliable data change propagation.
Solution Approach 2:
The system uses self-service mechanisms where UDF functions automatically perform configuration tasks. The control system dynamically installs UDF functions that enable agents to self-configure and self-manage, reducing the need for manual user intervention while ensuring proper data change propagation.
2Productivity
If CDC systems require pre-installation and configuration at source and target systems, then data capture can be performed, but resource usage and installation time increase
Solution Approach 1:
The control system performs preliminary actions by dynamically installing UDF functions before CDC operations begin. This preliminary setup is done centrally and automatically, eliminating the need for time-consuming manual pre-installation and configuration at both source and target systems, while ensuring data capture capability is properly established.
Solution Approach 2:
The patent replaces manual mechanical configuration processes with automated software-based UDF function installation. The control system uses automated mechanisms to install and configure CDC components, substituting time-consuming manual operations with efficient automated processes that reduce installation time while maintaining data capture functionality.
3Ease of operation
If extensive user intervention is used for CDC system configuration, then system control is improved, but operational efficiency decreases
Solution Approach 1:
The system implements self-service through UDF functions that automatically perform configuration and management tasks. The control system provides ease of operation by allowing centralized control, while the automated UDF functions handle execution, eliminating the need for extensive manual user intervention and thereby improving operational efficiency.
Solution Approach 2:
The control system uses feedback mechanisms where UDF functions report status and the control system adjusts configuration automatically. This feedback loop maintains easy system control while reducing manual intervention, as the system self-adjusts based on feedback, thereby improving operational efficiency without sacrificing control capability.
Data Source
AI summary
The present disclosure relates to a control system for remotely controlling a change data capture (CDC) system. The CDC system comprises a source computing system and target computing system. The target computing system is configured to store a copy of data of the source computing system. The source computing system and the target computing system are configured to execute coordinated actions using predefined agents in order identify a change to data of the source computing system and to propagate, and store the change to the target computing system. The control system is configured for dynamically installing User-Defined Functions, UDF functions, in the source and target systems in order to control the agents to perform the predefined actions.