Patent ID: 6816873
Filing Date: 2004-11-09
Classification: G06F,Y10S

Abstract:
A method of managing transactions on a plurality of database management systems residing on separate servers and including a coordinator server, wherein a single transaction comprises multiple steps across more then one of said plurality of database management systems as participants, said method comprising:a) assigning across the database management system participants at least one savepoint with a savepoint identifier within a multiple step transaction; b) sending a message from the coordinator server to the multiple database management system participants in the transaction identifying the savepoint and providing savepoint information; c) if an application decision to reject a step of the transaction is found, rolling back the transaction across the database management system participants to a savepoint; d) when no application decisions to reject the transaction are found, COMMITING the transaction across the multiple database management system participants; e) sending messages from replying multiple database management system participants to the coordinator server with respect to the savepoint and providing savepoint information comprising sending a message from the multiple database server participants to the coordinator server at the time of rolling a step of the transaction back to a savepoint, releasing a savepoint, completing a request, or replying to a request, said message identifying: 1) savepoints that have been rolled back during this request; 2) savepoints that are still in effect; 3) savepoints that have been released; and f) returning result sets to a requester.