Virtual Entry Table for Legacy Code Migration

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Migrating data between systems is complex due to differences in processing codes, requiring manual matching which is prone to errors and reduces customer satisfaction.

Innovation Solution

A system and method that uses a virtual entry table to map legacy processing codes to target processing codes, employing techniques like tokenization, lemmatization, normalization, and distance control to improve matching reliability across platforms.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If manual matching of processing codes is used during data migration, then flexibility in handling different code systems is maintained, but accuracy and reliability of code matching deteriorate due to human errors

Engineering Contradiction:

ImproveFlexibility in handling code systemsVSAvoidAccuracy of code matching

Core Design Contradiction:

Ease of operationVSReliability

Solution Approach 1:

The patent introduces a virtual code as an intermediary element between legacy processing codes and target processing codes. The virtual code serves as a mediator that enables automatic matching through virtual entry tables, eliminating manual intervention while maintaining high accuracy. The virtual code acts as a bridge that connects different code systems without requiring direct mapping between them.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent creates virtual copies of processing codes in the form of virtual codes that represent legacy codes in the new system. These virtual codes are stored in virtual entry tables and serve as accurate replicas that enable automatic matching. The copying approach allows the system to reference standardized virtual codes rather than manually interpreting legacy codes.

Inventive Principle:

Principle #26Copying

2Extent of automation

If full string matching or fuzzy matching algorithms are used to link processing codes, then automation of the migration process is improved, but matching accuracy deteriorates when semantic meaning differs from text similarity

Engineering Contradiction:

ImproveAutomation of code matchingVSAvoidSemantic matching accuracy

Core Design Contradiction:

Extent of automationVSMeasurement precision

Solution Approach 1:

The virtual code serves as a semantic intermediary that preserves the true meaning of legacy codes. Rather than relying on text similarity algorithms that may incorrectly match codes with different meanings, the virtual code explicitly represents the semantic equivalence between legacy and target codes, enabling accurate automated matching.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent transforms the matching problem from text-based similarity comparison to parameter-based exact matching. By converting legacy codes into virtual codes with standardized parameters in virtual entry tables, the system changes the matching criterion from fuzzy text comparison to precise parameter matching, thereby improving semantic accuracy.

Inventive Principle:

Principle #35Parameter changes

3Reliability

If manual selection and matching of processing codes is performed, then understanding and control over code mapping is maintained, but productivity and migration efficiency deteriorate

Engineering Contradiction:

ImproveControl over code mappingVSAvoidMigration efficiency

Core Design Contradiction:

ReliabilityVSProductivity

Solution Approach 1:

The patent creates virtual copies of code mapping relationships in the form of virtual entry tables. These tables contain pre-defined virtual codes that represent the mapping between legacy and target codes, allowing automated reproduction of accurate mappings without manual intervention for each code pair, thereby dramatically improving productivity while maintaining control.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The system performs preliminary action by pre-establishing virtual codes and virtual entry tables that encode the mapping relationships between legacy and target processing codes. This preliminary setup enables subsequent automated migrations to proceed efficiently without requiring manual code matching during each migration operation, while still maintaining accuracy through the pre-validated virtual code relationships.

Inventive Principle:

Principle #10Preliminary action

4Reliability

If virtual codes from virtual entry tables are used to map legacy processing codes, then matching accuracy and automation are improved, but system complexity increases due to the additional mapping layer

Engineering Contradiction:

ImproveMatching accuracyVSAvoidSystem architecture complexity

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The virtual code serves multiple functions: it acts as a representation of legacy codes, a key in virtual entry tables, a mapping intermediary, and a standardized reference in the target system. This multi-functionality justifies the additional layer by demonstrating that the virtual code infrastructure provides multiple benefits beyond simple code translation, including standardization, automation, and accuracy.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS20220374248A1Systems and methods of migrating client information

Publication Date: 2022.11.24 ADP INC

AI summary

The present disclosure relates to linking processing codes between platforms, and more particularly, to automatically record linking processing codes between platforms and methods of use. The method includes: obtaining a legacy processing code from a legacy system; obtaining a virtual code from a virtual entry table (VET) which corresponds with the legacy processing code; and mapping the legacy processing code to a target processing code using the virtual code from the VET.