Invention Grant
- Patent Title: Computer-based systems configured for efficient entity resolution for database merging and reconciliation
-
Application No.: US17895884Application Date: 2022-08-25
-
Publication No.: US11640416B2Publication Date: 2023-05-02
- Inventor: Xiaoyuan Zhu
- Applicant: Capital One Services, LLC
- Applicant Address: US VA McLean
- Assignee: Capital One Services, LLC
- Current Assignee: Capital One Services, LLC
- Current Assignee Address: US VA McLean
- Agency: Greenberg Traurig, LLP
- Main IPC: G06F16/29
- IPC: G06F16/29 ; G06F16/2455

Abstract:
To facilitate efficient entity resolution, systems and methods include a first dataset is received from a first database associated with a first entity and a second dataset is received from a second database associated with a second entity. A geo-grid is mapped to a geographical area covering the first entity data records and the second entity data records. A grid matching area in the geo-grid is generated for each first entity data record based on latitude data and longitude data of each first entity data record. Candidate matching records are determined from the second entity data records based on respective grid matching areas. Actual matching records are determined from the candidate matching records based on a threshold for a trigram similarity between each candidate matching record and the respective first entity data record. The actual matching records are associated with the respective first entity data record in the first database.
Public/Granted literature
Information query