Data Replication Graph for Selective Database Copying
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database migration devices copy unnecessary data, leading to increased data volume and requiring re-fabrication when operation environment database specifications change, making them inefficient for continuous evaluation and analysis.
Innovation Solution
A data duplication system using a data processing graph to determine the duplication range, allowing only necessary data to be duplicated from the source to the destination system, and enabling updates to the graph to accommodate specification changes without re-fabricating the device.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the conventional database migration device copies data on and after the oldest date and time, then all input data is included in the copy, but the amount of data becomes large when the time interval of input data is sparse
Solution Approach 1:
The patent extracts only the necessary data for output analysis from the complete input data set. By using the data processing graph to trace which input data actually contributes to outputs, the system extracts only those specific data records that are needed, leaving out unnecessary data even though it falls within the time range from the oldest date and time.
Solution Approach 2:
Instead of copying all input data (excessive action), the patent applies partial action by selectively copying only the subset of input data that is actually used for generating outputs. This is achieved by analyzing the data processing graph to identify which input data records have a causal relationship with the outputs, thereby copying only that partial set rather than the entire data set.
2Ease of manufacture
If the conventional database migration device depends on the specifications of the operation environment database, then it can copy data according to those specifications, but it requires re-fabrication when the specifications change
Solution Approach 1:
The data processing graph serves as a universal representation that can adapt to different database specifications without requiring re-fabrication of the migration device. The graph structure universally captures the relationships between input data, processing operations, and outputs, allowing the system to handle various specification scenarios by simply updating the graph content rather than redesigning the entire device.
Solution Approach 2:
The patent introduces dynamics by making the data processing graph updateable and adaptable to changing specifications. Rather than a static device configuration, the graph can be dynamically modified to reflect changes in database specifications, allowing the migration device to adapt its behavior without physical re-fabrication. This dynamic characteristic enables the system to respond to specification changes by updating the graph representation.
3Loss of information
If a large amount of data is copied from the operation environment database, then all possible data for analysis is available, but the data transfer load and storage capacity requirements increase
Solution Approach 1:
The patent extracts only the necessary input data that actually contributes to outputs, thereby avoiding the transfer and storage of unnecessary data. By analyzing the data processing graph to identify which input data records are actually used in generating outputs, the system extracts only that specific subset, reducing both transfer load and storage requirements while maintaining completeness of the analyzed data.
Solution Approach 2:
Instead of copying all input data (excessive action that increases transfer load), the patent applies partial action by copying only the subset of data that is actually needed for output generation. This partial copying approach, guided by the data processing graph analysis, reduces the data transfer load and storage capacity requirements while ensuring that all necessary information for analysis is still captured.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
A data duplication device (200) determines a duplication range using a data processing graph. The data processing graph indicates information of input/output data to and from a duplicate source program involved in a duplicate source system (110). The duplication range is a range of data to duplicate from the duplicate source system to a duplicate destination system (120). The data duplication device acquires duplicate data corresponding to the duplication range from the duplicate source system. The data duplication device registers the duplicate data with the duplicate destination system.