Support for RDBMS in LDAP system

• US 20050080792A1
• Filed: 10/09/2003
• Published: 04/14/2005
• Est. Priority Date: 10/09/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Ghatare, Sanjay P.
• Granted Patent: US 7,882,132 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A mapping scheme is disclosed so that data can be communicated between a relational database and a system that represents data in a manner different than the relational database. In one embodiment, the mapping scheme uses a mapping catalog that identifies attributes, columns and tables in the relational database that store data for the attributes, and relations between tables in order to determine how to access the attributes.

Claims

1. A method of providing for mapping between data formats, comprising:

accessing a first data format, said first data format includes objects, said objects include attributes;

accessing a relational database format that uses tables, said tables store data for said attributes; and

creating a customized mapping catalog for said relational database format, said mapping catalog maps said attributes of said objects to said tables of said relational database format.

2. A method according to claim 1, wherein:

said first data format is a logical object class format.

3. A method according to claim 1, wherein:

said first data format uses an LDAP format.

4. A method according to claim 1, wherein:

said first data format is hierarchical.

5. A method according to claim 1, wherein:

one or more of said attributes are multi-valued.

6. A method according to claim 1, wherein:

said relational database format can be any normalized relational database schema.

7. A method according to claim 1, wherein:

said relational database format pertains to an existing relational database, said mapping catalog is customized for a schema of said existing relational database.

8. A method according to claim 1, wherein:

said mapping catalog includes a mapped column in one of said tables for said attributes.

9. A method according to claim 1, wherein:

said mapping catalog includes, for a first attribute, an indication of a column in a master table for linking to first data in another table, said first data is for said first attribute.

10. A method according to claim 1, wherein:

said mapping catalog includes, for a first attribute, an indication of a first column in a first table for linking to first column in a second table and an indication of a second column in said second table for linking to a first column in a third table, said first column in said third table is for said first attribute.

11. A method according to claim 1, wherein:

said step of creating a customized mapping catalog includes classifying attributes based on column and table in said relational database format.

12. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying an attribute that is a primary key for a master table and inserting said attribute that is said primary key with a column identification for said primary key into said mapping catalog.

13. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first attribute that corresponds to a first column in said master table other than a primary key and inserting said first attribute with a column identification for said first column into said mapping catalog.

14. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first attribute that corresponds to a first column in said master table, said first column that depends from a second column that is not a primary key column; and

inserting said first attribute, an identification of said first column, and an indication of said second column into said mapping catalog.

15. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first attribute that corresponds to a first column in a first table, a second column of said first table links to a primary key column in a master table; and

inserting said first attribute, an identification of said primary key column, and an indication of said second column of said first table into said mapping catalog.

16. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first attribute that corresponds to a first column in a first table, said first column in said first table is part of a primary key for said first table, said primary key for said first table also includes a second column of said first table;

said second column of said first table links to a primary key column in a master table; and

inserting said first attribute, an identification of said first column, an indication of said second column and an indication of said primary key column into said mapping catalog.

17. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first attribute that corresponds to a first column in a first table, said first table includes a second column, said second column of said first table links to a first column of a second table, said second table includes a second column, said second column of said second table links to a primary key column of a master table; and

inserting said first attribute, an identification of said first column of said first table, an indication of said second column of said first table, an identification of said first column of said second table, an indication of said second column of said second table and an indication of said primary key column into said mapping catalog.

18. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first multi-valued attribute that corresponds to a set of primary key column values from a master table, where for each of said set of primary key column values a non-primary key column value matches a particular primary key column value; and

inserting said first attribute, an indication of a primary key column corresponding to said set of primary key column values and an indication of a non-primary key column corresponding to said non-primary key column value into said mapping catalog.

19. A method according to claim 1, wherein said step of creating a customized mapping catalog comprises:

identifying a first multi-valued attribute that corresponds to a first non-primary key column, where for each of value of said first multi-valued attribute a second non-primary key column matches a particular value; and

inserting said first attribute, an indication of first non-primary key column, an indication of a column associated with said particular value and an indication of a primary key column.

20. A method of providing for mapping between data formats, comprising:

accessing a first data format, said first data format includes objects, said objects include attributes;

accessing a preexisting relational database that includes tables, said tables store data for said attributes; and

creating a customized mapping for said preexisting relational database, said mapping maps said attributes of said objects to said tables of said accessed relational database format.

21. A method according to claim 20, wherein:

said first data format is a hierarchical logical object class format.

22. A method according to claim 20, wherein:

said first data format uses an LDAP format.

23. A method according to claim 20, wherein:

