Extension of data definition language (DDL) capabilities for relational databases for applications issuing multiple units of work

• US 6,453,322 B1
• Filed: 07/19/1999
• Issued: 09/17/2002
• Est. Priority Date: 07/19/1999
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Malloy, William Earl, Tomlyn, Craig Reginald, DeKimpe, Daniel Martin
• Primary Examiner(s): Vu, Kim
• Assistant Examiner(s): Nguyen, Tam V
• Application Number:
  US09/356,644
• Time in Patent Office: 1,156 Days
• Field of Search: 707/202, 707/103, 707/2, 707/8, 707/10, 707/201, 707/203, 707/104.1, 713/3
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image
• CPC Class Codes: Y10S 707/99953 Recoverability

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.

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.

2. The method of claim 1, further comprising, after logging, committing each command as the command is executed.

3. The method of claim 1, further comprising associating a flag with the compensating operations for the command to indicate whether the compensating operations are to be performed on a rollback or a commit operation.

4. The method of claim 3, further comprising:

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.

7. The apparatus of claim 6, further comprising means for, after logging, committing each command as the command is executed.

8. The apparatus of claim 7, further comprising means for associating a flag with the compensating operations for the command to indicate whether the compensating operations are to be performed on a rollback or a commit operation.

9. The apparatus of claim 8, further comprising:

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.

12. The article of manufacture of claim 11, the steps further comprising, after logging, committing each command as the command is executed.

13. The article of manufacture of claim 11, the steps further comprising associating a flag with the compensating operations for the command to indicate whether the compensating operations are to be performed on a rollback or a commit operation.

14. The article of manufacture of claim 13, the steps further comprising:

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.

17. The method of claim 16, further comprising, after logging, committing each command as the command is executed.

18. The method of claim 16, further comprising associating a flag with the compensating operations for the command to indicate whether the compensating operations are to be performed on a rollback or a commit operation.

19. The method of claim 18, further comprising:

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.