OPTIMIZING LOG USAGE FOR TEMPORARY OBJECTS

摘要

A method and apparatus for managing log records during rollback of a group o f changes within a unit of work in a database system. In one embodiment, a method includes determining for each change being rolled back if the change was performed on a temporary database object or a permanent database object; for each change that was performed on a permanent database object, creating an associated compensation log record indicating that the change ha s been rolled back; and for each change that was performed on a temporary database object, assessing if a compensation record is desired based on predetermined criteria, and selectively creating, based on the assessment, an associated compensation log record indicating that the change to the temporary object has been rolled back.