Database Transfer Machine Using Fuzzy Matching for Record Synchronization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data transfer systems between databases lack efficient mechanisms for identifying and synchronizing matching records across different databases, leading to outdated information and manual data entry burdens.

Innovation Solution

A transfer machine that uses fuzzy matching techniques to identify matching records between a local and a remote database, updates records, and adds or copies records based on user authorization, ensuring data synchronization and minimizing duplicates.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual data entry and comparison methods are used to synchronize databases, then data accuracy can be maintained through human verification, but productivity is significantly reduced and time consumption increases

Engineering Contradiction:

Improvedata accuracyVSAvoiddata transfer efficiency

Core Design Contradiction:

ReliabilityVSProductivity

Solution Approach 1:

The patent introduces an automated data transfer system that acts as an intermediary between the first and second databases. This system includes a transfer machine that automatically identifies matching records using fuzzy matching algorithms, compares data fields, and transfers updated information without requiring manual human verification, thereby maintaining data accuracy while dramatically improving productivity

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent replaces the mechanical manual process of data entry and comparison with an automated computational system. The transfer machine uses software-based fuzzy matching algorithms and automated data field comparison mechanisms to perform tasks that were previously done manually, eliminating the trade-off between accuracy and productivity

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Productivity

If automated data transfer systems are implemented to improve productivity, then data transfer efficiency increases, but data accuracy may deteriorate due to lack of human verification

Engineering Contradiction:

Improvedata transfer efficiencyVSAvoiddata accuracy

Core Design Contradiction:

ProductivityVSReliability

Solution Approach 1:

The patent implements a feedback mechanism where the automated transfer machine continuously monitors and compares data fields between databases, identifies discrepancies, and can be configured to either automatically resolve them or alert users for verification. This feedback loop ensures data accuracy is maintained while preserving the productivity benefits of automation

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The transfer machine is designed to autonomously perform data matching, comparison, and transfer operations without requiring continuous human intervention. The system self-regulates by identifying matching records, determining which data fields need updating, and executing transfers automatically, thereby maintaining both high productivity and data accuracy through intelligent automation

Inventive Principle:

Principle #25Self-service

3Adaptability or versatility

If fuzzy matching techniques are used to identify matching records, then the system can handle variations in data formatting and naming conventions, but device complexity increases

Engineering Contradiction:

Improvedata format compatibilityVSAvoidsystem complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent employs fuzzy matching algorithms that work by changing and comparing multiple parameters (data fields) within records rather than requiring exact matches. The system can compare records even when formatting, naming conventions, or structural parameters differ between databases, achieving high adaptability through parameter-based comparison while managing complexity through standardized algorithms

Inventive Principle:

Principle #35Parameter changes

4Measurement precision

If comprehensive data field comparison is performed to ensure data accuracy, then measurement precision improves, but loss of time increases due to extensive processing

Engineering Contradiction:

Improvedata field comparison accuracyVSAvoidprocessing time

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The transfer machine is configured to perform comprehensive data field comparison when needed for critical records while using optimized matching algorithms for routine transfers. The system can adjust the level of comparison depth based on data importance, performing full precision comparison only when necessary, thereby balancing measurement precision with acceptable processing time

Inventive Principle:

Principle #16Partial or excessive action

Data Source

PatentUS9361350B2Data transfer between first and second databases

Publication Date: 2016.06.07 SALESFORCE INC

AI summary

To facilitate data transfer between two databases, a transfer machine accesses both databases and finds matching records. The transfer machine determines and stores a match status of a record in one database. The match status indicates whether the record corresponds to at least one of the records in the other database, and if so, which record or records in the other database correspond to the record. If the match status indicates that the record matches a record in the other database, the transfer machine determines which record is current and updates the other record. If the match status indicates that a record has no match in the other database, the transfer machine adds a copy of the record to the other database.