Data reading method and device, electronic equipment and storage medium

A data reading and data technology, which is applied in the field of big data and databases, can solve problems such as data reading transaction inconsistency, and achieve the effect of achieving data consistency and correctness

Active Publication Date: 2019-05-03
TENCENT TECH (SHENZHEN) CO LTD
View PDF8 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The present invention provides a data reading method, device, electronic equipment and storage medium, which can solve the problem of transaction inconsistency in data reading

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] 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.

[0046] The database involved in the embodiment of the present invention stores multiple data tables, each data table can be used to store tuples, and tuples can have one or more versions. 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.

[0047] Current State: The...

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 and device, electronic equipment and a storage medium, and belongs to the technical field of databases and big data. The embodiment of the invention provides a method. The method comprises the following steps: finding out a plurality of node devices at the moment when a current global read transaction occurs; the method is based on MVCC, common pointswith transaction consistency are provided; equivalently, only data submitted before the current moment is read; the method can be regarded as a real-time reading process, in the data reading process,the data which are not submitted when the current global read transaction occurs are eliminated; according to the method and the device, when the current global read transaction occurs, only the submitted data when the current global read transaction occurs is read, so that the global write transaction which may cause transaction inconsistency is eliminated, the read data has transaction consistency, the external data consistency of the database system is realized, and the correctness of data reading can also be realized.

Description

technical field [0001] The present invention relates to the technical fields of database and big data, in particular to a data reading method, device, electronic equipment and storage medium. Background technique [0002] Many of the current distributed database systems 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. Generates transactional consistency issues for reading data. For example: when implementing cross-node write operations, suppose there are two node devices, and the transaction can be submitted after the preparation for submission stage has passed. The first node device has been submitted, but the second node device has not yet been submitted. In a new global read operation in the database system, the data submitted by the first node device is read, but the data of the second node device is not read because the data submission has not...

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): G06F9/46G06F16/27G06F16/23
Inventor 李海翔卢卫杜小勇
Owner TENCENT TECH (SHENZHEN) CO LTD
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