System for verifying high-performance table data consistency between remote DBMS tables
The purpose of the present invention is to provide a system for verifying high-performance table data consistency between remote DBMS tables, which can minimize operational service downtime by verifying data consistency within a short period of time in a table unit during migration, perform consistency verification even for data from DBMSs having different character sets, without separate processing in an operating DB, and automate a process of manually verifying the consistency of hundreds to thousands of tables. In order to achieve the above purpose, the system for verifying high-performance table data consistency between remote DBMS tables according to a first embodiment of the present invention is characterized by comprising: a source DBMS; a target DBMS of the same type as the source DBMS; and a first consistency verification tool for verifying data consistency by comparing data of the source DBMS and the target DBMS in a table unit.
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.
2. A system for verifying high-performance table data consistency between remote DBMS tables, the system comprising:
a source DBMS;
a heterogeneous 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 a source DBMS and a table of the target DBMS, respectively, and verifying data consistency,
wherein the first consistency verification unit includes a second request unit requesting extraction of table data to a table of each of the source DBMS and the target DBMS, a second storage unit being returned with and storing the table data extracted from the table of each of the source DBMS and the target DBMS, and a second computation unit computing a hash value from each table data;
wherein the system further 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 first consistency verification unit includes:
a first extraction unit extracting a computed hash value,
a second comparison verification unit comparing and verifying the hash values, and
a second output unit outputting verification data of which verification is completed, and
wherein the comparison is performed in parallel.
3. An automated method for verifying high-performance table data consistency between remote DBMS tables, the automated method comprising:
extracting table data from each of a source DBMS and a target DBMS having a different character set from the source DBMS;
storing the data with a Hexcode of the table data from each of the source DBMS and the target DBMS;
encoding the data with character sets suitable for the source DBMS and the target DBMS;
extracting a plurality of hash values from the encoded data;
comparing the plurality of hash values of the table data of the source DBMS and a table of the target DBMS, respectively; and
verifying data consistency based on a result of comparing of the plurality of hash values of the table data of the source DBMS and a table of the target DBMS, respectively.