IP Library › Granted Patent US 7,698,309
Granted Patent B2
US 7,698,309 · App. 11/204,151 · Granted Apr 13, 2010

Advanced fine-grained administration of recovering transactions

Assignee: Oracle International Corporation
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,698,309
App. No.
11/204,151
Granted
Apr 13, 2010
Kind
B2
Abstract

A method, system, and computer program product provides advanced and fine-grained transaction administration features, along with interoperability between transactional software architectures and business entities. A method of administering recovering transactions comprises the steps of operating a transaction processing system, and attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually.

Claims (44)

1. A method of administering recovering transactions in a transaction processing system, comprising the steps of:

operating the transaction processing system; and

in the transaction processing system, automatically attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually, determining a state of each of the plurality of transactions individually, determining an administrative action to be taken with each of the plurality of transactions individually, based on the state of the transaction and on resources enlisted in the transaction, and displaying in a graphical user interface information relating to each of the plurality of transactions individually, including displaying the state of each of the plurality of transactions, a type of each of the plurality of transactions, information relating to resources participating in each of the plurality of transactions, and the administrative action that has been determined is to be taken for each of the plurality of transactions, wherein the step of determining an administrative action comprises the steps of:

terminating and rolling back the transaction, if the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, and the resources exceed a limit;

heuristically forcing the transaction to complete, if the state of the transaction is that the transaction is in the preparing phase of the commit process, and has not yet entered the commit phase, and the resources exceed a limit; and

terminating recovery of the transaction and abandoning the transaction, if the state of the transaction is that the transaction has suffered an error or failure, and the system is attempting to repair and complete the transaction, and the resources exceed a limit.

2. The method of claim 1 , wherein when the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

3. The method of claim 1 ,wherein when the state of the transaction is that the transaction is in the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

4. The method of claim 1 , wherein when the state of the transaction is that the transaction has suffered an error or failure, the limit includes the transaction taking longer to recover than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

5. A system for administering recovering transactions comprising:

a processor operable to execute computer program instructions;

a memory operable to store computer program instructions executable by the processor; and

computer program instructions stored in the memory and executable to perform the steps of:

operating a transaction processing system; and

attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually, determining a state of each of the plurality of transactions individually, determining an administrative action to be taken with each of the plurality of transactions individually, based on the state of the transaction and on resources enlisted in the transaction, and displaying in a graphical user interface information relating to each of the plurality of transactions individually, including displaying the state of each of the plurality of transactions, a type of each of the plurality of transactions, information relating to resources participating in each of the plurality of transactions, and the administrative action that has been determined is to be taken for each of the plurality of transactions, wherein the step of determining an administrative action comprises the steps of:

terminating and rolling back the transaction, if the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, and the resources exceed a limit;

heuristically forcing the transaction to complete, if the state of the transaction is that the transaction is in the preparing phase of the commit process, and has not yet entered the commit phase, and the resources exceed a limit; and

terminating recovery of the transaction and abandoning the transaction, if the state of the transaction is that the transaction has suffered an error or failure, and the system is attempting to repair and complete the transaction, and the resources exceed a limit.

6. The system of claim 5 , wherein when the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

7. The system of claim 5 , wherein when the state of the transaction is that the transaction is in the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

8. The system of claim 5 , wherein when the state of the transaction is that the transaction has suffered an error or failure, the limit includes the transaction taking longer to recover than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

9. A computer program product for administering recovering transactions comprising:

a computer readable storage medium;

computer program instructions, recorded on the computer readable storage medium, executable by a processor, for performing the steps of

operating a transaction processing system; and

attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually, determining a state of each of the plurality of transactions individually, determining an administrative action to be taken with each of the plurality of transactions individually, based on the state of the transaction and on resources enlisted in the transaction, and displaying in a graphical user interface information relating to each of the plurality of transactions individually, including displaying the state of each of the plurality of transactions, a type of each of the plurality of transactions, information relating to resources participating in each of the plurality of transactions, and the administrative action that has been determined is to be taken for each of the plurality of transactions, wherein the step of determining an administrative action comprises the steps of:

terminating and rolling back the transaction, if the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, and the resources exceed a limit;

heuristically forcing the transaction to complete, if the state of the transaction is that the transaction is in the preparing phase of the commit process, and has not yet entered the commit phase, and the resources exceed a limit; and

terminating recovery of the transaction and abandoning the transaction, if the state of the transaction is that the transaction has suffered an error or failure, and the system is attempting to repair and complete the transaction, and the resources exceed a limit.

10. The computer program product of claim 9 , wherein when the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

11. The computer program product of claim 9 , wherein when the state of the transaction is that the transaction is in the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

12. The computer program product of claim 9 , wherein when the state of the transaction is that the transaction has suffered an error or failure, the limit includes the transaction taking longer to recover than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

13. A transaction processing system comprising:

a processor operable to execute computer program instructions;

a memory operable to store computer program instructions executable by the processor; and

computer program instructions stored in the memory and executable to implement:

a transaction manager operable to perform transaction processing; and

a recovery manager operable to attempt recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually, determining a state of each of the plurality of transactions individually, determining an administrative action to be taken with each of the plurality of transactions individually, based on the state of the transaction and on resources enlisted in the transaction, and displaying in a graphical user interface information relating to each of the plurality of transactions individually, including displaying the state of each of the plurality of transactions, the displayed information further comprises a type of each of the plurality of transactions, information relating to resources participating in each of the plurality of transactions, and the administrative action that has been determined is to be taken for each of the plurality of transactions, wherein the step of determining an administrative action comprises the steps of:

terminating and rolling back the transaction, if the state of the transaction is that the transaction has not vet entered the preparing phase of the commit process, and the resources exceed a limit;

heuristically forcing the transaction to complete, if the state of the transaction is that the transaction is in the preparing phase of the commit process, and has not yet entered the commit phase, and the resources exceed a limit; and

terminating recovery of the transaction and abandoning the transaction, if the state of the transaction is that the transaction has suffered an error or failure, and the system is attempting to repair and complete the transaction, and the resources exceed a limit.

14. The system of claim 13 , wherein when the state of the transaction is that the transaction has not yet entered the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

15. The system of claim 13 , wherein, when the state of the transaction is that the transaction is in the preparing phase of the commit process, the limit includes the transaction taking longer to complete than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

16. The system of claim 13 , wherein when the state of the transaction is that the transaction has suffered an error or failure, the limit includes the transaction taking longer to recover than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 16, 2005
From: PARKINSON, PAUL
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 016869/0037 →
Continuity (1)
Related Publication 20070043784A1 · Feb 22, 2007