Patent ID: 7991752
Filing Date: 2011-08-02
Classification: G06F

Abstract:
1. A computer-implemented method, comprising: preserving, using a computer including a processor, savepoint information in a two-tiered data structure with a first tier comprising a DataBase Management System (DBMS) savepoint linked list including at least one DBMS savepoint object and with a second tier comprising a federated savepoint linked list that is connected to a DBMS savepoint object in the DBMS savepoint linked list; and in response to determining that a savepoint statement issued on a federated database is a reused savepoint, that there is a federated savepoint linked list anchored under an original DataBase Management System (DBMS) savepoint object in the DBMS savepoint linked list, and that there is an application savepoint positioned in front of the original DBMS savepoint object, transferring the federated savepoint linked list to a DBMS savepoint object that is one position up on the DBMS savepoint linked list; and in response to determining that there is not an application savepoint positioned in front of the original DBMS savepoint object and that the federated savepoint linked list is anchored under the original DBMS savepoint object and is a first savepoint object on the DBMS savepoint linked list, for each data source on the federated savepoint linked list, clearing a savepoint at a remote data source by issuing at least one of a savepoint statement and a release savepoint statement, wherein the savepoint statement is used to move the position of the savepoint entry to a tail of a savepoint linked list on the data source side and the release savepoint statement is used to clear a specific savepoint.