Data processing: database and file management or data structures – Database design – Data structure types
Patent
1995-03-30
1998-08-25
Lintz, Paul R.
Data processing: database and file management or data structures
Database design
Data structure types
707 7, G06F 1730
Patent
active
057993025
ABSTRACT:
The invention is a method for detecting duplicate records on a list or in a file and comprises a number of steps. The steps include entering a list, comprised of one or more records, to a data processing system; then, applying a nickname lookup table to the records to determine a common first name. Once a common name has been determined, the method matches a first record from the list with a second record from the list by comparing the fields of the first record with the fields of at least one other record; the comparison is based on a set of pre-determined criteria. The matching sequence determines a duplicate set, wherein the duplicate set is comprised of at least two records with fields that match. The method then lists matching records sequentially so that the system can create a new record by filling each empty field with a next available corresponding field from a subsequent record within the duplicate set. The newly created record is then retained on the original list; and the duplicate records are placed on a second list. Pre-sorting of the list can occur just prior to the matching sequence as well as just prior to outputting the final list. Additionally, the system operator can be given a number of options to provide flexibility. These options can include: manually correcting a record on the duplicate records list; deleting an address record from the list of duplicates; or, outputting the record.
REFERENCES:
patent: 4853882 (1989-08-01), Marshall
patent: 4858907 (1989-08-01), Eisner et al.
patent: 5079714 (1992-01-01), Manduley et al.
patent: 5111395 (1992-05-01), Smith et al.
patent: 5227970 (1993-07-01), Harris
patent: 5245533 (1993-09-01), Marshall
patent: 5276628 (1994-01-01), Schneiderhan
patent: 5303149 (1994-04-01), Janigian
patent: 5326181 (1994-07-01), Eisner et al.
patent: 5377120 (1994-12-01), Humes et al.
patent: 5428777 (1995-06-01), Perliski et al.
patent: 5680611 (1997-10-01), Rail et al.
Johnson Robert J.
Szturma Shawn W.
Lintz Paul R.
Pitney Bowes Inc.
Scolnick Melvin J.
Whisker Robert H.
LandOfFree
Method and system for minimizing attribute naming errors in set does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for minimizing attribute naming errors in set , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for minimizing attribute naming errors in set will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-46807