Machine-learning based record processing systems
AssigneeCapital One Services, LLC
InventorsGunther Havel, John Wilson, Ashwin Assysh Sharma
Life of this patent
Estimating the term…
Abstract
Aspects described herein may allow unmatched records in databases be matched automatically. For example, a computing device may receive source records and target records to be matched together. The computing device may determine, based on a machine learning model and for each of the plurality of target records, a distance value between the respective target record, and a subset of the plurality of source records. A matched record that identifies the subset of the plurality of source records and a selected one or more target records may be generated. The matched record may be configured to update records in a database.
Claims20
A method comprising:
- receiving, by a computing device from a cloud storage device, a trigger command indicating a threshold is satisfied by a quantity of records that have been uploaded from a first database;
- receiving, by the computing device based on the trigger command, the uploaded records comprising a plurality of source records, from a first database, and a plurality of target records from a second database, wherein the first database is configured to store records of a different format from records in the second database;
- inputting, based on the trigger command and into a machine learning model, the plurality of source records and the plurality of target records;
- receiving, as output from the machine learning model, a selection of a subset of the plurality of source records and a subset of the plurality of target records, wherein the selection is based on:
- determining, for each of the plurality of target records, a distance value between:
- the respective target record, and
- the subset of the plurality of source records;
- ranking, based on the distance value of each of the plurality of target records, the plurality of target records;
- selecting, based on the ranking, the subset of target records of the plurality of target records;
- generating a matched record that indicates a matching between:
- the selected s subset of the plurality of target records, and
- the selected subset of the plurality of source records;
- sending, to the first database, the matched record;
- and
- updating, based on the matched record, the first database by changing a status of the subset of the plurality of source records from unmatched to matched.
A system comprising:
- a computing device, and
- a first database;
- wherein the computing device comprising:
- one or more processors;
- instructions, when executed by the one or more processors, cause the computing device to:
- receive, from a cloud storage device, a trigger command indicating a threshold is satisfied by a quantity of records that have been uploaded from a first database;
- receive, based on the trigger command, the uploaded records comprising, a plurality of source records, from a first database, and a plurality of target records from a second database, wherein the first database is configured to store records of a different format from records in the second database;
- input, based on the trigger command and into a machine learning model, the plurality of source records and the plurality of target records;
- receive, as output from the machine learning model, a selection of a subset of the plurality of source records and a subset of the plurality of target records, wherein the selection is based on:
- determine, for each of the plurality of target records, a distance value between:
- the respective target record, and
- the subset of the plurality of source records;
- rank, based on the distance value of each of the plurality of target records, the plurality of target records;
- select, based on the ranking, the subset of the plurality of target records;
- generate a matched record that indicates a matching between:
- the selected subset of the plurality of target records, and
- the selected subset of the plurality of source records;
- send, to the first database, the matched record;
- and
- update, based on the matched record, the first database by changing a status of the subset of the plurality of source records from unmatched to matched;
- and
- wherein the first database is configured to receive, from the computing device, the matched record.
A non-transitory computer-readable medium storing computer instruction that, when executed by one or more processors, cause performance of actions comprising:
- receiving, by a computing device, from a cloud storage device, a trigger command indicating a threshold is satisfied by a quantity of records that have been uploaded from a first database;
- receiving, by the computing device based on the trigger command, the uploaded records comprising a plurality of source records, from a first database, and a plurality of target records from a second database, wherein the first database is configured to store records of a different format from records in the second database;
- inputting, based on the trigger command and into a machine learning model, the plurality of source records and the plurality of target records;
- receiving, as output from the machine learning model and based on a clustering algorithm, a selection of a subset of the plurality of source records and a subset of the plurality of target records, wherein the selection is based on:
- determining a distance value between each two source records of the subset does not exceed a threshold;
- determining, based on a second machine learning model and for each of the plurality of target records, a distance value between:
- the respective target record, and
- the subset of the plurality of source records;
- ranking, based on the distance value of each of the plurality of target records, the plurality of target records;
- selecting, based on the ranking, the subset of the plurality of target records;
- generating a matched record that indicates a matching between:
- the selected subset of the plurality of target records, and
- the selected subset of the plurality of source records;
- sending, to the first database, the matched record;
- and
- updating, based on the matched record, the first database by changing a status of the subset of the plurality of source records from unmatched to matched.
Dependencies are inferred from the claim text.