Method and device for verifying data between databases

A data verification and database technology, applied in the database field, can solve problems such as difficult manual operation, application service control, etc., to meet business needs and reduce time-consuming effects

Inactive Publication Date: 2019-05-10
NETSUNION CLEARING CORP
View PDF11 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] For this reason, the first purpose of the present invention is to propose a data verification method between databases, which is used to solve the problem that manual operation is difficult to control application services in a timely and effective manner when performing data verification between databases in the prior art. The problem

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
  • Method and device for verifying data between databases
  • Method and device for verifying data between databases
  • Method and device for verifying data between databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals designate the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary and are intended to explain the present invention and should not be construed as limiting the present invention.

[0053] The method and device for verifying data between databases according to the embodiments of the present invention will be described below with reference to the accompanying drawings.

[0054] figure 1 It is a schematic flowchart of a method for verifying data between databases provided by an embodiment of the present invention. Such as figure 1 As shown, the data verification method between the databases includes the following steps:

[0055] S101. Obtain a first data table corresponding to a first database from a preset...

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 provides a method and a device for verifying data between databases. The method comprises the following steps of: obtaining a first data table corresponding to the first database from apreset configuration library, and obtaining a first data table corresponding to the second database, calculating a first data sum of the first data table, calculating a second data sum of the second data table, and if the first data sum is consistent with the second data sum, generating a consistency verification report of the first database and the second database. The process does not depend onreplication between main data and standby data or between standby data, and the configuration information and the verification result of the preset configuration library can be independently stored and are not written into a production database. And data replication between different service libraries can be verified, so that the method is more flexible. And a concurrent mode can be adopted, so that the time consumption of the whole verification process is greatly reduced, and the business requirements can be well met through offline and production verification.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for checking data between databases. Background technique [0002] At present, the platform OLTP (On-Line Transaction Processing, online transaction processing, online transaction processing process) business data storage mainly uses the MySQL database, which adopts the master-slave replication scheme to expand the architecture and redundant data (such as 1 master and 1 backup or 1 master and multiple backups) ), and the core financial business system requires the platform to achieve high database availability and strong data consistency. [0003] However, master-slave replication is log-based logical replication. MySQL uses logical replication to play back transaction logs to synchronize changes in the master database, which can easily lead to data inconsistencies on the master and slave nodes. Therefore, the data consistency of the active and standby node...

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/27
Inventor 余星
Owner NETSUNION CLEARING CORP
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