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

Abstract

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

Description

[0001]The present application claims the benefit of priority of United Kingdom Patent Application Ser. No. 1219442.9, filed Oct. 30, 2012 with the United Kingdom Intellectual Property Office, the contents of which are herein incorporated by reference in its entirety.FIELD OF THE INVENTION[0002]The present invention relates generally to the field of database systems, especially database systems with a server to access the database. More specifically, the present invention is related to a method and a system for limiting the number of concurrent requests in a database system and therefore reducing lock occurrences in server / database systems.BACKGROUND[0003]In conventional client-server architectures, one or more nodes are connected to one or more servers via a network that allows for bi-directional communication between a client and a server. Typically, a server receives requests from multiple sources and handles them according to a defined processing scheme. Most commonly, a first-in...

AI Technical Summary

Benefits of technology

The patent describes a way for a system to adjust the number of simultaneous requests based on performance. This helps improve the overall efficiency of the system.

Problems solved by technology

The higher the load on a server, the more likely it is that the latency for receiving a response is increased.

In such cases, the request is aborted, and even if results are directed to the requesting client from the server, the requesting client ignores the results, or is unable to receive them as the connection has been terminated already by a client.

This scheme may result in additional loading of the server's queue, thereby causing additional delays in the server's response time.

In large database environment with many clients connecting to the server to send requests to be processed and pushed to the database, database operations can become bottleneck and affect overall system performance.

When the system performance is decreased, clients cannot connect to the server.

It results in a downward spiral because the server has so many incoming connections that the database performance is decreased by resource-consuming lock handling.

The poor database performance results in delays in request-processing which in turn increases the number of concurrent requests to be processed.

In addition, a request that waits to long on a server may be considered as failure, even though it was eventually processed by the server, because a time-out was triggered.

Images