Supercharge Your Innovation With Domain-Expert AI Agents!

A database transaction processing method, system, computing device and computer-readable storage medium based on optimistic locking

A transaction processing and database technology, applied in the computer field, can solve problems such as thread starvation, system throughput decline, failure to execute successfully, etc., and achieve the effect of reducing the probability of resource conflicts

Active Publication Date: 2022-05-17
在线途游(北京)科技有限公司 +1
View PDF0 Cites 0 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
  • A database transaction processing method, system, computing device and computer-readable storage medium based on optimistic locking
  • A database transaction processing method, system, computing device and computer-readable storage medium based on optimistic locking
  • A database transaction processing method, system, computing device and computer-readable storage medium based on optimistic locking

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Many specific details are set forth in the following description to facilitate a full understanding of the present application. However, the present application can be implemented in many other ways different from those described herein, those skilled in the art may do similar promotion without violating the connotation of the present application, so the present application is not subject to the specific implementation disclosed below.

[0033]The terms used in one or more embodiments of the present application are for the purpose of describing a particular embodiment only, and are not intended to limit one or more embodiments of the present application. The singular forms used in one or more embodiments of the present application and the appended claims are also intended to include most forms, unless the context clearly indicates other meanings. It should also be understood that the term "and / or" as used in one or more embodiments of the present application refers to an...

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 present application provides an optimistic lock-based database transaction processing method and system, a computing device, and a computer-readable storage medium. In this method, by combining optimistic locks with read-write locks, not only the data deadlock problem in pessimistic locks is avoided, but also the minimum lock adjustment strategy is used when it is found that the required locks change after transaction redo To minimize competition, release as few locks as possible while ensuring no deadlocks, reducing the probability of conflicts, thus avoiding a series of problems caused by frequent transaction redo.

Description

Technical field [0001] The present application relates to the field of computer technology, in particular to a database transaction processing method based on optimistic locks, systems, computing devices and computer-readable storage media. Background [0002] In order to prevent data read and write conflicts in database applications, pessimistic locks and optimistic locks are often used to process transactions in the database. [0003] Pessimistic locks are a type of database lock that is exclusive: if a transaction successfully acquires a pessimistic lock, the data remains locked throughout the execution of the transaction, and the pessimistic lock is not released until the end of the transaction execution or the transaction is abnormally rolled back; if the transaction fails to acquire the pessimistic lock, it waits until it expires. [0004] In order to avoid deadlocks, the current database also supports optimistic lock technology, optimistic lock is a concurrency type of lo...

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/50G06F16/2458
CPCG06F9/505G06F9/5016G06F16/2462
Inventor 黄强郭子文林逸杨利华
Owner 在线途游(北京)科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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