Unlock instant, AI-driven research and patent intelligence for your innovation.

Data processing method, device and system

A data processing and data technology, applied in the database field, can solve problems such as inability to achieve consistent reading of distributed transactions

Active Publication Date: 2021-06-01
ALIBABA CLOUD COMPUTING LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a data processing method, device and system to at least solve the technical problem in the related art that the consistent reading of distributed transactions cannot be realized in the distributed 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
  • Data processing method, device and system
  • Data processing method, device and system
  • Data processing method, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] According to an embodiment of the present application, a data processing method is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although the steps shown in the flow chart Although a logical order is shown, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0035] The method embodiments provided in the embodiments of the present application may be executed in mobile terminals, computer terminals or similar computing devices. figure 1 It shows a hardware structural block diagram of a computer terminal (or mobile device) for realizing the data processing method. Such as figure 1 As shown, the computer terminal 10 (or mobile device 10) may include one or more (shown by 102a, 102b, ..., 102n in the figure) processor 102 (the processor 102 may include but not limit...

Embodiment 2

[0108] According to an embodiment of the present application, a data processing device for implementing the above data processing method is also provided, such as Figure 8 As shown, the apparatus 800 includes: a first determination module 802 , a first acquisition module 804 and a second determination module 806 .

[0109] Wherein, the first determination module 802 is used to determine the first transaction corresponding to the data currently stored in the distributed database; the first acquisition module 804 is used to obtain the stored first transaction information of the first transaction, wherein the first transaction information includes At least one of the following: the first commit timestamp and the first transaction status; the second determination module 806 is configured to determine whether the currently stored data is visible to the second transaction based on the first transaction information, wherein the second transaction is the current pair distribution A t...

Embodiment 3

[0142] According to an embodiment of the present application, a data processing system is also provided.

[0143] Figure 9 is a schematic diagram of a data processing system according to an embodiment of the present application. Such as Figure 9 As shown, the system includes: multiple data nodes 92 and processing nodes 94 deployed in a distributed manner.

[0144] Among them, a plurality of data nodes 92 are used to store data; the processing node 94 is used to determine the first transaction corresponding to the data currently stored in the plurality of data nodes 92, obtain the first transaction information of the stored first transaction, and based on the first transaction information, to determine whether the currently stored data is visible to the second transaction, wherein the first transaction information includes at least one of the following: the first commit timestamp and the first transaction status, and the second transaction is currently for multiple data nod...

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 application discloses a data processing method, device and system. Wherein, the method includes: determining the first transaction corresponding to the data currently stored in the distributed database; acquiring the stored first transaction information of the first transaction, wherein the first transaction information includes at least one of the following: a first commit timestamp and the first transaction state; based on the first transaction information, determine whether the currently stored data is visible to the second transaction, wherein the second transaction is a transaction currently performing a read operation on the data stored in the distributed database. The present application solves the technical problem that consistent reading of distributed transactions cannot be realized in distributed databases in related technologies.

Description

technical field [0001] The present application relates to the field of databases, in particular, to a data processing method, device and system. Background technique [0002] Currently, MySQL is a widely used open source database. In order to avoid problems for users, it is necessary to provide consistent read transactions. For example, taking the reconciliation scenario as an example, it is required that the read data must be consistent, that is, a transaction is visible to the current transaction, or invisible to the current transaction, and the amount of the payee cannot increase, but the deduction party Where the amount has not been reduced. However, for distributed transactions, consistent reading of multiple MySQL nodes in a distributed deployment cannot be achieved. [0003] For the above problems, no effective solution has been proposed yet. Contents of the invention [0004] Embodiments of the present application provide a data processing method, device, and sy...

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/27G06F16/25
CPCG06F16/25G06F16/27
Inventor 傅宇李飞飞
Owner ALIBABA CLOUD COMPUTING LTD