Extension of data definition language (DDL) capabilities for relational databases for applications issuing multiple units of work
First Claim
1. A method of executing a command in a computer to perform a database operation on a relational database stored on a data store connected to the computer, the method comprising:
- receiving the command from one of a plurality of units of work;
logging one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation;
associating a first identifier with the compensating operations, wherein the first identifier identifies a unit of work from among said plurality of units of work from which the command was received; and
, associating an application identifier with the compensating operations, wherein the application identifier identifies the application that issued the unit of work.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, apparatus, and article of manufacture for DDL Extension layer that provides extended data definition language (DDL) capabilities for relational databases with multi-connections. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. The command is received from one of a plurality of applications. One or more compensating operations are logged for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation. An identifier is associated with the compensating operations, wherein the identifier identifies a unit of work from which the command was received.
-
Citations
24 Claims
-
1. A method of executing a command in a computer to perform a database operation on a relational database stored on a data store connected to the computer, the method comprising:
-
receiving the command from one of a plurality of units of work;
logging one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation;
associating a first identifier with the compensating operations, wherein the first identifier identifies a unit of work from among said plurality of units of work from which the command was received; and
,associating an application identifier with the compensating operations, wherein the application identifier identifies the application that issued the unit of work. - View Dependent Claims (2, 3, 4, 5)
when performing a rollback operation for one of the applications, using at least a one of the first and application identifier associated with the compensating operations to identify compensating operations for that application; and
using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
5. The method of claim 3, further comprising:
-
when performing a commit operation for one of the applications, using at least a one of the first and application identifier associated with the compensating operations to identify compensating operations for that application; and
using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
6. An apparatus for executing a command in a computer, comprising:
-
a computer having a data store coupled thereto, wherein the data store stores a relational database; and
one or more computer programs, performed by the computer, for receiving the command from one of a plurality of applications, logging in a table in the relational database one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation, and associating an identifier with the compensating operations, wherein the identifier identifies a unit of work from which the command was received and the application that issued the unit of work. - View Dependent Claims (7, 8, 9, 10)
when performing a rollback operation for one of the applications, means for using the identifier associated with the compensating operations to identify compensating operations for that application; and
means for using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
10. The apparatus of claim 8, further comprising:
-
when performing a commit operation for one of the applications, means for using the identifier associated with the compensating operations to identify compensating operations for that application; and
means for using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
11. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a command to perform a database operation on a relational database stored on a data store connected to the computer, the method steps comprising:
-
receiving the command from one of a plurality of applications;
logging in a table in the relational database one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and
associating an identifier with the compensating operations, wherein the identifier identifies a unit of work from which the command was received and the application that issued the unit of work. - View Dependent Claims (12, 13, 14, 15)
when performing a rollback operation for one of the applications, using the identifier associated with the compensating operations to identify compensating operations for that application; and
using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
15. The article of manufacture of claim 13, the steps further comprising:
-
when performing a commit operation for one of the applications, using the identifier associated with the compensating operations to identify compensating operations for that application; and
using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
16. A method of executing a command in a computer to perform a database operation on a relational database stored on a data store connected to the computer, the method comprising:
-
receiving the command from one of a plurality of units of work issued from one of a plurality of applications;
logging one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and
associating an identifier with said one or more compensating operations, wherein the identifier identifies a unit of work and an application from which the command was received. - View Dependent Claims (17, 18, 19, 20)
when performing a rollback operation for one of the applications, using the identifier associated with the compensating operations to identify compensating operations for that application; and
using a flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
20. The method of claim 18, further comprising:
-
when performing a commit operation for one of the applications, using the identifier associated with the compensating operation to identify compensating operations for that application; and
using the flag associated with the compensating operations for the command to determine whether those compensating operations are to be executed.
-
-
21. A method of executing commands in a computer to perform database operations on a relational database stored on a data store connected to the computer, the method comprising:
-
receiving the commands from multiple units of work running in parallel against said database;
logging one or more compensating operations for each command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and
associating an identifier with the compensating operations, wherein the identifier identifies a unit of work from among said multiple units of work from which the command was received.
-
-
22. A method of executing a command in a computer to perform a database operation on a relational database stored on a data store connected to the computer, the method comprising:
-
receiving the command from one of a plurality of units of work;
logging one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation;
associating a first identifier with the compensating operations, wherein the first identifier identifies a unit of work from among said plurality of units of work from which the command was received; and
associating a second identifier with the compensating operations, wherein the second identifier identifies an application that issued the unit of work.
-
-
23. An apparatus for executing a command in a computer, comprising:
-
a computer having a data store coupled thereto, wherein the data store stores a relational database; and
one or more computer programs, performed by the computer, for;
receiving the command from one of a plurality of applications;
logging one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation;
associating a first identifier with the compensating operations, wherein the first identifier identifies a unit of work from which the command was received; and
,associating a second identifier with the compensating operations, wherein the second identifier identifies the application that issued the unit of work.
-
-
24. A computer readable medium having contents for causing a computer-based information handling system to perform steps for performing a database operation on a relational database stored on a data store connected to the computer, the steps comprising:
-
receiving a command from one of a plurality of applications;
logging one or more compensating operations for the command, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation;
associating a first identifier with the compensating operations, wherein the first identifier identifies a unit of work from which the command was received; and
associating a second identifier with the compensating operations, wherein the second identifier identifies the application that issued the unit of work.
-
Specification