US 12,229,129 B1
Database management of householding data using group surrogate keys
Jonathan R. Kappler, Hamel, MN (US)
Assigned to Wells Fargo Bank, N.A., San Francisco, CA (US)
Filed by Wells Fargo Bank, N.A., San Francisco, CA (US)
Filed on Sep. 27, 2023, as Appl. No. 18/476,021.
Int. Cl. G06F 16/2453 (2019.01); G06F 16/2458 (2019.01)
CPC G06F 16/24537 (2019.01) [G06F 16/2468 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
executing, using a processing unit, a data join operation between entries in a rehouseholding database table and a standardized address database table to generate a rehousehold address table, the rehousehold address table including a first set of address columns;
accessing, using the processing unit, an address database table, the address database table including a second set of address columns;
executing, using the processing unit, a fuzzy match search between entries in the rehousehold address table and entries in the address database table using values in the first set of address columns and second set of address columns;
receiving a match result from the executing;
calculating, using the processing unit, a quality score for the match result;
determining the quality score of the match result exceeds a quality match threshold; and
in response to the determining, updating a household identifier value of an entry in an account cross-reference database table for an account identifier and address surrogate key associated with the match result.