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

• US 7,089,262 B2
• Filed: 02/26/2003
• Issued: 08/08/2006
• 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): Mofiz, Apu M.
• Application Number:
  US10/375,694
• Publication Number:
  US 20030204514A1
• Time in Patent Office: 1,259 Days
• Field of Search: 707/4, 707/100, 707/101, 707/103.R, 705/34, 717/137, 717/141
• 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. In a computer system, a method of storing objects in a relational database, comprising the steps of:

defining a class of objects that are to be stored in the relational database, the objects of the class having at least one data member;

receiving input of a characteristic of the data member;

mapping the data member to at least one column in at least one relational database table;

creating the at least one relational database table to store the objects of the class;

instantiating a container object to store the data member;

transiently storing the data member in the container object;

generating a hierarchical tree that represents a definition of the data members of the class of objects;

storing a default value for the data member in the hierarchical tree; and

initializing an optional data member.

2. The method of claim 1, further comprising storing a hierarchy of classes in the hierarchical tree.

3. The method of claim 2, wherein the hierarchy of classes includes the class.

4. The method of claim 3, wherein the container object is created utilizing the hierarchical tree, wherein the hierarchical tree comprises a definition of the data member.

5. The method of claim 1, wherein the creating step comprises the steps of:

generating SQL statements for creating the at least one relational database table; and

sending the SQL statements to a relational database management system.

6. The method of claim 1, further comprising defining a subclass of objects, wherein the objects of the subclass inherit the data members of the class of objects and have at least one additional data member.

7. The method of claim 6, further comprising storing an object of the subclass in the relational database.

8. The method of claim 6, further comprising the steps of:

generating SQL statements for creating an additional relational database table to store the at least one additional data member; and

sending the SQL statements to a relational database management system.

9. The method of claim 1, wherein the at least one data member of the objects of the class comprise an array.

10. The method of claim 9, further comprising late allocation of array elements.

11. The method of claim 1, wherein the characteristic indicates the data member is read only.

12. The method of claim 1, wherein the characteristic indicates the default value for the data member.

13. In a computer system, a method of storing objects in a relational database, comprising the steps of:

defining a first class of objects that are to be stored in the relational database, the objects of the class having at least one data member;

mapping each data member to at least one column in at least one relational database table; and

creating the at least one relational database table to store the objects of the class;

abstaining from allocating storage space in the relational database table for the data member;

later changing the data member to a non-default value; and

later allocating storage space in the relational database table for the data member.

14. The method of claim 13, further comprising receiving input of a characteristic of the data member.

15. The method of claim 13, wherein defining comprises inheriting a characteristic of the data member from a second class of objects.

16. The method of claim 13, further comprising sending a call to store the object of the class.

17. The method of claim 16, wherein sending a call further comprises storing a pointer to the object.

18. The method of claim 13, wherein defining comprises setting a default value for the data member.

19. The method of claim 18, wherein setting a default value comprises storing the default value in the hierarchical tree.