Method and system for representing and accessing object-oriented data in a relational database system

• US 6,834,286 B2
• Filed: 02/06/2001
• Issued: 12/21/2004
• Est. Priority Date: 12/07/1998
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Jain, Sanjay, Srinivasan, Uppili, Madan, Harpinder
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/778,235
• Publication Number:
  US 20010051948A1
• Time in Patent Office: 1,414 Days
• Field of Search: 707/103.R, 707/100, 707/101, 707/102, 707/104.1, 707/3-4, 707/10, 707/8, 707/201, 709/200, 709/230, 711/129, 711/156, 713/1, 713/200, 717/106
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• 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
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method and system for representing objects in a relational database is provided. In one aspect, the invention provides a method and system for storing directory information objects in a relational database management system. In addition, a method and system for generating a statement in a database query language to search or manipulate objects or entries that are stored in a relational database is disclosed. An aspect of the invention is directed to a method and system that can automatically generate a SQL statement for an LDAP search filter.

Claims

1. A system for representing object-oriented entities in a relational table comprising:

a database table comprising data identifying attribute values, said attribute values associated with respective attributes of an object that belongs to an object class;

one or more catalog tables associated with said database table, each of said one or more catalog tables corresponding to one of said attributes and comprising information that relates one or more of said attribute values that are associated with said one of said attributes to said object represented within said database table.

2. The system of claim 1 in which said object comprises a directory information object.

3. The system of claim 2 in which said directory information object comprises LDAP information.

4. The system of claim 2 in which said directory information object comprises X.500 information.

5. The system of claim 1 in which said database table comprises a column identifying attribute names.

6. The system of claim 1 in which said database table comprises a column identifying said attribute values.

7. The system of claim 1 in which said database table comprises a column identifying object identifiers.

8. The system of claim 1 in which said one or more catalog tables each comprises a row identifying an object identifier that correlates to one of said attribute values.

9. The system of claim 1 in which said attribute values are stored in said database table in a protocol ready format.

10. The system of claim 9 which said protocol ready format is the LDAP protocol format.

11. A system for representing object-oriented entities in relational tables comprising:

a database table comprising data identifying attributes of objects belonging to a plurality of object classes; and

a distinguished names table comprising information that identify unique system identification names for said objects represented in said database table.

12. The system of claim 11 in which said distinguished names table identifies full paths of parent objects for said objects.

13. The system of claim 12 in which said full paths of parent objects are stored with higher hierarchical levels of the paths listed before lower hierarchical levels of the paths of said parent objects.

14. The system of claim 11 in which said information from said distinghished names table identifies relative distinguished names of said objects.

15. A method for representing object-oriented entities in a relational table comprising:

storing attribute information for attributes of an object belonging to an object class in a database table, said database table comprising one row for each of said attributes; and

generating one or more catalog tables associated with said database table, each of said one or more catalog tables corresponding to one of said attributes and comprising information that relates one or more of said attribute values that are associated said one of said attribute to said object represented within said database table.

16. A method for representing object-oriented entities in a relational table comprising:

storing attribute information for attributes of objects belonging to a plurality of object classes in a database table, said database table comprising one row for each attribute;

storing identification data in a distinguished names table; and

said identification data identifying unique system identification names for said objects represented in said database table.