System and method for cleansing, linking and appending data...

Details System and method for cleansing, linking and appending data... System and method for cleansing, linking and appending data...

2008-05-20

2008-05-20

Woo, Isaac (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07376680

ABSTRACT:
A system and method for reading a data record from an input file only once, processing that data record according to one or more reference files, and then writing out the cleansed and updated data record to a target file such that the data record is read and written to remote storage only once, thereby making a single pass through a given database of data records. Each data record (comprising of multiple data elements) of the input file is reviewed, verified, and corrected against one or more reference databases containing similar information, assigned a unique identifying key, and, optionally, appended with new additional data elements of a matching data record from a new-data database.

REFERENCES:
National Customer Support Center, “Coding Accuracy Support System (CASS) Technical Guide”, National Customer Support Center, US Postal Service, Jan. 2004, 129 pages.
Address Support Systems Department, “Address Matching Guidelines”, National Address Information Center, US Postal Service, Jul. 1992, 35 pages.
Database America Information Systems, Inc., “A User's Guide to DSF (Delivery Sequence File) Processing at Database America”,Database America Companies, Jan. 1996, 31 pages.
Database America Information Systems, Inc., “User's Guide for NCOA Processing and NCOA Nixie Processing”, Database America Companies, Jun. 1995, 21 pages.
Donnelley Marketing, “InfoConnect ONEPASS”, http://www.donnelleymarketing.com/prodserv/EnrichmentServices.htm, Donnelley Marketing, Apr. 5, 2004, 2 pages.
Donnelley Marketing, “Donnelley's MasterMatch®”, http://www.donnelleymarketing.com/prodserv/MasterMatch.htm, Donnelley Marketing, Apr. 5, 2004, 3 pages.
Donnelley Marketing, “File Hygiene”, http://www.donnelleymarketing.com/service/donnelley/file—hygenine.aspx?bas—vendor=99818, Donnelley Marketing, Nov. 2, 2006, 2 pages.
Donnelley Marketing, “Merge/Purge”, http://www.donnelleymarketing.com/service/donnelley/merge—purge.aspx?bas—vendor=99818, Donnelley Marketing, Nov. 2, 2006, 1 page.
Group 1 Software, Inc., “Consumer Merge/Purge®”, 1990, 43 pages.
Viewcentral, Inc., “Group 1 University”, https://inter.viewcentral.com/events/cust/catalog.aspx?cid=G1&pid=1, Nov. 2, 2006, 21 pages.
Group 1 Software, Inc., “Overview SearchMaster”, Nadis Family of Products, Undated, 22 pages.
Group 1 Software, Inc., “Code-1 Plus”, Product Overview, 1991-1994, 52 pages.
Grossman & Stevens, “Our Data is a Mess! How to Clean Up Your Marketing Database”, Business to Business Database Marketing, Oct. 2005, 9 pages.
Pinder & Chong, “Record Linkage for Registries: Current Approaches and Innovation Applications”, North American Association of Central Cancer Registries,Jun. 9, 2002,47 pages.
Vality Technology Inc., “Enterprise Intelligence—Enabling High Quality in the Data Warehouse/DSS Environment”, Product Brochure, Vality Technology Inc., Undated, 15 pages.
Vality Technology Inc., “Customer, Relationships and Households Derived from Account-Oriented Data”, Product Brochure, Vality Technology Inc., Undated, 12 pages.
Vality Technology Inc., “The Cost Justification for Data Re-engineering”, Product Brochure, Vality Technology Inc., Undated, 10 pages.
Vality Technology Inc., “Introduction to Integrity—Resolving Parts Description”, Product Brochure, Vality Technology Inc., Undated, 8 pages.
Vality Technology Inc., “Five Legacy Data Contaminants That You Will Encounter In Your Data Migrations”, Product Brochure, Vality Technology Inc., Undated, 8 pages.
Vality Technology Inc., “Five Common Excuses for Not Re-engineering Legacy Data”, Product Brochure, Vality Technology Inc., Undated, 6 pages.
Winkler, “Record Linkage Software and Methods for Merging Administrative Lists”, Bureau of the Census, Statistical Research Division, Jul. 23, 2001, 11 pages.

Affiliated with

Also associated with

Rating

System and method for cleansing, linking and appending data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for cleansing, linking and appending data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for cleansing, linking and appending data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2757818