A database table difference comparison method and device
A technology of difference comparison and database, which is applied in the direction of database indexing, redundancy in calculation, data error detection, structured data retrieval, etc., and can solve problems such as memory explosion
Active Publication Date: 2022-04-22
INFORMATION2 SOFTWARE SHANGHAI
View PDF6 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] In order to overcome the deficiencies in the above-mentioned prior art, the purpose of the present invention is to provide a database table difference comparison method and device, to temporarily save a part of the data in a file when the amount of accumulated data is too large during the database table comparison, and When the difference data is too large, stop the table comparison and return the current result, so as to avoid the problem of bursting the memory
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment
[0063] In an embodiment of the present invention, the database table is carried out in the standby node program, when the data row comparison is performed in the standby node program, the standby node program is provided with a two-dimensional integer array, the array is used to record the number of data rows that have not been matched, and the matching failure of the source and the standby, regardless of whether the row passed over at this time is the source data or the backup data, if there is no matching corresponding data, that is, MD5 is not the same, then the number of data lines corresponding to the data will be increased by 1.
[0064] In addition to recording the number of rows on the source and standby sides when comparing database tables, the data sent by the source and the data sent by the standby are also stored in a two-dimensional hash array. Because there are 256 kinds of values for each row data MD5, using the key function to encrypt the MD5 represented by the row...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a database table difference comparison method and device. The method includes the following steps: step S1, receiving the encrypted database table data of the source end and the backup end, performing data line comparison, and matching the unmatched and The data of the source and standby database tables that failed to match are cached in the cache set, and the number of unmatched data rows is recorded; step S2, after a certain batch of data is compared, it is judged whether to perform a data cache operation according to the number of recorded data rows , when a data cache operation is required, obtain the data that needs to be cached from the cache set; step S3, create a file for storing difference data, write the acquired data into the corresponding file, and delete the corresponding number of rows of the record and the cache set The data; step S4, after the source end and the backup end data are sent, read the file storing the difference data, and perform a common table comparison operation.
Description
Technical field [0001] The present invention relates to the field of computer data backup disaster recovery technology, in particular to a large amount of database table difference comparison method and apparatus. Background [0002] At present, in the process of computer data disaster recovery backup, it is often necessary to compare database tables, for example, before making a data backup, you need to query the difference between the current database table of the backup source and the backup destination to decide whether to back up, at this time you need to compare the database table, and after the data backup to confirm whether the data is complete and accurate, you also need to compare the database table between the backup source and the backup destination, so the difference comparison of the database table is crucial in the process of computer data disaster recovery backup. [0003] At present, the database table comparison process in the computer data disaster recovery ba...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/2455G06F16/172G06F11/14
CPCG06F16/2282G06F16/2255G06F16/24552G06F16/172G06F11/1448
Inventor 王岚高志会陈勇铨胡军擎
Owner INFORMATION2 SOFTWARE SHANGHAI