Patent ID: 9720911
Date: 2017-08-01
CPC Classifications: G06F

Claim:
1. A system for variable block logging with log-ahead buffers, wherein the system comprises a processor configured to: determine a number and a size of log buffers that are made available or remain available, to log records associated with database transactions in a storage device based on a statistic that relates to logging previous records associated with previous database transactions in the storage device; log a current record associated with a current database transaction into a current one of the available log buffers until the current log buffer has been filled or an event that requests committing the current log buffer to the storage device occurs; commit the current record logged in the current log buffer to a track on the storage device in a current write operation in response to determining that the current log buffer has been filled or the event that requests committing the current log buffer to the storage device has occurred; log a new record associated with a new database transaction that is received during the current write operation into a newly activated one of the available log buffers substantially concurrently with the current write operation committing the current record to the track on the storage device; and commit the new record logged in the newly activated log buffer to the track on the storage device in response to the track on the storage device having additional space subsequent to the current write operation committing the current record to the track on the storage device.