Patent ID: 7890455

Claim:
A non-transitory computer readable medium for ensuring a low-latency read of log records from a Database Management System (“DBMS”) in asynchronous log-based database replication capture from a blocking log read Application Programming Interface (“API”), the non-transitory computer readable medium comprising: a log read module configured to initialize a log read thread in response to a log read begin, the log read thread configured to read a predefined number of DBMS log records in a single API call, the log read thread executing a log flush thread; a log flush module of the log flush thread configured to be executed by the log read thread, the log flush thread configured to wait for a read complete notification, the log flush thread configured to wait for a predefined time period, the predefined time period exceeding an expected log read call time; an update module of the log flush thread configured to generate a loggable transaction, the loggable transaction updating a single row of a database table, the update module generating a plurality of loggable transactions such that a number of log records in an internal API log satisfies a DBMS threshold in response to a log flush thread time out: wherein the update module discontinues generating a plurality of loggable transactions in response to reaching a predetermined limit, the log read thread notifying the log flush thread upon a successful read, the log flush thread completing; a reading module of the log read thread configured to read a predefined number of DBMS log records in response to the internal API log having the number of log records satisfying the DBMS threshold, such that the log read thread has an unblocked state; and a notification module of the log read thread configured to notify the log flush thread of a read complete such that the log flush thread completes.