	US 12,265,511 B2
	Method for database-database integration
Nicholas Strange, Cary, NC (US)
Assigned to FMR LLC, Boston, MA (US)
Filed by FMR LLC, Boston, MA (US)
Filed on Jun. 14, 2023, as Appl. No. 18/209,964.
Prior Publication US 2024/0419642 A1, Dec. 19, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 16/215 (2019.01); G06F 16/23 (2019.01); G06F 16/27 (2019.01)

CPC G06F 16/215 (2019.01) [G06F 16/2365 (2019.01); G06F 16/27 (2019.01)]

17 Claims

1. A computer-implemented method for reconciling a first table in a first database provided by a first database system with a second table in a second database provided by a second database system, the method comprising:

separating, by a computing device communicatively coupled to the first database system and to the second database system, the first table into a plurality of first chunks, each first chunk including a plurality of first rows;

separating, by the computing device, the second table into a plurality of second chunks, each second chunk including a plurality of second rows, wherein each one of the plurality of second chunks corresponds to one of the plurality of first chunks;

converting, by the computing device, data values in one or more columns in the plurality of first chunks from a first data type adapted to the first database into a database-independent first data type;

converting, by the computing device, data values in one or more columns in the plurality of second chunks from a second data type adapted to the second database into a database-independent second data type; and

for each first chunk of the plurality of first chunks:

causing, by the computing device, the first database system to compute a first hash based on the first chunk;

causing, by the computing device, the second database system to compute a second hash based on a second chunk from the plurality of second chunks corresponding to the first chunk;

receiving, by the computing device, the first hash from the first database system and the second hash from the second database system;

comparing, by the computing device, the first hash with the second hash;

in response to a determination that the first hash is different from the second hash, retrieving, by the computing device, the plurality of first rows of the first chunk and the plurality of second rows of the second chunk, and comparing, by the computing device, the plurality of first rows to the plurality of second rows; and

in response to a determination that the plurality of first rows is different from the plurality of second rows, generating, by the computing device, executable code configured to reconcile the first table with the second table.