Database Table Format Conversion with Append Data Preservation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data migration tools often lose or fail to convert custom or append data when transitioning from one software application to another, especially when the new format does not support table appends, leading to time-consuming manual interventions and potential data loss.
Innovation Solution
A method is introduced to convert tables with primary and append data from a first format to a second format by creating temporary runtime and data dictionary entries, copying data to new tables, and using JOIN views to ensure seamless data access, thereby preserving custom data and reducing manual intervention.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If general-purpose migration tools are used to convert data between formats, then conversion speed is improved, but custom or append data is lost or not converted
Solution Approach 1:
The patent segments the data structure into primary table data and append table data, treating them as separate entities that can be converted independently. The system identifies and extracts custom append data from the source format, converts it separately, and then integrates it into the target format, preventing data loss while maintaining conversion efficiency
Solution Approach 2:
The patent introduces an intermediary conversion process that acts as a mediator between the source and target formats. This intermediary layer identifies custom append data, transforms it into the target format's structure, and then integrates it, allowing general-purpose tools to handle standard data while custom data receives specialized processing
2Reliability
If manual conversion methods are used to preserve custom data, then data accuracy is improved, but conversion time increases significantly
Solution Approach 1:
The patent implements self-service functionality where the conversion system automatically identifies, extracts, and converts custom append data without requiring manual intervention. The system autonomously detects custom data structures, applies appropriate conversion rules, and integrates the converted data, maintaining high accuracy while eliminating time-consuming manual processes
Solution Approach 2:
The patent performs preliminary identification and classification of custom append data before the main conversion process. By pre-processing the data to mark and categorize custom elements, the system prepares the data for automatic conversion, ensuring accuracy is maintained while reducing the time required during the actual conversion phase
3Adaptability or versatility
If new software applications are adapted to work with non-native data formats, then compatibility is improved, but system complexity increases
Solution Approach 1:
Instead of adapting the new software application to work with non-native data formats, the patent inverts the approach by converting the data to the native format of the new application. This reversal simplifies the system architecture by eliminating the need for the application to handle multiple formats, reducing complexity while maintaining compatibility
Data Source
AI summary
Techniques and solutions are described for facilitating the conversion of tables, having primary data and an append specifying a format of append data, from a first format to a second format. A runtime object and a data dictionary entry can be created for a primary table in the second format, and at least a portion of primary data transferred to the primary table in the second format. A database layer object corresponding to the first table in the first format can be associated with a temporary runtime object and a temporary data dictionary entry so that append data can be transferred to an append table in the second format. Operations directed to the primary table in the second format can be modified to also be directed to the append table, such as using a JOIN view.