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

Method and system for real-time verification of distributed database data

A real-time verification and database technology, applied in the field of distributed database data verification, which can solve the problems of distributed databases not supporting verification methods, damage to the online environment, and insufficient correctness verification.

Active Publication Date: 2020-11-27
GUANGZHOU JIANYUE INFORMATION TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0017] 1. Using the same interface as the application will affect the performance of the distributed database system, and the verification work is also harmful to the online environment
[0018] 2. The application and verification use the same interface, and the distributed database does not support a specific verification method, and the verification of correctness is not sufficient

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 system for real-time verification of distributed database data
  • Method and system for real-time verification of distributed database data
  • Method and system for real-time verification of distributed database data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] In the following description, many technical details are proposed in order to enable readers to better understand the application. However, those skilled in the art can understand that without these technical details and various changes and modifications based on the following implementation modes, the technical solution claimed in each claim of the present application can be realized.

[0037] In order to make the purpose, technical solution and advantages of the present invention clearer, the following will further describe the implementation of the present invention in detail in conjunction with the accompanying drawings.

[0038] The first embodiment of the present invention relates to a method for real-time verification of data in a distributed database, figure 1 It is a schematic flowchart of the method for real-time verification of data in a distributed database.

[0039] Specifically, the data of the distributed database is distributed among N data nodes, such ...

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 relates to the field of communication, and discloses a method and system for verifying the data of a distributed database in real time. The data of the distributed database is distributed in N data nodes. The method comprises the following steps: after operating the distributed database, if the operation causes the data in the N data nodes to change, obtaining the changed data and synchronizing the changed data to a verification database independent of the N data nodes by a database incremental replication platform; and querying the verification database and verifying whether the operation carried out on the distributed database obtains a correct result. According to the method and system disclosed in the invention, the verification database is added, and the distributed database incremental replication platform is utilized to synchronize the updating data in the distributed database in the verification database, so that when the number of the data nodes changes or the algorithm for distributing the data on different data nodes is adjusted, the verification logic is not influenced and the online environment is not damaged.

Description

technical field [0001] The invention relates to the communication field, in particular to a distributed database data verification technology. Background technique [0002] With the development of cloud computing, the application of distributed database systems is becoming more and more common. In the application scenarios of distributed databases, how to verify the data correctness of distributed database systems, especially the systems that are providing services, has important practical significance. [0003] A common implementation is this: [0004] In a distributed database, the records of the same logical table will be distributed among multiple data nodes according to the hash distribution of the primary key. When it is necessary to verify the correctness of data in a distributed database system, there are usually the following two solutions: [0005] 1. Query and summarize each database node one by one, and finally form the summary data of the logical table, so as...

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 Patents(China)
IPC IPC(8): G06F16/23G06F16/27
Inventor 王小勇陈睿
Owner GUANGZHOU JIANYUE INFORMATION 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