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

Method and device for confirming data consistency and electronic equipment

A consistency and data technology, applied in the field of data transmission, can solve problems such as difficulty in verifying data, affecting database performance, and time-consuming data verification, and improving verification efficiency, data verification time-consuming, and data volume. small effect

Pending Publication Date: 2022-03-15
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In related technologies, the main data verification tools used are pt-table-sync and pt-table-checksum. The data verification tools have relatively high restrictions, for example, they need to have high operation authority on the source database, and log files are required. Set to a specific mode, etc., so it is difficult to verify the data through the data verification tool; in addition, when the amount of data to be transmitted is large, the data verification takes a long time, and it is easy to cause slow queries in the database. affect the performance of the database

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 confirming data consistency and electronic equipment
  • Method and device for confirming data consistency and electronic equipment
  • Method and device for confirming data consistency and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In order to make the purposes, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, but not all of them. example. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative efforts shall fall within the protection scope of the present invention.

[0026] At present, in the process of data migration and data synchronization, ensuring data consistency is a necessary condition. It is extremely important in Data Transmission Service (DTS). Because DTS needs to implement non-stop migration, in order to ensure data consistency, data verification is usually performed during the data transmission process or when the data transmission is about to en...

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 confirming data consistency and electronic equipment. The method comprises the following steps: acquiring data volume information of to-be-migrated data in a source database through equipment running a data transmission service; wherein the data volume information comprises the number of data tables and / or the number of data rows in each data table; after the to-be-migrated data is migrated to the target database, obtaining data volume information of migrated data corresponding to the to-be-migrated data in the target database; and based on the data volume information of the to-be-migrated data and the data volume information of the migrated data, determining whether the to-be-migrated data is consistent with the migrated data. In the mode, the consistency of the to-be-migrated data and the migrated data can be verified only by having relatively low query permission for the source database and the target database, the realizability is high, the queried data volume is relatively small, whether the data is inconsistent or not can be quickly confirmed, the data verification time is short, the verification efficiency of the data consistency is improved, and the verification efficiency of the data consistency is improved. And the database performance is improved.

Description

technical field [0001] The present invention relates to the technical field of data transmission, and in particular, to a method, an apparatus and an electronic device for confirming data consistency. Background technique [0002] In the process of data migration and data synchronization, ensuring data consistency is a necessary condition. In order to ensure data consistency, it is usually necessary to perform data verification during the data transmission process or when the data transmission is about to end. In related technologies, the main data verification tools used are pt-table-sync and pt-table-checksum. The data verification tools have relatively high restrictions, such as the need to have high operation authority on the source database and log files. It is difficult to verify data through data verification tools; in addition, when the amount of data to be transmitted is large, data verification takes a long time, and it is easy to cause slow queries in the databas...

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/21G06F16/23G06F16/27
CPCG06F16/214G06F16/2365G06F16/27
Inventor 张雨
Owner BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com