Unlock instant, AI-driven research and patent intelligence for your innovation.

Quick and accurate database table verification method

A verification method and data verification technology, applied in the field of database security, can solve problems such as inability to verify, low verification efficiency, and inability to perform accurate data verification on a single table

Pending Publication Date: 2020-04-21
北京西骏数据科技股份有限公司
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Comparing with some tools can achieve a more detailed comparison, but as the amount of data in a single table increases, the verification efficiency will become lower and lower, and there are also problems that cannot be verified due to excessive resource consumption. Case
[0004] For this reason, the present invention provides a method for fast and accurate verification of database tables, which is mainly aimed at performing consistency verification on databases with complex data structures, and solves the problem that the data volume of a single table is too large to perform accurate data verification on a single table. problem, to achieve efficient data verification

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Quick and accurate database table verification method
  • Quick and accurate database table verification method
  • Quick and accurate database table verification method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] Below, specific embodiments of the present invention will be described in detail in conjunction with the accompanying drawings.

[0017] Such as figure 1 As shown, the database table fast checking method of the present invention comprises the following steps:

[0018] Step 1. Data source selection:

[0019] Select two data sources that need to be compared, one of which is the original data and the other is the backup data, and you can optionally select the scope of verification, such as the entire database of the data source or a specific table under the database.

[0020] Step 2. Data verification:

[0021] (1) Data structure verification: Check and verify the data structure at both ends (original data and backup data). If the data structure of the original data and the backup data are inconsistent and the data type conversion and matching cannot be performed, the verification cannot be performed; if the original If the data structure of the data and the backup data...

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

No PUM Login to View More

Abstract

The invention discloses a quick and accurate database table verification method. The method comprises the following steps: step 1, data source selection; step 2, data verification; 3, displaying a result; wherein the step 1 comprises the steps of selecting two data sources needing to be compared, one data source is original data, the other data source is backup data, and selecting a verification range; through the fragmentation verification method, consistency verification of mass data can be dealt with. Meanwhile, calculation resources are saved through hash operation in the fragmentation verification process, the verification speed is high, and a verification result accurate to rows and columns can be provided.

Description

technical field [0001] The invention relates to the field of database security, in particular to a method for quickly and accurately checking a database table. Background technique [0002] We have entered the digital age, and in the digital age, the importance of data is self-evident. A large number of business needs generate a large amount of data, how to effectively protect these important data has always been an important topic. A very effective method at this stage is to perform disaster recovery backup for data to ensure that there are multiple copies of the data. When the original data has a catastrophic failure, the business can be quickly restored through the backup data. In addition, the backup data can also be used as other associated The data source of the business provides services for other businesses. However, when data is backed up for disaster recovery, it is necessary to ensure the consistency of the original data and the backup data. However, due to the ...

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
no application Login to View More
IPC IPC(8): G06F16/22G06F16/245G06F11/14
CPCG06F16/2282G06F11/1448G06F16/245
Inventor 徐国忠何泽松曹徐平汪月明
Owner 北京西骏数据科技股份有限公司