US6047284A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for object oriented storage and retrieval of data from a relational database
Assignee: Oracle International Corp
•
Filing: 1997-05-14
•
Granted: 2000-04-04
•
Expires: 2017-05-14
Abstract
Abstract Systems and methods for accessing a relational database through an object-oriented querying interface are provided. A class of objects that are to be stored in the relational database are defined. One or more relational database tables are created and a mapping is produced that maps each data member of an object to one or more columns in a relational database table. Additionally, object-oriented paradigms like inheritance may be supported and the allocation of storage for array elements may be deferred until necessary.
Inventors
- 👤 Gary L. Owens
- 👤 David S. Labuda
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 12:33
CPC Classifications
G; G06; G06Q; G06Q40/00; G06Q40/02; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 10
Claim 1
Independent Claim
132 words
A computer implemented method of performing an object-oriented query for information stored in a relational database, comprising the steps of: receiving a first query that is object-oriented and specifies information about objects of interest; instantiating a query container object that comprises a query template based on the first query, an array for any arguments in the template query, and an array for any results in the template query; utilizing the query container object, translating the first query into a second query in a relational database query language for accessing the specified information about the objects of interest that are stored by a relational database management system; sending the second query to the relational database management system; and receiving the specified information about the objects of interest from the relational database management system.
Claim 2
Dependent Claim
132 words
A computer implemented method of performing an object-oriented query for information stored in a relational database, comprising the steps of: receiving a first query that is object-oriented and specifies information about objects of interest; instantiating a query container object that comprises a query template based on the first query, an array for any arguments in the template query, and an array for any results in the template query; utilizing the query container object, translating the first query into a second query in a relational database query language for accessing the specified information about the objects of interest that are stored by a relational database management system; sending the second query to the relational database management system; and receiving the specified information about the objects of interest from the relational database management system.
Claim 3
Dependent Claim
28 words
The method of claim 1, further comprising the step of utilizing a hierarchical tree to map data members of objects of interest to columns in the relational database.
Claim 4
Dependent Claim
25 words
The method of claim 1, further comprising the step of instantiating a results container object to store the specified information about the objects of interest.
Claim 5
Dependent Claim
24 words
The method of claim 1, further comprising the step of storing the specified information about the objects of interest in the query container object.
Claim 6
Dependent Claim
153 words
A computer program product that performs an object-oriented query for information stored in a relational database, comprising: computer code that receives a first query that is object-oriented and specifies information about objects of interest; computer code that instantiates a query container object that comprises a query template based on the first query, an array for any arguments in the template query, and an array for any results in the template query; computer code that, utilizing the query container object, translates the first query into a second query in a relational database query language for accessing the specified information about the objects of interest that are stored by a relational database management system; computer code that sends the second query to the relational database management system; computer code that receives the specified information about the objects of interest from the relational database management system; and a computer readable medium that stores the computer codes.
Claim 7
Dependent Claim
153 words
A computer program product that performs an object-oriented query for information stored in a relational database, comprising: computer code that receives a first query that is object-oriented and specifies information about objects of interest; computer code that instantiates a query container object that comprises a query template based on the first query, an array for any arguments in the template query, and an array for any results in the template query; computer code that, utilizing the query container object, translates the first query into a second query in a relational database query language for accessing the specified information about the objects of interest that are stored by a relational database management system; computer code that sends the second query to the relational database management system; computer code that receives the specified information about the objects of interest from the relational database management system; and a computer readable medium that stores the computer codes.
Claim 8
Dependent Claim
30 words
The computer program product of claim 5, further comprising computer code that utilizes a hierarchical tree to map data members of objects of interest to columns in the relational database.
Claim 9
Dependent Claim
27 words
The computer program product of claim 5, further comprising computer code that instantiates a results container object to store the specified information about the objects of interest.
Claim 10
Dependent Claim
26 words
The computer program product of claim 5, further comprising computer code that stores the specified information about the objects of interest in the query container object.
References Cited (Backward Citations)
US5291583A
Cited
US5295256A
Cited
US5212787A
Cited
US5448727A
Cited
US5426780A
Cited
US5530853A
Cited
US5499371A
Cited
WO1995004960A2
Cited
US5615362A
Cited
WO1995027255A1
Cited
US5694598A
Cited
US5765159A
Cited
US5893108A
Cited
WO1996034350A1
Cited
US5850544A
Cited
WO1997003406A1
Cited
US5797137A
Cited
WO1998052131A1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-04-04 | 2003-10-04 | 2004-04-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-04-04 | 2007-10-04 | 2008-04-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-04-04 | 2011-10-04 | 2012-04-04 | $7700.00 | Window Closed / Lapsed |