主权项 |
1. A non-transitory computer-readable medium storing computer-executable instructions that when executed by a computer cause the computer to:
store, in a database, i) a plurality of old records each describing a given entity and ii) single best records (SBRs) that group the records by entity, where each respective SBR includes i) SBR data fields storing data that describe a respective unique entity and ii) an identifier for each record in the database that describes the entity; receive a set of new records for matching with the old records, where each new record includes a new record match field value in a selected record data field, and wherein each new record describes only a single entity such that each new record matches at most a single SBR; perform matching between each new record in the set of new records and the SBRs and:
when a first new record matches a first identified SBR create a first transaction to update one or more SBR data fields in the first identified SBR based on the first new record; andwhen a second new record matches a second identified SBR, create a second transaction to update one or more SBR data fields in the second identified SBR based on the second new record;when a third new record does not match any SBR:
create a first new SBR for a new entity based, at least in part, on the third new record; andcreate a first image file describing the first new SBR;when a fourth new record does not match any SBR:
create a second new SBR for a new entity based, at least in part, on the third new record; andcreate a second image file describing the second new SBR; after matching has been performed for all new records in the set of new records:
execute the first transaction and the second transaction to update the first identified SBR and the second identified SBR during a single batch update to the database; andload the first image file and the second image file into the database using a database loader. |