Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements

• US 6,480,848 B1
• Filed: 07/19/1999
• Issued: 11/12/2002
• Est. Priority Date: 07/19/1999
• Status: Expired due to Fees

• 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): Alam, Hosain T.
• Assistant Examiner(s): TRUONG, CAM Y T
• Application Number:
  US09/356,059
• Time in Patent Office: 1,212 Days
• Field of Search: 707/1-3, 707/7, 707/8
• US Class Current: 707/684
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database

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 plurality of commands comprising data definition language statements and data modification language statements may be received from an application. Then, separate database connections for processing the data definition language statements and the data modification language statements are generated.

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 the steps of:

receiving a plurality of commands comprising data definition language statements and data modification language statements from an application;

generating separate database connections for processing the data definition language statements and the data modification language statements;

logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

when performing a rollback operation for one of the applications, using the logged compensating operations to rollback the data definition language statements in the relational database.

2. The method of claim 1, further comprising the steps of:

when performing a commit operation for one of the applications,

using relational database operations to commit changes made by the data modification language statements; and

using the logged compensating operations to process the data definition language statements.

10. The method of claim 1, wherein the step of using the logged compensating operations to rollback the data definition language statements includes using logged compensating operations to rollback data definition language statements which are committed in the relational database.

3. 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;

one or more computer programs, performed by the computer, for receiving a plurality of commands comprising data definition language statements and data modification language statements from an application and generating separate database connections for processing the data definition language statements and the data modification language statements;

means for logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

when performing a rollback operation for one of the applications, means for using the logged compensating operations to rollback the data definition language statements in the relational database.

4. The apparatus of claim 3, further comprising:

when performing a commit operation for one of the applications,

means for using relational database operations to commit changes made by the data modification language statements; and

means for using the logged compensating operations to process the data definition language statements.

11. The apparatus of claim 3, wherein the means for using the logged compensating operations to rollback the data definition language statements includes means for using logged compensating operations to rollback data definition language statements which are committed in the relational database.

5. 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 comprising the steps of:

receiving a plurality of commands comprising data definition language statements and data modification language statements from an application;

generating separate database connections for processing the data definition language statements and the data modification language statements;

logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

when performing a rollback operation for one of the applications, using the logged compensating operations to rollback the data definition language statements in the relational database.

6. The article of manufacture of claim 5, further comprising the steps of:

when performing a commit operation for one of the applications,

using relational database operations to commit changes made by the data modification language statements; and

using the logged compensating operations to process the data definition language statements.

12. The article of manufacture of claim 5, wherein the step of using the logged compensating operations to rollback the data definition language statements includes using logged compensating operations to rollback data definition language statements which are committed in the relational database.

7. 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 the steps of:

receiving a plurality of commands comprising data definition language statements and data modification language statements from an application;

generating separate database connections for processing the data definition language statements and the data modification language statements;

logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

when performing a rollback operation for one of the applications,

using relational database operations to rollback the data modification language statements; and

using the logged compensating operations to rollback the data definition language statements.

8. 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;

one or more computer programs, performed by the computer, for receiving a plurality of commands comprising data definition language statements and data modification language statements from an application and generating separate database connections for processing the data definition language statements and the data modification language statements;

means for logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

when performing a rollback operation for one of the applications,

means for using relational database operations to rollback the data modification language statements; and

means for using the logged compensating operations to rollback the data definition language statements.

9. 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 comprising the steps of:

receiving a plurality of commands comprising data definition language statements and data modification language statements from an application;

generating separate database connections for processing the data definition language statements and the data modification language statements;

logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

when performing a rollback operation for one of the applications,

using relational database operations to rollback the data modification language statements; and

using the logged compensating operations to rollback the data definition language statements.

13. A method of executing a command in a computer to perform a database operation on a relational database stored on a data store connected with the computer, the method comprising:

receiving a plurality of commands from an application directed to the relational database, the plurality of commands including data definition language statements and data modification language statements;

logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

,

using the logged compensating operations to rollback the data definition lanugage statements.

14. The method according to claim 13, further comprising:

when performing a rollback operation for said application, using relational database operations to rollback the data modification language statements.

15. The method according to claim 13, further comprising:

generating separate database connections to said relational database for processing the data definition language statements and the data modification language statements.

16. The method according to claim 13, further comprising logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation.

17. The method according to claim 16, further comprising:

using relational database operations to commit changes made by the data modification language statements;

using the logged compensating operations to process the data definition language statements.

21. The method according to claim 13, further comprising logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation.

22. The method according to claim 21, further comprising:

using relational database operations to commit changes made by the data modification language statements; and

,

using the logged compensating operations to process the data definition language statements.

18. 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 a plurality of commands from an application directed to the relational database, the plurality of commands including data definition language statements and data modification language statements, logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation, and using the logged compensating operations to rollback the data definition language statements.

19. The apparatus according to claim 18, further comprising:

when performing a rollback operation for said application, using relational database operations to rollback the data modification language statements.

20. The method according to claim 18, further comprising:

generating separate database connections to said relational database for processing the data definition language statements and the data modification lanugage statements.

23. 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 with the computer, the method comprising the steps of:

receiving a plurality of commands from an application directed to the regulational database, the plurality of commands including data definition language statements and data modification language statements;

logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation; and

,

using the logged compensating operations to rollback the data definition language statements.

24. The article of manufacture according to claim 23, further comprising:

when performing a rollback operation for said application, using relational database operations to rollback the data modification language statements.

25. The method according to claim 23, further comprising:

generating separate database connections to said relational database for processing the data definition language statements and the data modification language statements.

26. The method according to claim 23, further comprising logging one or more compensating operations for each data definition language statement, wherein each compensating operation corresponds to an action to be performed for a rollback or a commit operation.

27. The method according to claim 26, further comprising:

using relational database operations to commit changes made by the data modification language statements; and

,

using the logged compensating operations to process the data definition language statements.