Duplicate Record Detection via Field Clustering

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing methods for detecting and removing duplicate records in databases are computationally intensive and inefficient, as they treat fields independently, failing to account for dependencies between fields such as state, zip code, and phone area code.

Innovation Solution

A method and system that standardize data using a field-specific knowledge base, extract and transform related fields, generate record-level keys, cluster records, and calculate matching percentages to identify and remove duplicates, utilizing matching attribute functions like N-Gram, Spell, Sound, and Alias to handle field dependencies.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If brute force approach is used to compare each record with every other record, then duplicate detection completeness is improved, but computational intensity increases significantly

Engineering Contradiction:
Improveduplicate detection completenessVSAvoidcomputational intensity
Core Design Contradiction:
Measurement precisionVSUse of energy by moving object

Solution Approach 1:

The patent segments the duplicate detection process into multiple stages: first grouping records by clustering algorithm (which divides the large dataset into smaller clusters), then performing detailed comparison only within clusters. This segmentation reduces the overall computational complexity from O(n²) brute force to approximately O(n log n) or better, while maintaining detection completeness.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent applies preliminary clustering action before detailed duplicate comparison. By pre-grouping records into clusters based on similarity metrics (using algorithms like k-means or hierarchical clustering), the system performs preliminary sorting and organization that eliminates the need for exhaustive pairwise comparisons, thereby reducing computational intensity while preserving detection accuracy.

Inventive Principle:
Principle #10Preliminary action

2Ease of operation

If fields are treated independently for duplicate detection, then processing simplicity is improved, but detection accuracy deteriorates due to ignored field dependencies

Engineering Contradiction:
Improveprocessing simplicityVSAvoidduplicate detection accuracy
Core Design Contradiction:
Ease of operationVSMeasurement precision

Solution Approach 1:

The patent merges the treatment of dependent fields by considering them together during clustering. Instead of processing fields independently, the system combines multiple fields (name, address, phone, etc.) into a unified clustering process that accounts for their interdependencies, thereby improving detection accuracy while maintaining reasonable processing simplicity through automated multi-field evaluation.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The patent changes the approach from independent field processing to integrated record processing by modifying the clustering parameters to consider field relationships. The system adjusts clustering parameters and similarity metrics to reflect real-world dependencies between fields, enabling accurate duplicate detection without complex manual processing.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS8838549B2Detecting duplicate records
Publication Date: 2014.09.16 EGRABBER INC
  • US8838549B2 patent drawing
  • US8838549B2 patent drawing
  • US8838549B2 patent drawing

AI summary

A method for finding duplicates by matching group of fields in records is disclosed. The method comprises standardizing data using field specific knowledge base; extracting at least part of one or more related fields of records; applying a matching attribute function to generate keys on the “comparable” field part extracted data; generating record level keys using generated field level keys; clustering the records based on generated record level keys; identifying reference record for each cluster identified; and calculating matching percentage for each record in a cluster with respect to reference record of the cluster. Devices and systems are disclosed that enable the method for finding duplicates.