Database reconciliation method and system
US6496838B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 31, 1999 |
| Grant date | Dec 17, 2002 |
| Priority date | — |
| Expiry date | Dec 31, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The present invention discloses a method and system for use in reconciling a first record, which may be selected from a plurality of first records, with a matching record included in a plurality of second records. The first records may comprise a first database and the second records may comprise a second database, or the first records and second records may comprise separate tables within the same database. A search of the second records for records possibly matching the first record is performed. The search may be performed by comparing data within progressively smaller sets of query fields comprised of data fields of the first record to data within corresponding progressively smaller sets of search fields comprised of data fields of the second records. For each pair of query and search field sets, the search generates a set of suggested matching records, which may be empty. The first record and the sets of suggested matching records are then displayed together on a first interface. With the first record and suggested matching records thus displayed, the suggested matching records may be easily reviewed and compared with the first record to determine if any of the suggested recor…
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.