Method and system for reducing lock occurrences in server/database systems

A database and digital technology, applied in the field of database systems, can solve problems such as reduced database performance, poor database performance request processing delay, and waiting request failure

Inactive Publication Date: 2014-05-14
INT BUSINESS MASCH CORP
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This leads to a downward spiral as the server has many incoming connections, making the database performance degraded by resource consuming locking processes
Poor database performance causes delays in request processing, which in turn increases the number of concurrent requests to be processed
[0005] Also, because a timeout is triggered, a request that is waiting for a long time on the server may be considered a failure even though it is eventually processed by the server

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
  • Method and system for reducing lock occurrences in server/database systems
  • Method and system for reducing lock occurrences in server/database systems
  • Method and system for reducing lock occurrences in server/database systems

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040]As will be appreciated by those skilled in the art, aspects of the present invention may be embodied as a system, method or computer program product. Therefore, various aspects of the present invention can be embodied in the following forms, that is: a complete hardware implementation, a complete software implementation (including firmware, resident software, microcode, etc.), or a combination of hardware and software implementations, These may collectively be referred to herein as "circuits," "modules," or "systems." Furthermore, in some embodiments, various aspects of the present invention can also be implemented in the form of a computer program product embodied in one or more computer-readable media having computer-readable program code embodied therein. Any combination of one or more computer readable medium(s) may be utilized. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage m...

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 a computer-implemented method for limiting the number of concurrent requests in a database system. The method includes the following steps of arranging requests to be handled by the database system in at least one queue (10); defining a maximum value (SS) of concurrent requests corresponding to the at least one queue (10); monitoring at least one queue utilization parameter corresponding to the at least one queue (10) and calculating a performance value (PF) based on the at least one queue utilization parameter, adapting the maximum value (SS) of concurrent requests of the at least one queue dynamically based on the performance value (PF) in order to improve system performance and limiting the number of concurrent requests of the at least one queue (10) dynamically based on the dynamically adapted maximum value (SS).

Description

technical field [0001] The present invention generally relates to the field of database systems, and particularly relates to a database system for a server to access a database. More specifically, the present invention relates to a method and system for limiting the number of concurrent requests in a database system and thus reducing the occurrence of locking in a server / database system. Background technique [0002] In a traditional client-server architecture, one or more nodes are connected to one or more servers via a network that allows bi-directional communication between clients and servers. Typically, a server receives requests from multiple sources and processes them according to a prescribed processing scheme. More generally, a first-in-first-out (FIFO) method is used, allowing requests received first to be processed by the server first, requests received second second, and so on. In database systems, queues are used to process incoming requests from clients in or...

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): G06F17/30H04L29/06
CPCG06F16/2343G06F9/526G06F16/1767G06F16/21G06F16/217G06F16/2336G06F16/2365G06F16/285G06F16/955
Inventor B.T.马莱基P.戈塞克J.马斯扎莱克G.K.莱奇J.沃尔齐切克
Owner INT BUSINESS MASCH 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