Duplicate Record Detection via Field Clustering
Find Innovative SolutionsGenerate 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
Engineering 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
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.
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.
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
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.
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.
Data Source
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.


