Database migration data verification method and system

A database and data statistical analysis technology, applied in the field of verification of database migration data, can solve problems such as business suspension, long database migration cycle, and inability to efficiently verify large data objects, so as to achieve accurate verification, improve reliability and fault tolerance sexual effect

Active Publication Date:
View PDF2 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It can be seen that this method is realized by querying a large amount of data, which will greatly affect the efficiency and accuracy of verification, cause the database migration cycle to be too long, and cause the business to suspend for a long time; more seriously, it often cannot target large data objects for fast and efficient validation
It is obvious that the limitations of traditional data verification methods have become a bottleneck in the development of cloud computing and big data technology.

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
  • Database migration data verification method and system
  • Database migration data verification method and system
  • Database migration data verification method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] The technical solutions of the present invention will be described in detail below in conjunction with the accompanying drawings and preferred embodiments. It should be understood that the following examples are only used to illustrate and explain the present invention, but not to limit the technical solution of the present invention.

[0045] Please refer to figure 1 , figure 2 , the structure of the embodiment of the system for verifying database migration data of the present invention, in addition to various types of source databases and target databases, also includes interconnected data block modules and data block management modules, wherein:

[0046] The data block module is used to extract data from the source database and the corresponding target database respectively to form a sample data block for data verification;

[0047]The data block management module is used to analyze the data attributes of the sample data blocks to form the basic block information ...

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 database migration data verification method and system. The system comprises various source databases and target databases. The method comprises that a data segmentation module extracts data from the source databases and the corresponding target databases to form sample data blocks of data verification. A data block management module performs data attributive analysis on the sample data blocks to form sample data block basic information and compares the block basic information of the source databases with corresponding target database basic information to obtain the conclusion of the integrity of migration data. By means of the method and the system, the block basic information obtained through sample extraction by the source databases and the target databases is compared to verify the database migration data, and accordingly, the loads of former comparison of a large number of data are reduced greatly.

Description

technical field [0001] The invention relates to extraction, conversion and loading (ETL, Extraction-Transformation-Loading) technology of computer database data, in particular to a method and system for verifying database migration data. Background technique [0002] Data verification means that the data provider uses a specified algorithm to calculate a check value for the original data of the source database in order to ensure the integrity of the data, and the data receiver uses the same algorithm to calculate the check value for the migration data of the target database , if it is the same as the verification value calculated by the data provider on the original data, it means that the migrated data is complete. [0003] With the development of new technologies such as cloud computing and big data, the requirements for high efficiency and accuracy of data verification are getting higher and higher. Since the increase in the amount of data in applications far exceeds 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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/214
Inventor 杨光
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap