Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements
AssigneeInternational Business Machines Corporation
InventorsDaniel Martin DeKimpe, William Earl Malloy, Craig Reginald Tomlyn
Life of this patent
Estimating the term…
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.
Claims27
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.
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.
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.
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.
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.
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.
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.
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.
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.
Dependencies are inferred from the claim text.