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

Database deadlock processing method and device

A processing method and technology of a processing device, applied in the database field, can solve problems such as poor timeliness, increase the maintenance workload of the host system, and fail to detect database deadlocks in time, so as to achieve strong timeliness, reduce maintenance workloads, and prevent database deadlocks. Effect

Active Publication Date: 2020-12-04
BANK OF CHINA
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above scheme has the following problems: processing after the database deadlock occurs will affect the stability of the host system operation and increase the maintenance workload of the host system; abandoning one or more transactions and only processing one transaction will affect the duration of concurrent transaction processing , making the timeliness poor; maintenance personnel cannot discover database deadlocks in time, which affects the timeliness of concurrent transaction processing

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 deadlock processing method and device
  • Database deadlock processing method and device
  • Database deadlock processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0060] 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 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 belong to the protection scope of the present invention.

[0061] In view of the master-subordinate relationship between data records, it is necessary to update the master record when processing sub-records. If the master-sub-records are not in the same database partition and are not processed in the same job, deadlock may occur between jobs. The invention proposes a database deadlock processing method, which prevents in advance, preprocesses data, redistributes data to be processed, and prevents database...

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 deadlock processing method and apparatus. The method comprises the steps of obtaining a to-be-processed file and determining a partitioning rule of the to-be-processed file; searching for a main record file associated with the to-be-processed file in a database, and determining a partitioning rule of the main record file; and comparing the partitioning rule of the to-be-processed file with that of the main record file, and when the partitioning rule of the to-be-processed file is different from that of the main record file, performing re-partitioning on the to-be-processed file according to the partitioning rule of the main record file, and updating the main record file according to the re-partitioned to-be-processed file. Before database deadlock occurs, to-be-processed data is correspondingly processed, so that the database deadlock is prevented, one or more transactions do not need to be abandoned, a duration of concurrent transaction processing is not influenced, the timeliness is good, the stability of host system operation is not influenced, and the maintenance workload of a host system is reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database deadlock processing method and device. Background technique [0002] Existing host systems have powerful concurrent transaction processing capabilities. The so-called transaction refers to a program execution unit in which the database system in the host system accesses and possibly updates various data in the database. In a system using database tables, as long as there are a large number of concurrent updates to centralized resources (data), database deadlocks will inevitably occur (Deadlock, which means that in a database system, suppose there is a transaction T1 that blocks data A, and a transaction T2 that blocks data B. After that, transaction T1 applies to block data B, and transaction T2 also applies to block data A. Since transaction T1 has blocked data A, transaction T2 has blocked data B, so transaction T1 and other transaction T2 appear, and transaction T...

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
CPCG06F9/466G06F9/524G06F16/23
Inventor 陈亚坤
Owner BANK OF CHINA
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