Method and apparatus for object oriented storage and retrieval of data from a relational database

• US 6,047,284 A
• Filed: 05/14/1997
• Issued: 04/04/2000
• Est. Priority Date: 05/14/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Portal Software, Inc. (Oracle Corporation)
• Inventors: Labuda, David S., Owens, Gary L.
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US08/856,375
• Time in Patent Office: 1,056 Days
• Field of Search: 707/4, 707/101, 707/103, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

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.

Claims

1. 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.

2. 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.

3. 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.

4. The method of claim 1, further comprising the step of storing the specified information about the objects of interest in the query container object.

5. 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.

6. 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.

7. 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.

8. 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.