Data Migration Device Using Intermediate Table for Node Link Separation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current data migration technologies face complexity in identifying and converting data associated with specific conditions from legacy systems where node and link information are managed together, requiring cumbersome programming efforts for migration to databases with separate node and link information management.
Innovation Solution
A data migration device that extracts records from a source database, writes them to an intermediate table, separates node and link information, and registers them in a destination database with separate management, simplifying the process through an intermediate table.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If data model conversion is performed to migrate data from legacy systems where node and link information are managed together to databases with separate management, then data migration capability is improved, but process complexity and development burden increase significantly
Solution Approach 1:
The patent introduces an intermediate table as a mediator between the source database (with unified node and link information) and the destination database (with separate node and link information). The data extraction unit extracts records from the source database and writes them to the intermediate table, which then serves as a temporary storage for the separation unit to process and divide into node and link information. This intermediary structure simplifies the overall migration process by breaking down the complex conversion task into manageable stages.
Solution Approach 2:
The patent segments the data migration process into distinct functional units: a data extraction unit that handles record extraction, an intermediate table for temporary storage, and a separation unit that divides data into node and link information. This segmentation allows each unit to be developed and maintained independently, reducing the overall complexity of the migration system while improving adaptability to different database structures.
2Loss of information
If comprehensive data extraction and conversion processes are implemented to handle all data associations, then data completeness is improved, but processing time and computational resources increase
Solution Approach 1:
The patent implements a conditional extraction approach where the data extraction unit extracts records based on specific conditions (origin data as starting point, traceability through link information). Rather than extracting and converting all possible data, the system performs partial extraction focused on the most critical data associations. This reduces processing time and computational resources while maintaining data completeness for the essential data relationships.
Data Source
AI summary
A data migration device (10) extracts, from a migration source database (201) in which node information managed in a target record and link information representing a link to another record are managed together in the same table, a record that can be traced based on the link information using origin data as a starting point, and writes the record to an intermediate table (212). The data migration device (10) reads the record from the intermediate table, and separates data of the record into the node information and the link information. The data migration device (10) registers the node information and the link information that have been separated in a migration destination database (202) in which the node information and the link information are managed separately.