Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database transaction processing method and system based on optimistic lock, computing equipment and computer readable storage medium

A transaction processing and database technology, applied in the computer field, can solve problems such as thread hunger, failure to execute successfully, invalid load growth, etc., and achieve the effect of reducing the probability of resource conflicts

Active Publication Date: 2022-03-22
在线途游(北京)科技有限公司 +1
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

One of the main flaws of optimistic locking is that in the case of intense conflicts, frequent transaction redo brings invalid load growth, system throughput decline, and even causes thread starvation problems caused by some transactions that cannot be successfully executed for a long time

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
  • Database transaction processing method and system based on optimistic lock, computing equipment and computer readable storage medium
  • Database transaction processing method and system based on optimistic lock, computing equipment and computer readable storage medium
  • Database transaction processing method and system based on optimistic lock, computing equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In the following description, numerous specific details are set forth in order to provide a thorough understanding of the application. However, the present application can be implemented in many other ways different from those described here, and those skilled in the art can make similar promotions without violating the connotation of the present application. Therefore, the present application is not limited by the specific implementation disclosed below.

[0033] Terms used in one or more embodiments of the present application are for the purpose of describing specific embodiments only, and are not intended to limit the one or more embodiments of the present application. As used in one or more embodiments of this application and the appended claims, the singular forms "a", "the", and "the" are also intended to include the plural forms unless the context clearly dictates otherwise. It should also be understood that the term "and / or" used in one or more embodiments of th...

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 provides a database transaction processing method and system based on an optimistic lock, computing equipment and a computer readable storage medium. In the method, through a mode of combining an optimistic lock and a read-write lock, not only is the problem of data deadlock in a pessimistic lock avoided, but also when it is found that a lock needed after transaction redoing is changed, a minimum lock adjustment strategy is used for minimizing competition, under the condition that it is guaranteed that deadlock is not generated, the locks are released as few as possible, the probability of conflicts is reduced, and the method is suitable for popularization and application. Therefore, a series of problems caused by frequent transaction redoing are avoided.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to an optimistic lock-based database transaction processing method, system, computing device and computer-readable storage medium. Background technique [0002] In database applications, in order to prevent data read and write conflicts, pessimistic locks and optimistic locks are often used to process transactions in the database. [0003] As a kind of database lock, pessimistic lock is exclusive: if the transaction successfully acquires the pessimistic lock, the data will remain in the locked state during the entire transaction execution process, and the pessimistic lock will not be released until the transaction execution ends or the transaction rolls back abnormally; And if the transaction fails to acquire the pessimistic lock, it will wait to form a deadlock until it times out. [0004] In order to avoid deadlock, the current database also supports optimistic lockin...

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): G06F9/50G06F16/2458
CPCG06F9/505G06F9/5016G06F16/2462
Inventor 黄强郭子文林逸杨利华
Owner 在线途游(北京)科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com