Patent ID: 8856083
Filing Date: 2014-10-07
Classification: G06F

Abstract:
1. A computer-implemented method of performing a write operation on a memory occupied by a logically deleted row of a database object, comprising: identifying, by using a processor, the memory occupied by the logically deleted row of the database object for writing, wherein the logically deleted row was logically deleted from the database object in a previous logical collective delete operation without placing undo information for the logically deleted row data into an undo log, such that the logically deleted row is still present in the database object after its logical deletion and the logically deleted row could have been retrieved from the database object during a rollback operation without retrieving the undo information for the logically deleted row from the undo log, wherein the write operation occurs after the previous logical delete operation and placement of the undo information for the logically deleted row into the undo log is deferred until the write operation; determining whether the logically deleted row is older than an undo retention time; storing the undo information for the logically deleted row in the undo log in response to the write operation being requested on the memory occupied by the logically deleted row, wherein the undo information is stored based on the determination that the logically deleted row is not older than the undo retention time; writing new information to the memory occupied by the logically deleted row of the database object; and storing the new information in the database object in a non-transitory computer usable medium or displaying the new information on a display device.