Patent ID: 7904434

Claim:
A method comprising the computer-executed steps of: executing, by a database server, a database transaction that performs a portion of an operation; committing, by the database server, changes made by the database transaction before the operation has successfully completed, wherein committing changes comprises making visible to other transactions one or more values, in one or more user tables, that were changed by the database transaction; after the changes made by the database transaction have been committed by the database server, thereby becoming already-committed changes, the database server determining that the operation did not successfully complete; in response to determining that the operation did not successfully complete, the database server automatically removing the already-committed changes made by the database transaction; wherein after the database transaction is committed and before the already-committed changes are removed: a second database transaction, that is not part of said operation, accesses at least one value, of the one or more values stored in the one or more user tables, that reflects the already-committed changes; wherein the method is performed by at least one device.