US6711582B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and system for implementing persistent object services on a relational database
Assignee: International Business Machines Corp
•
Filing: 2002-06-25
•
Granted: 2004-03-23
•
Expires: 2022-06-25
Abstract
Abstract A persistent object service (POS) that interfaces to a set of one or more relational database management systems. A persistent object is mapped to one or more tables in a relational database based on the object's attribute types and the object's relationships with other objects. If the object inherits from another object, the mapping creates multiple tables, a top level table for base attributes, and a set of one or more child tables that contain extended attributes of the inherited objects. A routine for storing an object converts persistent object operations to a sequence of SQL statements for storing the object in the relational database.
Inventors
- 👤 Amy S. Aldridge
- 👤 Suresh Narayana Murthy
- 👤 Gordon Scott Rulong
- 👤 Tingting Xu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 13:01
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99933; Y10S707/99941; Y10S707/99942; Y10S707/99943; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 19
Claim 1
Independent Claim
95 words
A method of storing object information in a relational database, comprising the steps of: extracting object information relating to an object from a stream; constructing an initial SQL statement from the extracted object information; responsive to a failure of the initial SQL statement, constructing a second SQL statement from the extracted object information, wherein the initial SQL statement is an insert statement and the second SQL statement is an update statement, or wherein the initial SQL statement is an update statement and the second SQL statement is an insert statement; and storing the object information.
Claim 2
Independent Claim
95 words
A method of storing object information in a relational database, comprising the steps of: extracting object information relating to an object from a stream; constructing an initial SQL statement from the extracted object information; responsive to a failure of the initial SQL statement, constructing a second SQL statement from the extracted object information, wherein the initial SQL statement is an insert statement and the second SQL statement is an update statement, or wherein the initial SQL statement is an update statement and the second SQL statement is an insert statement; and storing the object information.
Claim 3
Dependent Claim
24 words
The method as described in claim 1 wherein an insert statement fails if information for the object is already present in the relational database.
Claim 4
Dependent Claim
18 words
The method as described in claim 1 wherein the object information is stored according to the initial statement.
Claim 5
Dependent Claim
18 words
The method as described in claim 1 wherein the object information is stored according to the second statement.
Claim 6
Dependent Claim
35 words
The method as described in claim 1 wherein the object information is mapped to one or more tables in the relational database according to attributes in the object and their respective relationships with other objects.
Claim 7
Dependent Claim
35 words
The method as described in claim 5 wherein a base table in the relational database has a set of base attributes and a set of one or more child tables related to the base table.
Claim 8
Dependent Claim
19 words
The method as described in claim 6 wherein a given child table includes only extended attributes of inherited objects.
Claim 9
Dependent Claim
19 words
The method as described in claim 1 wherein the relational database is one of a set of relational databases.
Claim 10
Independent Claim
99 words
An apparatus for storing object information in a relational database, the apparatus comprising: means for extracting object information relating to an object; means for constructing an initial SQL statement from the extracted object information; means responsive to a failure of the initial SQL statement for constructing a second SQL statement from the extracted object information, wherein the initial SQL statement is an insert statement and the second SQL statement is an update statement, or wherein the initial SQL statement is an update statement and the second SQL statement is an insert statement; and means for storing the object information.
Claim 11
Independent Claim
99 words
An apparatus for storing object information in a relational database, the apparatus comprising: means for extracting object information relating to an object; means for constructing an initial SQL statement from the extracted object information; means responsive to a failure of the initial SQL statement for constructing a second SQL statement from the extracted object information, wherein the initial SQL statement is an insert statement and the second SQL statement is an update statement, or wherein the initial SQL statement is an update statement and the second SQL statement is an insert statement; and means for storing the object information.
Claim 12
Dependent Claim
36 words
The apparatus as described in claim 9 further including means for mapping object information to one or more tables in the relational database according to attributes in the object and their respective relationships with other objects.
Claim 13
Dependent Claim
39 words
The apparatus as described in claim 9 wherein the mapping means generates a base table in the relational database having a set of base attributes and a set of one or more child tables related to the base table.
Claim 14
Dependent Claim
19 words
The apparatus as described in claim 11 wherein a given child table includes only extended attributes of inherited objects.
Claim 15
Dependent Claim
115 words
A computer program product in a computer readable medium for use in a data processing system for storing object information in a relational database, the computer program product comprising: means for extracting object information relating to an object; means for constructing an initial SQL statement from the extracted object information; means responsive to a failure of the initial SQL statement for constructing a second SQL statement from the extracted object information, wherein the initial SQL statement is an insert statement and the second SQL statement is an update statement, or wherein the initial SQL statement is an update statement and the second SQL statement is an insert statement; and means for storing the object information.
Claim 16
Dependent Claim
115 words
A computer program product in a computer readable medium for use in a data processing system for storing object information in a relational database, the computer program product comprising: means for extracting object information relating to an object; means for constructing an initial SQL statement from the extracted object information; means responsive to a failure of the initial SQL statement for constructing a second SQL statement from the extracted object information, wherein the initial SQL statement is an insert statement and the second SQL statement is an update statement, or wherein the initial SQL statement is an update statement and the second SQL statement is an insert statement; and means for storing the object information.
Claim 17
Dependent Claim
38 words
The computer program product as described in claim 13 further including means for mapping object information to one or more tables in the relational database according to attributes in the object and their respective relationships with other objects.
Claim 18
Dependent Claim
41 words
The computer program product as described in claim 13 wherein the mapping means generates a base table in the relational database having a set of base attributes and a set of one or more child tables related to the base table.
Claim 19
Dependent Claim
21 words
The computer program product as described in claim 15 wherein a given child table includes only extended attributes of inherited objects.
References Cited (Backward Citations)
US5369761A
Cited
US5297279A
Cited
US5291583A
Cited
US5295256A
Cited
US5499371A
Cited
US5694598A
Cited
US5546576A
Cited
US5734887A
Cited
US5864843A
Cited
US5754841A
Cited
US5809506A
Cited
US5809507A
Cited
US5761671A
Cited
US5787436A
Cited
US5794247A
Cited
US5794248A
Cited
US6076090A
Cited
US6163776A
Cited
US6175829B1
Cited
US6470354B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-03-23 | 2007-09-22 | 2008-03-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-03-23 | 2011-09-22 | 2012-03-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-03-23 | 2015-09-22 | 2016-03-23 | $7700.00 | Window Closed / Lapsed |