US 12,314,281 B2
System for verifying high-performance table data consistency between remote DBMS tables
Chul Kyu Sohn, Seoul (KR)
Assigned to XLOG CO., LTD., Seoul (KR)
Appl. No. 18/264,728
Filed by XLOG Co., Ltd., Seoul (KR)
PCT Filed Feb. 18, 2022, PCT No. PCT/KR2022/002457
§ 371(c)(1), (2) Date Aug. 8, 2023,
PCT Pub. No. WO2022/177368, PCT Pub. Date Aug. 25, 2022.
Claims priority of application No. 10-2021-0021684 (KR), filed on Feb. 18, 2021.
Prior Publication US 2024/0111781 A1, Apr. 4, 2024
Int. Cl. G06F 16/27 (2019.01); G06F 16/215 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 16/215 (2019.01); G06F 16/2255 (2019.01); G06F 16/2365 (2019.01)] 3 Claims
OG exemplary drawing
 
1. A system for verifying high-performance table data consistency between remote DBMS tables, the system comprising:
a source DBMS;
a homogeneous target DBMS to the source DBMS; and
a processor and a memory storing instructions that, when executed by the processor, implement a first consistency verification unit that automates comparing hash values of a table of the source DBMS and a table of the target DBMS, respectively, and verifying data consistency,
wherein the first consistency verification unit includes a first request unit requesting a query using a hash function to each of the source DBMS and the target DBMS, a first storage unit being returned with and storing hash values extracted by performing the query from the source DBMS and the target DBMS, respectively, a first comparison verification unit comparing and verifying the hash values in unit of a table, and a first output unit outputting verification data of which verification is completed, and
wherein the system includes a second source DBMS and a second target DBMS having a different character set from the second source DBMS, and a second consistency verification unit comparing hash values of a table of the second source DBMS and a table of the second target DBMS, respectively, and verifying data consistency,
wherein the comparison is performed in parallel.