US6480848B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements
Assignee: International Business Machines Corp
•
Filing: 1999-07-19
•
Granted: 2002-11-12
•
Expires: 2019-07-19
Abstract
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.
Inventors
- 👤 Daniel Martin DeKimpe
- 👤 William Earl Malloy
- 👤 Craig Reginald Tomlyn
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 05:06
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99937; Y10S707/99938
Claims Analysis
Total Claims: 36
Claim 1
Independent Claim
125 words
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.
Claim 2
Independent Claim
125 words
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.
Claim 3
Dependent Claim
48 words
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.
Claim 4
Independent Claim
133 words
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.
Claim 5
Independent Claim
133 words
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.
Claim 6
Dependent Claim
49 words
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.
Claim 7
Dependent Claim
147 words
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.
Claim 8
Dependent Claim
147 words
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.
Claim 9
Dependent Claim
50 words
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.
Claim 10
Independent Claim
133 words
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.
Claim 11
Independent Claim
133 words
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.
Claim 12
Independent Claim
143 words
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.
Claim 13
Independent Claim
143 words
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.
Claim 14
Dependent Claim
155 words
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.
Claim 15
Dependent Claim
155 words
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.
Claim 16
Dependent Claim
40 words
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.
Claim 17
Dependent Claim
42 words
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.
Claim 18
Dependent Claim
42 words
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.
Claim 19
Independent Claim
100 words
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.
Claim 20
Independent Claim
100 words
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.
Claim 21
Dependent Claim
28 words
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.
Claim 22
Dependent Claim
30 words
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.
Claim 23
Dependent Claim
39 words
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.
Claim 24
Dependent Claim
35 words
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.
Claim 25
Independent Claim
107 words
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.
Claim 26
Independent Claim
107 words
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.
Claim 27
Dependent Claim
28 words
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.
Claim 28
Dependent Claim
30 words
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.
Claim 29
Dependent Claim
39 words
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.
Claim 30
Dependent Claim
36 words
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.
Claim 31
Dependent Claim
125 words
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.
Claim 32
Dependent Claim
125 words
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.
Claim 33
Dependent Claim
30 words
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.
Claim 34
Dependent Claim
30 words
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.
Claim 35
Dependent Claim
39 words
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.
Claim 36
Dependent Claim
36 words
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.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-11-11 | 2006-05-13 | 2006-11-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-11-11 | 2010-05-13 | 2010-11-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-11-11 | 2014-05-13 | 2014-11-12 | $7700.00 | Window Closed / Lapsed |