Unlock instant, AI-driven research and patent intelligence for your innovation.

A database deadlock processing method, device and database system

A processing method and database technology, applied in the database field, can solve time-consuming problems and achieve the effect of improving execution efficiency

Active Publication Date: 2022-05-06
ALIBABA CLOUD COMPUTING LTD
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the transaction takes a long time to execute, when the transaction is forced to roll back due to a deadlock in the middle of execution, the transaction needs to be executed from the beginning, which will consume a lot of unnecessary 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 deadlock processing method, device and database system
  • A database deadlock processing method, device and database system
  • A database deadlock processing method, device and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments of the present application and corresponding drawings. Apparently, the described embodiments are only some of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0021] The technical solutions provided by various embodiments of the present application will be described in detail below in conjunction with the accompanying drawings.

[0022] figure 1 It is a flowchart of a database deadlock processing method in an embodiment of the present application. figure 1 The method is executed by means for handling data...

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 discloses a database deadlock processing method, device, and database system. The method includes: dividing a transaction into N sub-transactions executed sequentially; creating a savepoint and recording ; Execute the N sub-transactions sequentially; when lock waiting occurs in the nth sub-transaction of the N sub-transactions and the waiting time is greater than the first waiting time corresponding to the n-th sub-transaction, the transaction is rolled back to the rollback savepoint, The rollback savepoint is a savepoint created before executing the nth sub-transaction; continue to sequentially execute the sub-transactions after the rollback savepoint among the N sub-transactions. This application divides the transaction into multiple sub-transactions and sets a savepoint before execution. After the sub-transaction locks and waits for more than the first waiting time corresponding to the sub-transaction, it rolls back to the save point before the sub-transaction and continues. Execution, which can improve the execution efficiency of deadlock transactions to a certain extent.

Description

technical field [0001] The present application relates to the field of databases, in particular to a database deadlock processing method, device and database system. Background technique [0002] Database deadlocks are a common problem in databases. Deadlock generally requires the following four necessary conditions: [0003] (1) Mutually exclusive conditions: A resource can only be used by one process at a time. [0004] (2) Request and holding conditions: When a process is blocked due to requesting resources, it will not let go of the obtained resources. [0005] (3) Non-deprivation conditions: The resources obtained by the process cannot be forcibly deprived before they are used up. [0006] (4) Circular waiting condition: A head-to-tail cyclic waiting resource relationship is formed among several processes. [0007] The existing methods for resolving deadlocks in databases are usually for the database to determine whether there is a deadlock, and if a deadlock is fou...

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/46G06F9/52G06F16/23
CPCG06F16/23G06F9/466G06F9/524G06F9/46G06F9/52G06F16/00
Inventor 范孝剑张广舟林晓斌周正中
Owner ALIBABA CLOUD COMPUTING LTD
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