Deadlock treatment method and system for databank management system

A technology of management system and processing method, which is applied in the field of database management system deadlock processing mechanism, can solve the problems that cannot be applied with the same priority and different importance, and achieve the effect of improving customizability and service quality

Inactive Publication Date: 2010-03-03
IBM CORP
View PDF0 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This scheme cannot be used when two requests have the same priority
For example, if a common client and a VIP client submit requests at the same time, this causes their requests to be bound to the same priority, but in fact, from the perspective of the application side, the importance of these two clients may not be the same, and the server side I don't understand this, so this existing solution only considers the convenience of database management, but it cannot avoid the wrong sacrifice choice for actual needs

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
  • Deadlock treatment method and system for databank management system
  • Deadlock treatment method and system for databank management system
  • Deadlock treatment method and system for databank management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] figure 2 It shows a schematic module diagram of deadlock processing for DBMS according to the present invention, in which two applications T1 and T2 requesting access to DBMS resources are shown. For example, in the case of online purchase, it may be assumed that T1 is an order request of a common user, and T2 is an order request of a VIP customer. Or, in the case of general database management, it can be assumed that T1 is an administrator with ordinary authority, and T2 is an administrator with advanced authority. When the two applications T1 and T2 attempt to access the DBMS system 1 at the same time, they transmit one or more attribute values ​​of themselves to the DBMS system 1 together with the request for database resources. The following is an example code for the application side to pass the attribute value to the DBMS along with the request during connection establishment:

[0025] / / Application begins

[0026] {

[0027] ...

[0028] SQLConnect(connHandl...

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 relates to an application-oriented DBMS deadlock treatment mechanism, in particular to deadlock treatment method and system based on a sacrificial selection rule of application-orientedlogic when DBMS is deadly locked. When the deadlock is generated, requests can be selected according to the sacrificial rule which can be dynamically and flexibly ensured on the basis of the actual requirement of an application end, thereby an unexpected sacrificial selection result is avoided in actual application. Because the rule is related to the attribution of the actual application end, therequests which need to be sacrificed are selected on the basis of the value of the attribution.

Description

technical field [0001] The invention relates to an application-oriented database management system (DBMS) deadlock processing mechanism, more specifically, relates to a deadlock processing method and system based on application logic-oriented sacrifice selection rules when a deadlock occurs in the DBMS. Background technique [0002] At present, it is impossible to absolutely avoid deadlocks in parallel processing database management systems. Many deadlock detection solutions have been proposed, and these solutions may have different impacts on application-side QoS. [0003] exist figure 1 A schematic diagram of a commonly used DBMS infrastructure is shown in . Wherein, the connection management unit 11 receives the request from the application side into the DBMS engine 1, and checks whether the request is valid. If so, the connection management unit 11 transmits the request to the SQL compiler 12, and the SQL compiler 12 interprets the request into one or more tasks, and ...

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 Applications(China)
IPC IPC(8): G06F9/46G06F17/30
Inventor 孙清涛吴中华周喜英窦志彤
Owner IBM CORP
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