A concurrency control method and device

A control method and state technology, applied in the computer field, can solve problems affecting database concurrency performance, restricting system throughput, etc., and achieve the effect of improving concurrent throughput

Active Publication Date: 2019-03-08
HUAWEI TECH CO LTD
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] However, on the one hand, blocking can guarantee the ACID properties of database transactions (the four basic characteristics of databases: Atomicity, Consistency, Isolation, and Durability). On the other hand, the existence of blocking will affect the concurrent performance of the database.
Based on the blocking type in the existing design mode, in the case of high concurrency, it will seriously restrict the throughput of the entire system

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
  • A concurrency control method and device
  • A concurrency control method and device
  • A concurrency control method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0043] In order to make readers understand what concurrency control is, the technical background of the present invention will be further introduced first.

[0044] Since the current mainstream relational databases usually allow multiple users to use and share at the same time, they also have a concurrency control mechanism, that is, control the database to prevent data errors and program operation errors caused by multiple users using the database concurre...

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

Embodiments of the present invention provide a concurrency control method, including: receiving at least two transaction operation requests, where each transaction operation request of the at least two transaction operation requests includes operation object information and operation type information, the operation object information is used to indicate an operation object of the transaction operation request, and the operation type information includes a write operation or a read operation; making a lock-use application according to the at least two transaction operation requests; and determining, according to a requested lock status and a current lock status in the lock-use application, whether the application is passed, and if the application is passed, determining to perform concurrency control on the at least two transaction operation requests by using the requested lock status, where the lock status includes at least three modes: a shared read mode, a shared write mode, and an exclusive mode, where the shared write mode includes allowing two or more write operations to be simultaneously performed on the operation object. According to the concurrency control method, a database system concurrency throughput capability is improved.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a concurrency control method and device. Background technique [0002] In computer science, especially in areas such as programming, operating systems, multiprocessing, and databases, concurrency control is a mechanism for ensuring that errors caused by concurrent operations are corrected in a timely manner. The basic unit of concurrency control is the transaction. Concurrency control refers to various techniques used to protect the integrity of a database when updates are running concurrently by multiple users. Incorrect concurrency mechanisms can lead to such problems as dirty reads, phantom reads, and non-repeatable reads. The purpose of concurrency control is to ensure that the work of one user does not unreasonably affect the work of another user. In some cases, these measures ensure that when a user works with other users, the results are the same as when she i...

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): G06F9/52
CPCG06F16/2343G06F16/2379
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
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap