Support for multiple mechanisms for accessing data stores

• US 7,512,585 B2
• Filed: 12/09/2002
• Issued: 03/31/2009
• Est. Priority Date: 07/11/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Agarwal, Sachin, Thiyagarajan, Lakshmi V.
• Primary Examiner(s): Breene; John E
• Assistant Examiner(s): COLAN, GIOVANNA B
• Application Number:
  US10/314,888
• Publication Number:
  US 20040024762A1
• Time in Patent Office: 2,304 Days
• Field of Search: 705/39, 705/36, 713/201, 707/200, 707/10, 707/3, 707/203, 726/12, 709/220
• US Class Current: 1/1
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

Technology is disclosed for supporting the use of multiple access mechanisms for accessing one or more data stores. Examples of access mechanisms include the LDAP protocol and the ADSI protocol. One embodiment of the present invention includes maintaining an association of access mechanisms to types of data store operations such that two or more types of data store operations for a first data store can be associated with different access mechanisms. The system receives a first operation for the first data store, where the first operation is of a first type of data store operation. The system accesses the first data store to perform the first operation using an access mechanism associated with the first type of data store operation.

Claims

1. A method of using multiple access mechanisms to communicate with a data store using a computing device, the computing device including a processor and a processor readable storage device, the method comprising:

the data store maintaining two or more profiles, the profile associated with a data store, for containing associations of one or more data store operations with the data store and containing associations of access mechanisms to types of data store operations such that two or more types of data store operations for a first data store can be associated with a plurality of different access mechanisms, the plurality of access mechanisms comprising a first access mechanism that is associated with a first type of data store operation and a second access mechanism that is associated with a Second type of data store operation, the first access mechanism providing a first interface for accessing the first data store, the first interface comprising a first access protocol;

the processor receiving a first operation for the first data store, the first operation is of the first type of data store operation;

the processor calling the profile associated with the first data store to determine whether the first data store can perform the first type of data store operation;

the processor determining from the profile that the first access mechanism is associated with the first operation;

the processor accessing the first data store to perform the first operation using the first access mechanism;

the processor accessing the first data store to perform the second operation using the second access mechanism; and

the processor providing the results of the first operation.

2. A method according to claim 1, wherein:

the first access protocol is Lightweight Directory Access Protocol (“

LDAP”

).

3. A method according to claim 1, wherein:

the first access protocol is Lightweight Directory Access Protocol (“

LDAP”

) over Secure Sockets Layer (“

SSL”

).

4. A method according to claim 1, wherein:

the first access protocol is Active Directory Services Interface (“

ADSI”

).

5. A method according to claim 1, wherein:

the first type of operation is a modify operation.

6. A method according to claim 5, wherein:

the first operation is an attempt to modify a specific attribute in a user profile.

7. A method according to claim 1, wherein:

the first data store is used to store identity profiles.

8. A method according to claim 1, wherein:

the steps of maintaining, receiving and accessing are performed as part of an identity system.

9. A method according to claim 1, wherein:

the steps of maintaining, receiving and accessing are performed as part of an access system.

10. A method according to claim 1, wherein:

the steps of maintaining, receiving and accessing are performed as part of an integrated access system and identity system.

11. A method according to claim 1, wherein:

the step of maintaining includes maintaining association of access mechanisms to types of data store operations for multiple data stores capable of utilizing multiple access mechanisms.

12. A method according to claim 1, wherein:

the first operation is received as part of a first access request, the first access request includes multiple operations of different types of data store operations associated with different access mechanisms.

13. A method according to claim 1, further comprising the step of:

changing the association of access mechanisms to types of data store operations, the steps of maintaining, changing and accessing are performed by a system while the system is live.

14. A method according to claim 1, further comprising the step of:

receiving a second operation for the first data store, the second operation is of a second type of data store operation; and

accessing the first data store to perform the second operation using the second access mechanism associated with the second type of data store operation.

15. A method according to claim 14, wherein:

the steps of receiving a second operation and accessing the first data store to perform the second operation are performed concurrently with the steps of receiving a first operation and accessing the first data store to perform the first operation.

16. A method according to claim 15, further comprising the step of:

changing the association of access mechanisms to types of data store operations, the steps of maintaining, changing and accessing are performed by a system while the system is live, the first data store is used to store identity profiles.

46. A method according to claim 1, wherein maintaining associations of access mechanisms to types of data store operations comprises:

maintaining a profile for the first data store; and

storing in the profile the associations of access mechanisms to types of data store operations.

17. A method of using multiple access mechanisms to communicate with a data store using a computing device, the computing device including a processor and a processor readable storage device, the method comprising the steps of:

the data store maintaining a profile, the profile associated with the data store, wherein the profile associates a first type of operation with a first mechanism for accessing a first data store and associates a second type of operation with a second mechanism for accessing the first data store, the first access mechanism provides a first interface for accessing the first data store, the first interface comprising a first access protocol, and the second access mechanism providing second interface for accessing the first data store, the second interface comprising a second access protocol;

the processor receiving a first operation and a second operation, the first operation is of a first type of operation, the second operation is of the second type of operation;

the processor calling the profile to determine the first access mechanism is associated with the first operation and the second access mechanism is associated with the second operation;

the processor accessing the first data store to perform the first operation using the first access mechanism;

the processor accessing the first data store to perform the second operation using the second access mechanism; and

the processor providing the results of the first operation and the second operation.

18. A method according to claim 17, wherein:

the steps of receiving, accessing the first data store to perform the first operation and accessing the first data store to perform the second operation are performed as part of an identity system.

19. A method according to claim 17, wherein:

the steps of receiving, accessing the first data store to perform the first operation and accessing the first data store to perform the second operation are performed as part of an access system.

20. A method according to claim 17, wherein:

the steps of receiving, accessing the first data store to perform the first operation and accessing the first data store to perform the second operation are performed as part of an integrated access system and identity system.

47. A method according to claim 17, wherein the first operation comprises an authentication operation, and wherein the second operation comprises an authorization operation.

48. A method according to claim 47, wherein the access protocol is Active Directory Services Interface (“

ADSI”

), and wherein the second access protocol is Lightweight Directory Access Protocol (“

LDAP”

).

21. A system, having a processor and memory, the processor capable of using multiple access mechanisms to communicate with a data store, the processor executing components, the components comprising:

a profile, stored in the memory and accessed by the processor, the profile having one or more associations of access mechanisms to types of data store operations such that a first access mechanism is associated with a first type of data store operation and a second access mechanism is associated with a second type of data store operation, the first access mechanism providing a first interface for accessing the first data store, the first interface comprising a first access protocol;

a database manager, the database manager operable to call the profile to determine whether the data store can perform the data store operation, the database manager operable to determine an agent to forward data store operations;

a database proxy, the database proxy created by the database manager, the database proxy operable to interact with the agent determined by the database manager; and

the agent, executable by the processor, capable of receiving requests to perform operations of various types of data store operations and accessing the first data store using appropriate one or more access mechanisms based on the associations.

22. A system according to claim 21, wherein:

the agent is used to access identity profiles stored on the first data store.

23. A system according to claim 21, wherein:

the associations are maintained for an identity system.

24. A system according to claim 21, wherein:

the associations are maintained for an access system.

25. A system according to claim 21, wherein:

the associations are maintained for an integrated access system and identity system.

26. A system according to claim 21, wherein:

the associations includes associations of access mechanisms to types of data store operations for multiple data stores capable of utilizing multiple access mechanisms.

27. A system according to claim 21, wherein:

the associations can be changed while the agent is live.

28. A system according to claim 27, wherein:

the associations are maintained for an integrated access system and identity system.

29. An apparatus, comprising:

one or more storage devices having processor readable code embodied on the processor readable storage devices, the processor readable code for programming one or more processors; and

one or more processors in communication with the one or more storage devices, the processor executable code comprising;

