System and method for data cleansing
View Patent ↗There is provided a method that includes (a) receiving an input postal address, (b) comparing the input postal address to a standard, (c) providing a single best postal address corresponding to the input postal address based on the comparing, (d) matching the single best postal address to a business in a business information database, (e) obtaining a business address for the business from the business information database, and (f) correcting the single best postal address, based on the business address, to yield a corrected postal address. There is also provided a system that performs the method, and a machine-readable medium having instructions stored thereon that cause the machine to perform the method.
1. A method performed by a processor in accordance with instructions that said processor reads from a machine-readable medium, said method comprising:
receiving an input postal address;
comparing said input postal address to a standard;
providing a single best postal address corresponding to said input postal address based on said comparing;
attempting to match said single best postal address to a business in a business information database;
if a match to a business in said business information database is found, then:
(a) obtaining a business address for said business from said business information database; and
(b) correcting said single best postal address, based on said business address, to yield a corrected postal address; and
if a match to a business in said business information database is not found, then sending said single best postal address to an investigator for further processing.
2. A system, comprising:
a processor; and
a machine-readable medium having instructions stored thereon that cause said processor to perform operations of:
a pre-auditor that generates a report having a plurality of views of an input address file, said input address file including a record having an input postal address;
a component that compares said input postal address to a file of standardized postal addresses, and provides a single best postal address derived from said input postal address, based on said comparison;
a matcher that attempts to match said single best postal address to a business in a business information database, and if a match to a business in said business information database is found, obtains a business address for said business from said business information database;
a component that corrects said single best postal address based on said business address, to yield a corrected postal address, if a match to a business in a business information database is found; and
an investigator that further processes said single best postal address, if a match to a business in said business information database is not found.
3. A machine-readable medium comprising instructions stored thereon that cause said machine to perform actions of:
receiving an input postal address;
comparing said input postal address to a standard;
providing a single best postal address corresponding to said input postal address based on said comparing;
attempting to match said single best postal address to a business in a business information database;
if a match to a business in said business information database is found, then:
(a) obtaining a business address for said business from said business information database; and
(b) correcting said single best postal address, based on said business address, to yield a corrected postal address; and
if a match to a business in said business information database is not found, then sending said single best postal address to an investigator for further processing.