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

Data reading method, data reading device, computer equipment and storage medium

A technology of computer equipment and data reading, applied in the database field, can solve problems such as the inability to guarantee the consistent state of data transactions

Active Publication Date: 2020-05-22
RENMIN UNIVERSITY OF CHINA +1
View PDF7 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a data reading method, device, computer equipment, and storage medium, which can solve the problem that the read data cannot be guaranteed to be in a transactionally consistent state during the current data reading process

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 reading method, data reading device, computer equipment and storage medium
  • Data reading method, data reading device, computer equipment and storage medium
  • Data reading method, data reading device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0067] The database involved in the embodiment of the present invention stores multiple data tables, and each data table can be used to store a tuple, and a tuple is one or more data items stored in the data table. Wherein, the database may be any type of database based on MVCC (Multi-Version Concurrency Control, multi-version concurrency control). In this embodiment of the present invention, the type of the database is not specifically limited. It should be noted that the data in the above database is based on state attributes and can include three states: current state, transition state, and historical state. Each of the different status attributes in the data can be used to identify the status of the data in its life cycle track. ...

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 reading method, a data reading device, computer equipment and a storage medium, and belongs to the technical field of databases. A plurality of tuples conforming to thereading condition are determined through the reading condition carried by a data reading request, the global transaction state of each global transaction is maintained in a database system to obtain the global transaction state meeting the consistency condition, the global submission moment is obtained according to the global transaction state, and a target tuple is determined from the tuples on the basis of the global submission moments of the global transactions. Different global submission moments are given to different global transaction states, and the visibility of the tuples is judged directly based on global submission, so that DRCC abnormality is avoided, and the transaction consistency of global reading operation in a database system is ensured.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data reading method, device, computer equipment and storage medium. Background technique [0002] In the current distributed database system, there are many that can support cross-node write operations, that is, for a certain write operation, it may involve the writing process of multiple node devices in the distributed database system, so , may cause transactional consistency issues for reading data. [0003] For example: when implementing cross-node write operations, suppose there are two node devices that have completed the preparation phase for transaction submission. This transaction can be submitted. The first node device is submitted, but the second node device is submitting. It has not yet been submitted. At this time, a new global read operation has come to the distributed database system. The data submitted by the first node device is read, but the data submitted b...

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/2458G06F16/27G06F11/14
CPCG06F16/2471G06F16/27G06F11/1464G06F16/2379
Inventor 李海翔卢卫杜小勇赵展浩潘安群
Owner RENMIN UNIVERSITY OF CHINA