code for maintaining two or more profiles, the profile associated with a data store, for containing associations of one or more data store operations with the data store and containing associations of access mechanisms to types of data store operations such that two or more types of data store operations for a first data store can be associated with a plurality of different access mechanisms, the plurality of access mechanisms comprising a first access mechanism that is associated with a first type of data store operation and a second access mechanism that is associated with a second type of data store operation, the first access mechanism providing a first interface for accessing the first data store, the first interface comprising a first access protocol;

code for receiving a first operation for the first data store, the first operation is o the first type of data store operation;

code for calling the profile associated with the first data store to determine whether the first data store can perform the first type of data store operation;

code for determining from the profile that the first access mechanism is associated with the first operation;

code for accessing the first data store to perform the first operation using an access mechanism;

code for accessing the first data store to perform the second operation using the second access mechanism; and

code for providing the results of the first operation.

30. An apparatus according to claim 29, wherein:

the code for maintaining includes code for maintaining associations of access mechanisms to types of data store operations for multiple data stores capable of utilizing multiple access mechanisms.

31. An apparatus according to claim 29, wherein the processor readable code further comprises:

code for changing the associations of access mechanisms to types of data store operations, the code for maintaining, changing and accessing are performed by the system while the system is live.

32. One or more processor readable storage devices having processor readable code embodied on the processor readable storage devices, the processor readable code for programming one or more processors and comprising:

code for maintaining one or more profiles containing associations of one or more data store operations with the data store and containing associations of access mechanisms to types of data store operations such that two or more types of data store operations for a first data store can be associated with a plurality of different access mechanisms, the plurality of access mechanisms comprising a first access mechanism that is associated with a first type of data store operation and a second access mechanism that is associated with a second type of data store operation, the first access mechanism providing a first interface for accessing the first data store, the first interface comprising a first access protocol;

code for receiving a first operation for the first data store, the first operation is of the first type of data store operation;

code for calling the profile associated with the first data store to determine whether the first data store can perform the first type of data store operation;

code for determining from the profile that the first access mechanism is associated with the first operation;

code for accessing the first data store to perform the first operation using an access mechanism; and

code for providing the results of the first operation.

33. One or more processor readable storage devices according to claim 32, wherein:

the first data store is used to store identity profiles.

34. One or more processor readable storage devices according to claim 32, wherein:

the processor readable code is performed by an identity system.

35. One or more processor readable storage devices according to claim 32, wherein:

the processor readable code is performed by an access system.

36. One or more processor readable storage devices according to claim 32, wherein:

the processor readable code is performed by an integrated access system and identity system.

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

the code for of maintaining includes code for maintaining associations of access mechanisms to types of data store operations for multiple data stores capable of utilizing multiple access mechanisms.

38. One or more processor readable storage devices according to claim 32, wherein the processor readable code further comprises:

code for changing the association of access mechanisms to types of data store operations, the steps of maintaining, changing and accessing are performed by a system while the system is live.

39. One or more processor readable storage devices having processor readable code embodied on the processor readable storage devices, the processor readable code for programming one or more processors, the processor readable code capable of being used to create a system capable of using multiple access mechanism to communicate with a data store, the system comprising:

a profile, stored in the readable storage devices and accessed by the processor, the profile having one or more associations of access mechanisms to types of data store operations such that a first access mechanism is associated with a first type of data store operation and a second access mechanism is associated with a second type of data store operation, the first access mechanism providing a first interface for accessing the first data store, the first interface comprising a first access protocol;

a database manager, the database manager operable to call the profile to determine whether the data store can perform the data store operation, the database manager operable to determine an agent to forward data store operations;

a database proxy, the database proxy created by the database manager, the database proxy operable to interact with the agent determined by the database manager; and

the agent, executable by the processor, capable of receiving requests to perform operations of various types of data store operations and accessing the first data store using appropriate one or more access mechanisms based on the associations.

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

the agent is used to access identity profiles stored on the first data store.

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

the associations are maintained for an identity system.

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

the associations are maintained for an access system.

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

the associations are maintained for an integrated access system and identity system.

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

the associations includes associations of access mechanisms to types of data store operations for multiple data stores capable of utilizing multiple access mechanisms.

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

the associations can be changed while the agent is live.