US5987465A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System, method and computer program product for positioned update support
Assignee: International Business Machines Corp
•
Filing: 1997-09-25
•
Granted: 1999-11-16
•
Expires: 2017-09-25
Abstract
Abstract A system, method and computer program product for providing a common interface to a plurality of heterogeneous database management systems, wherein date associated with a client is distributed among the plurality of hetergeneous database management systems. The system simulates support of positioned update actions in any of the heterogeneous database management systems which does not support positioned update actions.
Inventors
- 👤 James C. Kleewein
- 👤 Eileen T. Lin
- 👤 Yun Wang
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 16:45
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/256; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99939; Y10S707/99941; Y10S707/99943; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 9
Claim 1
Independent Claim
132 words
A method for proving a common interface for performing update actions in a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among said plurality of heterogeneous database management systems, comprising the steps of: (a) simulating support of positioned update actions in any of said heterogeneous database management systems which does not support positioned update actions, by: (1) accessing metadata that identifies at least one primary key defined for a table; (2) using the primary keys to obtain record identification information that uniquely identifies a record being modified by a positioned update action, wherein said positioned update action updates a record at a current position of a specified cursor; and (3) requesting that said target database management system modify a record identified by said record identification information.
Claim 2
Independent Claim
132 words
A method for proving a common interface for performing update actions in a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among said plurality of heterogeneous database management systems, comprising the steps of: (a) simulating support of positioned update actions in any of said heterogeneous database management systems which does not support positioned update actions, by: (1) accessing metadata that identifies at least one primary key defined for a table; (2) using the primary keys to obtain record identification information that uniquely identifies a record being modified by a positioned update action, wherein said positioned update action updates a record at a current position of a specified cursor; and (3) requesting that said target database management system modify a record identified by said record identification information.
Claim 3
Dependent Claim
23 words
The method of claim 1, further comprising the step of determining whether the information obtained in said step (2) uniquely identifies a record.
Claim 4
Independent Claim
133 words
A system for providing a common interface for performing update actions in a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among said plurality of heterogeneous database management systems, comprising: means for simulating support of positioned update actions in any of said heterogeneous database management systems which does not support positioned update actions, including; means for accessing metadata that identifies at least one primary key defined for a table; means for using the primary keys to obtaining record identification information that uniquely identifies a record being modified by a positioned update action, wherein said positioned update action updates a record at a current position of a specified cursor; and means for requesting that said target database management system modify a record identified by said record identification information.
Claim 5
Independent Claim
133 words
A system for providing a common interface for performing update actions in a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among said plurality of heterogeneous database management systems, comprising: means for simulating support of positioned update actions in any of said heterogeneous database management systems which does not support positioned update actions, including; means for accessing metadata that identifies at least one primary key defined for a table; means for using the primary keys to obtaining record identification information that uniquely identifies a record being modified by a positioned update action, wherein said positioned update action updates a record at a current position of a specified cursor; and means for requesting that said target database management system modify a record identified by said record identification information.
Claim 6
Dependent Claim
23 words
The system of claim 3, further comprising means for determining whether the information obtained by said means for obtaining uniquely identifies a record.
Claim 7
Dependent Claim
205 words
A computer program product for use with a computer system, said computer program product comprising: a computer usable medium having computer readable program code means embodied in said medium for causing the computer system to provide a common interface for performing update actions in a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among said plurality of heterogeneous database management systems, said computer readable program code means comprising: first computer readable program code means for simulating support of positioned update actions in any of said heterogeneous database management systems which does not support positioned update actions, including: second computer readable program code means for enabling the computer system to access metadata that identifies at least one primary key defined for a table; third computer readable program code means for enabling the computer system to use the primary keys to obtain record identification information that uniquely identifies a record being modified by a positioned update action, wherein said positioned update action updates a record at a current position of a specified cursor, and fourth computer readable program code means for enabling the computer system to request that said database management system modify a record identified by said record identification information.
Claim 8
Dependent Claim
205 words
A computer program product for use with a computer system, said computer program product comprising: a computer usable medium having computer readable program code means embodied in said medium for causing the computer system to provide a common interface for performing update actions in a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among said plurality of heterogeneous database management systems, said computer readable program code means comprising: first computer readable program code means for simulating support of positioned update actions in any of said heterogeneous database management systems which does not support positioned update actions, including: second computer readable program code means for enabling the computer system to access metadata that identifies at least one primary key defined for a table; third computer readable program code means for enabling the computer system to use the primary keys to obtain record identification information that uniquely identifies a record being modified by a positioned update action, wherein said positioned update action updates a record at a current position of a specified cursor, and fourth computer readable program code means for enabling the computer system to request that said database management system modify a record identified by said record identification information.
Claim 9
Dependent Claim
37 words
The computer program product of claim 5, firer comprising computer readable program code means for enabling the computer system to determine whether the information obtained by said second computer readable program code means uniquely identifies a record.
References Cited (Backward Citations)
US4714989A
Cited
US4714995A
Cited
US5046002A
Cited
US5058000A
Cited
US4881166A
Cited
US5301302A
Cited
US5345587A
Cited
US5375207A
Cited
US5161158A
Cited
US5278978A
Cited
US5416917A
Cited
US5257366A
Cited
US5381534A
Cited
US5142470A
Cited
US5239577A
Cited
US5390320A
Cited
US5247664A
Cited
US5522066A
Cited
US5459860A
Cited
US5581758A
Cited
US5581749A
Cited
US5561797A
Cited
US5493671A
Cited
US5640550A
Cited
US5689633A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-11-15 | 2003-05-17 | 2003-11-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-15 | 2007-05-17 | 2007-11-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-15 | 2011-05-17 | 2011-11-16 | $7700.00 | Window Closed / Lapsed |