Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Multi-version concurrency control method in database and database system

A control method and database technology, applied in the database field, can solve the problems of low efficiency and inconvenient reading of data pages

Active Publication Date: 2014-04-23
HUAWEI TECH CO LTD
View PDF4 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] During the research and practice of the prior art, the inventor of the present invention found that when reading a page of a certain version, it needs to be read according to the information of all transactions on a page. There are many transactions, which will make the reading of data pages inefficient and not very convenient

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
  • Multi-version concurrency control method in database and database system
  • Multi-version concurrency control method in database and database system
  • Multi-version concurrency control method in database and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0072] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative efforts fall within the protection scope of the present invention.

[0073] An embodiment of the present invention provides a multi-version concurrency control method for a database, which is mainly performed by a database system, such as a distributed disk database system, a cluster database system, or a massively parallel processing (MPP) database system. etc., the flow chart is as figure 1 shown, including:

[0074] Step 101, receiving a data read request generated by a read transaction, the data read request is used to request to read a pa...

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 embodiment of the invention discloses a multi-version concurrency control method in a database and a database system, which are mainly applied to the technical field of databases. The database system is provided with a data page chain of a page; the data page chain comprises a page compass of each version of the page; the page compass of one version of the page is used for pointing to another version of the page before last operation of the version of the page, so that the page can be directly rolled back to the page which needs to be read based on the data page chain of the page which is requested to be read if the time stamp of the current version of the page is greater than the time stamp including a reading service in a data reading request when pages in the database are read, a user is convenient to know the page in the database at any time and is convenient to inquire data of each version of the page in the database. Furthermore, the database system can realize roll-back of records efficiently through combination of the data page chain and a record chain, and can realize reading consistency.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a multi-version concurrency control method in a database and a database system. Background technique [0002] Multi-version concurrency control (MVCC, Multi Version Concurrency Control) is a locking mechanism widely used in database systems. At present, mainstream commercial database systems include Oracle (a database developed by Oracle), structured query language server Databases such as (SQL Server, Structured Query Language Server) and PostgreSQL use such a mechanism. [0003] Generally, there are two implementations of the multi-version concurrency control scheme, one is page-level multi-version, and the other is row-level multi-version. Among them, the page-level multi-version refers to recording the modification timestamp on the page, and the access to the page needs to be performed according to the timestamp. If the timestamp does not meet the requirements, it is neces...

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): G06F17/30
CPCG06F16/2322G06F11/1469G06F16/2329G06F16/2365G06F2201/84
Inventor 文继军聂愿愿李健
Owner HUAWEI TECH 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
Eureka Blog
Learn More
PatSnap group products