said relational database can have any normalized relational database schema.

24. A method according to claim 20, wherein:

said step of creating a customized mapping includes classifying attributes based on column and table in said relational database.

25. One or more processor readable storage devices having processor readable code embodied on said processor readable storage devices, said processor readable code for programming one or more processors, said processor readable code comprising:

code to implement Identity System business logic; and

code to implement a data source layer to interface with said Identity System business logic and a relational database, said code to implement said data source layer includes code that accesses a mapping catalog customizable for any normalized relational database schema and uses said mapping catalog to access data in said relational database on behalf of said Identity System business logic.

26. One or more processor readable storage devices according to claim 25, wherein:

said code to implement Identity System business logic uses an LDAP format with attributes; and

data for said attributes is stored in said relational database.

27. One or more processor readable storage devices according to claim 25, wherein:

said code to implement Identity System business logic uses a hierarchical logical object class format with attributes; and

data for said attributes is stored in said relational database.

28. One or more processor readable storage devices according to claim 25, wherein:

said mapping catalog includes mapped columns for said attributes, said mapped columns are in tables of said relational database.

29. One or more processor readable storage devices according to claim 25, wherein:

said mapping catalog includes, for a first attribute, an indication of a column in a master table for linking to first data in another table, said first data is for said first attribute.

30. One or more processor readable storage devices according to claim 25, wherein:

said mapping catalog includes, for a first attribute, an indication of a first column in a first table for linking to first column in a second table and an indication of a second column in said second table for linking to a first column in a third table, said first column in said third table is for said first attribute.

31. A method of using a mapping between data formats, comprising:

receiving a request to access data for a first attribute, said request identifies said data in a first data format, said first data format includes objects, said objects include one or more attributes;

accessing a mapping catalog customizable for a relational database schema, said mapping catalog identifies a portion of a table in a relational database that stores said data for said first attribute; and

accessing said portion of said table in said relational database that stores said data for said first attribute based on said mapping catalog.

32. A method according to claim 31, wherein:

said first format includes an LDAP format.

33. A method according to claim 31, wherein:

said first format includes a hierarchical logical object class format.

34. A method according to claim 31, wherein:

said mapping catalog includes mapped columns for said attributes, said mapped columns are in tables of said relational database.

35. A method according to claim 31, wherein:

said mapping catalog includes, for said first attribute, an indication of a column in a master table for linking to first data in another table, said first data is for said first attribute.

36. A method according to claim 31, wherein:

said mapping catalog includes, for said first attribute, an indication of a first column in a first table for linking to first column in a second table and an indication of a second column in said second table for linking to a first column in a third table, said first column in said third table is for said first attribute.

37. One or more processor readable storage devices having processor readable code embodied on said processor readable storage devices, said processor readable code for programming one or more processors to perform a method comprising:

receiving a request to access data for a first attribute, said request identifies said data in a first data format, said first data format includes objects, said objects include one or more attributes;

accessing a mapping catalog customizable for a relational database schema, said mapping catalog identifies a portion of a table in a relational database that stores said data for said first attribute; and

accessing said portion of said table in said relational database that stores said data for said first attribute based on said mapping catalog.

38. One or more processor readable storage devices according to claim 37, wherein:

said first format includes an LDAP format.

39. One or more processor readable storage devices according to claim 37, wherein:

said first format includes a hierarchical logical object class format.

40. One or more processor readable storage devices according to claim 37, wherein:

said mapping catalog includes mapped columns for said attributes, said mapped columns are in tables of said relational database.

41. One or more processor readable storage devices according to claim 37, wherein:

said mapping catalog includes, for said first attribute, an indication of a column in a master table for linking to first data in another table, said first data is for said first attribute.

42. One or more processor readable storage devices according to claim 37, wherein:

said mapping catalog includes, for said first attribute, an indication of a first column in a first table for linking to first column in a second table and an indication of a second column in said second table for linking to a first column in a third table, said first column in said third table is for said first attribute.

43. An apparatus that maps between data formats, comprising:

means for receiving a request to access data for a first attribute, said request identifies said data in a first data format, said first data format includes objects, said objects include one or more attributes;

means for accessing a mapping catalog customizable for a relational database schema, said mapping catalog identifies a portion of a table in a relational database that stores said data for said -first attribute; and

means for accessing said portion of said table in said relational database that stores said data for said first attribute based on said mapping catalog.

44. An apparatus according to claim 43, wherein:

said mapping catalog includes, for said first attribute, an indication of a first column in a first table for linking to first column in a second table and an indication of a second column in said second table for linking to a first column in a third table, said first column in said third table is for said first attribute.