Computer-based systems configured for efficient entity resolution for database merging and reconciliation

A method comprising:

• receiving, by at least one processor, at least one first dataset from a first database associated with a first entity;
• wherein the at least one first dataset comprises a plurality of first entity data records;
• wherein each of the first entity data records comprises:
• i) first latitude data representing at least one first latitude associated with at least one first physical location at which each of the first entity data records has been generated, and
• ii) first longitude data representing at least one first longitude associated with the at least one first physical location at which each of the first entity data records has been generated;
• receiving, by the at least one processor, at least one second dataset from an at least one second database associated with at least one second entity;
• wherein the at least one second dataset comprises a plurality of second entity data records;
• i) at least one second latitude data representing at least one second latitude associated with at least one second physical location at which each of the at least one second entity data records has been generated, and
• ii) at least one second longitude data representing at least one second longitude associated with the at least one second physical location at which each of the at least one second entity data records has been generated;
• generating, by the at least one processor, at least one geo-grid mapped to at least one geographical area covering the plurality of first entity data records and the plurality of at one second entity data records;
• wherein the at least one geo-grid comprises a plurality of respective grid spaces representing a plurality of respective geographical sub-areas;
• wherein the plurality of respective grid spaces are defined by respective latitudinal widths and respective longitudinal heights;
• wherein each pair of a respective latitudinal width and a respective longitudinal height are based on a predetermined distance threshold between a plurality of candidate matching records of the plurality of first entity data record and the plurality of second entity data records;
• generating, by the at least one processor, at least one respective grid matching area in the at least one geo-grid;
• wherein the respective grid matching area comprises:
• i) a central grid space of the grid spaces in the geo-grid, and
• ii) a plurality of neighboring grid spaces that neighbor the central grid space in the at least one geo-grid;
• determining, by the at least one processor, a plurality of matching first entity data records of the plurality of first entity data records based on the at least one respective grid matching area;
• wherein the plurality of matching first entity data records are record that have respective latitudes and respective longitudes that match the at least one respective grid matching area;
• determining, by the at least one processor, a plurality of matching second entity data records of the plurality of second entity data records based on the at least one respective grid matching area;
• wherein the plurality of matching second entity data records are record that have respective latitudes and respective longitudes that match the at least one respective grid matching area;
• determining, by the at least one processor, a plurality of actual matching records from the plurality of matching second entity data records based on a predetermined threshold for a trigram similarity between each matching second entity data record of the plurality of matching second entity data records and each matching first entity data record of the plurality of matching first entity data records;
• extracting, by the at least one processor, the plurality of actual matching records from the at least one second dataset;
• storing, by the at least one processor, the plurality of actual matching records in the first database;
• and
• associating, by the at least one processor, the plurality of actual matching records in the first database with the at least one respective first entity data records.

A system comprising:

• a first entity database configured to store at least one first dataset associated with at least one first entity;
• wherein the first dataset comprises a plurality of first entity data records;
• wherein each of the at least one first entity data records comprises:
• i) first latitude data representing at least one first latitude associated with at least one first physical location at which each of the first entity data records has been generated, and
• ii) first longitude data representing at least one first longitude associated with the at least one first physical location at which each of the first entity data records has been generated;
• at least one second entity database configured to store at least one second dataset associated with at least one second entity;
• wherein the at least one second dataset comprises a plurality of at least one second entity data records;
• i) at least one second latitude data representing at least one second latitude associated with at least one second physical location at which each of the at least one second entity data records has been generated, and
• ii) at least one second longitude data representing at least one second longitude associated with the at least one second physical location at which each of the at least one second entity data records has been generated;
• at least one processor configured to perform computer-readable instructions comprising:
• receiving the at least one first dataset from the first database associated with a first entity;
• receiving the at least one second dataset from the at least one second database associated with at least one second entity;
• generating at least one geo-grid mapped to at least one geographical area covering the plurality of first entity data records and the plurality of second entity data records;
• wherein the at least one geo-grid comprises a plurality of respective grid spaces representing a plurality of respective geographical sub-areas;
• wherein the plurality of respective grid spaces are defined by respective latitudinal widths and respective longitudinal heights;
• wherein each pair of a respective latitudinal width and a respective longitudinal height is based on a predetermined distance threshold between a plurality of candidate matching records of the plurality of first entity data records and the plurality of second entity data records;
• generating at least one respective grid matching area in the at least one geo-grid for at least one respective first entity data record based at least in part on the first latitude data and the first longitude data of the at least one respective first entity data record;
• wherein the at least one respective grid matching area for the at least one respective first entity data record comprises:
• i) a first entity data record grid space of the plurality of respective grid spaces in the at least one geo-grid, wherein the first entity data record grid space is associated with a respective pair of the respective latitude and the respective longitude for each respective first entity data records, and
• ii) a plurality of neighboring grid spaces that neighbor the first entity data record grid space in the at least one geo-grid;
• determining plurality of candidate matching records from the plurality of second entity data records that potentially matches to the plurality of first entity data records and the plurality of second entity data records based on the at least one respective grid matching area;
• wherein the plurality of candidate matching records are records that have respective latitudes and respective longitudes match the at least one respective grid matching area;
• determining a plurality of actual matching records from the candidate matching records based on a predetermined threshold for a trigram similarity between each candidate matching record of the plurality of candidate matching records and the at least one respective first entity data record;
• extracting the plurality of actual matching records from the at least one second dataset;
• storing the plurality of actual matching records in the first database;
• and
• associating the plurality of actual matching records in the first database with the at least one respective first entity data record.