Patent ID: 9710510
Date: 2017-07-18
CPC Classifications: G06F

Claim:
1. A computer-implemented method for minimizing lock contention in a distributed database, the method comprising: receiving a first data request operation on the distributed database, wherein the first data request operation includes at least one write request having target data; processing the first data request operation on at least one database instance managed by a database manager; predicting, by a computer system, a page fault responsive to the target data of the at least one write request, wherein the predicting the page fault includes determining that the target data associated with the at least one write request is not found in an active memory of the at least one database instance based on a model analyzing the active memory; suspending, prior to triggering the page fault, execution of the first data request operation in response to the predicting the page fault, such that if the at least one write request is executed the at least one write request would result in a lock; requesting access to a physical storage of the distributed database to read the target data into the active memory, during a time period for the suspending the first data request operation and during execution of at least a second data request operation on the distributed database unrelated to the page fault; and re-executing the first data request operation after the time period for suspending the first data request operation.