Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data verification method and device after data migration

A technology after data verification and migration, which is applied to database indexing, database models, relational databases, etc., and can solve problems such as low efficiency, limited scope of application, and risk of accuracy

Pending Publication Date: 2021-07-06
CHINA CONSTRUCTION BANK
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The data consistency between the source database and the target database is mainly reflected in the consistency of database objects such as the number of tables, the number of data entries in the table, the key fields of the table, the index of the table, the partition of the table, and the stored procedure. The comparison between the source database and the target database is acceptable when the amount of data is small, but when the amount of data is large, this method is extremely inefficient on the one hand, and on the other hand, due to manual reasons, comparisons are easy to occur The case where the result is wrong
Even though the sampling method can be used to improve the efficiency, the result does not represent the sampling results of all data, and there is a certain risk in the accuracy. It is not suitable for systems with strong data sensitivity, and the scope of application is limited.

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
  • Data verification method and device after data migration
  • Data verification method and device after data migration
  • Data verification method and device after data migration

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments of the present invention and their descriptions are used to explain the present invention, but not to limit the present invention.

[0049] Before introducing the embodiments of the present invention, the names involved in the embodiments of the present invention are firstly introduced.

[0050] 1.Oracle RAC: Acronym for Oracle Real Application Cluster, which is a real-time application cluster and the core technology for Oracle database to support network environment computing. The cluster supports multi-node load balancing; provides high availability, fault tolerance and seamless switching functions; the response time of cluster transactions is fast, and the number of transactions and connec...

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 data verification method and device after data migration, and relates to the technical field of automatic programming, and the method comprises the steps: obtaining a pre-created configuration file; determining a connection mode of the source database according to the type of the source database in the configuration file; determining a connection mode of the target database according to the type of the target database in the configuration file; according to the connection mode of the source database, calling a connection tool of the source database to obtain source database data; according to the connection mode of the target database, calling a connection tool of the target database, and obtaining data of the target database; and according to the verification mode in the configuration file, comparing the source database data with the target database data to obtain a data verification result after data migration. According to the method, the data after data migration can be efficiently, accurately and comprehensively verified, so that the successful online efficiency of a new system after data migration is improved, and a powerful guarantee is provided for stable operation of the new system in future.

Description

technical field [0001] The invention relates to the technical field of automatic program design, in particular to a data verification method and device after data migration. Background technique [0002] This section is intended to provide a background or context to embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] The success of data migration is an important prerequisite for the successful launch of the new system, and it is also a strong guarantee for the stable operation of the new system in the future. After the data is migrated from the source database to the target database, the consistency of the source database and the target database directly affects the success of the data migration, so it is very important to check the consistency of the source database and the target database after data migration. important. [0004] The data consistency between the sour...

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): G06F16/21G06F16/22G06F16/28
CPCG06F16/214G06F16/2282G06F16/284
Inventor 李承文李燕强陈志国
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products