| CPC G06F 16/2308 (2019.01) | 18 Claims |
|
1. A method of limiting concurrent updates in a database, comprising:
executing a Data Base (DB) update limiter by at least one processor of each of a plurality of computing devices, wherein each of the plurality of computing devices executing at least one application capable of updating data in at least one database which is accessible by a plurality of applications executed by the plurality of computing devices, the at least one processor is adapted for executing said DB update limiter which controls concurrent accesses to said at least one database and configured for:
executing the following for each update access of the at least one application to the at least one database:
identifying a DB segment identifier of a destination segment of the database targeted by the respective update access;
checking an access counter associated with the identified DB segment identifier, the counter is indicative of a number of update accesses currently in progress to the destination segment, wherein said access counter is stored in at least one shared memory resource accessible to the DB update limiter executed by each of the plurality of computing devices;
enabling the respective update access responsive to determining that the access counter is smaller than a certain threshold; and
preventing the respective update access responsive to determining that the access counter equals the certain threshold.
|