System and method for variable block logging with log-ahead buffers
First Claim
1. A method for logging database transactions, comprising:
- logging a first record of a first database transaction using a database log;
writing at least a portion of the database log to a storage device; and
logging a second record of a second database transaction in a first log buffer substantially concurrently to the database log being written to the storage device.
2 Assignments
0 Petitions
Accused Products
Abstract
A system for logging database transactions comprises a memory (comprising a direct access storage device) operable to store a database, a database log, and a plurality of log buffers associated with the database log. Each log buffer is operable to store at least one log record associated with a database transaction. The system further comprises a processor operable to log a first record of a first database transaction using the database log and write the database log to the storage device. The processor is further operable to log a second record of a second database transaction in a first of the plurality of log buffers substantially concurrently to the database log being written to the storage device.
-
Citations
22 Claims
-
1. A method for logging database transactions, comprising:
-
logging a first record of a first database transaction using a database log;
writing at least a portion of the database log to a storage device; and
logging a second record of a second database transaction in a first log buffer substantially concurrently to the database log being written to the storage device. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. Software for logging database transactions, the software operable when executed to:
-
log a first record of a first database transaction using a database log;
write at least a portion of the database log to a storage device; and
log a second record of a second database transaction in a first log buffer substantially concurrently to the database log being written to the storage device. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15)
-
-
16. A system for logging database transactions, comprising:
-
a memory storing a database, a database log, and a plurality of log buffers associated with the database log, each log buffer operable to store at least one log record associated with a database transaction, and the memory comprising a direct access storage device; and
a processor operable to;
log a first record of a first database transaction using the database log;
write at least a portion of the database log to the storage device; and
log a second record of a second database transaction in a first of the plurality of log buffers substantially concurrently to the database log being written to the storage device. - View Dependent Claims (17, 18, 19, 20, 21, 22)
-
Specification