Patent ID: 8117174

Claim:
A method, comprising: collecting an active transaction list of all active transactions when a read-only transaction starts, the active transaction list including a first log record and a last log record associated with each active transaction; determining an oldest log sequence number and a last log sequence number associated with the active transaction list; loading a modified block into a cache view, the modified block including a log sequence number; comparing the log sequence number to both the oldest log sequence number and the last log sequence number; and performing physical redo operations or physical undo operations based upon the comparing, wherein the physical redo operations or the physical undo operations are not performed on the modified block when the log sequence number is less than the oldest log sequence number, and the physical redo operations are performed on the modified block when the log sequence number is greater than the oldest log sequence number and less than the last log sequence number, and the physical undo operations are performed on the modified block when the log sequence number is greater than the last log sequence number.