Centralized access and management for multiple, disparate data repositories

• US 7,599,959 B2
• Filed: 12/02/2002
• Issued: 10/06/2009
• Est. Priority Date: 12/02/2002
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Friedrich, Michael, Primbs, Alexander, Noe, Marc, Steigmann, Uwe
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Thai; Hanh B
• Application Number:
  US10/308,204
• Publication Number:
  US 20040107212A1
• Time in Patent Office: 2,500 Days
• Field of Search: 707 9- 10, 707/104.1, 707/202, 709202-203, 709/229
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

Systems and techniques to access data in a computer system provide centralized data storage management for facilitating access to a plurality of different data repositories. In general, in one implementation, the technique includes sending a data access request to a data storage manager and identifying at least one of a plurality of repositories for satisfying the data access request. The repositories may be of different types. In addition, data may be partitioned among the repositories according to data object types and/or attribute characteristics. Once an appropriate repository is identified, the data access request is fulfilled using the identified repository.

Claims

1. A method for accessing data in a computer system, the method comprising:

receiving a data access request at a data storage manager, the data access request including at least one of a request to write data or a request to read data, a user management layer comprising the data storage manager and a plurality of application programming interfaces, the user management layer interfacing a plurality of applications, at least one of the applications providing the data access request, the user management layer further interfacing a plurality of adapters each configured to determine whether at least one of a plurality of repositories has information needed to respond to the data access request and a location for at least one of the plurality of repositories, the plurality of adapters each interfacing at least one of the plurality of repositories, wherein the data storage manager, the plurality of application programming interfaces, and the plurality of adapters are implemented using at least one of a processor and a memory;

identifying from the plurality of repositories at least one repository that satisfies the data access request using, at least in part, rules stored in the data storage manager identifying at least one of the plurality of adapters for the data access of the at least one repository, wherein the plurality of repositories includes repositories of at least two different types that store information relating to data objects and data from each data object is selectively partitioned among the at least two different types of repositories, wherein the plurality of application programming interfaces comprise a user application programming interface, a group application programming interface, a role application programming interface, and a user account application programming interface, the data storage manager coupled to the at least one adapter; and

fulfilling the data access request using the at least one identified repository to perform at least one of writing data to a repository or reading data from a repository.

2. The method of claim 1 wherein data relating to different data objects is selectively partitioned among the repositories according to characteristics of the data objects.

3. The method of claim 2 wherein at least one attribute is associated with each data object.

4. The method of claim 3 wherein data relating to different attributes of each data object is further selectively partitioned among the repositories according to characteristics of the attributes.

5. The method of claim 4 wherein identifying at least one repository comprises determining which of the repositories store data requested in the data access request based on characteristics of the requested data identified in the data access request.

6. The method of claim 5 wherein identifying at least one repository comprises:

identifying a subset of the repositories based on the rules stored in the data storage manager; and

determining which of the subset of repositories store the requested data based on information stored in an adapter associated with each repository.

7. The method of claim 4 wherein data defining the existence of a first data object is stored in a first repository and data defining the existence of a second data object is stored in a second repository.

8. The method of claim 7 wherein data relating to a first attribute of the first data object is stored in the first repository and data relating to a second attribute of the first data object is stored in a third repository.

9. The method of claim 4 wherein the data objects and attributes stored in the repositories relate to user management data.

10. The method of claim 1 wherein the types of repositories are differentiated based on differences in at least one of:

protocols used to access data, the manner in which data is organized, or the technology upon which the repositories are based.

11. The method of claim 1 wherein the repositories are logically combined such that the existence of different types of repositories in the repositories is immaterial to an entity requesting the data access.

12. The method of claim 1 wherein the data access request relates to a data access selected from the group consisting of creating a data object, writing data, reading data, and searching data.

13. A data storage system for a computer system, the data storage system comprising:

a plurality of data repositories for storing data objects, wherein the plurality of repositories includes data repositories of at least two different types, wherein data for each data object is partitioned among the at least two different types of data repositories based on characteristics of the data in the computer system; and

a data storage manager operable to receive a data access request from one or more of a plurality of applications, to identify an appropriate data repository for fulfilling the data access request using, at least in part, rules stored in the data storage manager identifying at least one adapter for the data access of the at least one repository, and to access the requested data in accordance with the data access request, the data access request including at least one of a request to write data to a repository or to read data from a repository, a user management layer comprising the data storage manager and a plurality of application programming interfaces, the user management layer interfacing the plurality of applications, at least one of the applications providing the data access request, wherein the plurality of application programming interfaces comprise a user application programming interface, a group application programming interface, a role application programming interface, and a user account application programming interface, the data storage manager coupled to the at least one adapter, the user management layer further interfacing a plurality of adapters each configured to determine whether at least one of a plurality of repositories has information needed to respond to the data access request and a location for at least one of the plurality of repositories, the plurality of adapters each interfacing at least one of the plurality of repositories.

14. The system of claim 13 wherein the plurality of data repositories includes at least two different types of data repositories.

15. The system of claim 14 wherein the data repositories are distinguishable by type based on at least one of protocols used to access data, the manner in which data is organized, or the technology upon which the repositories are based.

16. The system of claim 13 wherein the plurality of repositories store information relating to a plurality of data objects.

17. The system of claim 16 wherein data is partitioned among the repositories according to at least one of data object types and attribute types.

18. The system of claim 13 further comprising at least one application program interface for interfacing the applications with the data storage manager.

19. The system of claim 13 further comprising an adapter associated with each repository for interfacing the data storage manager with the repositories.

20. The system of claim 19 wherein the data storage manager stores adapter information relating to which adapters are available and what types of data are handled by each of the adapters.

21. The system of claim 20 wherein the data storage manager uses the adapter information to identify the appropriate data repository for fulfilling the data access request.

22. The system of claim 21 wherein the data storage manager further contacts at least one adapter and uses information received from the at least one adapter to identify the appropriate data repository.

23. The system of claim 22 wherein each adapter stores information identifying data types handled by the adapter and maps data between the data storage manager and the data repository.

24. An article comprising a machine-readable medium storing instructions operable to cause one or more machines to perform operations comprising:

receiving a data access request at a data storage manager, the data access request including at least one of a request to write data to a repository or a request to read data from a repository, a user management layer comprising the data storage manager and a plurality of application programming interfaces, the user management layer interfacing a plurality of applications, at least one of the applications providing the data access request, wherein the plurality of application programming interfaces comprise a user application programming interface, a group application programming interface, a role application programming interface, and a user account application programming interface, the data storage manager coupled to the at least one adapter, the user management layer further interfacing a plurality of adapters each configured to determine whether at least one of a plurality of repositories has information needed to respond to the data access request and a location for at least one of the plurality of repositories, the plurality of adapters each interfacing at least one of the plurality of repositories;

identifying, using a data storage manager and at least one adapter, at least one repository from a plurality of repositories for satisfying the data access request using, at least in part, a set of data partitioning rules, wherein the plurality of repositories includes at least two different types of repositories and data from at least one single data object is selectively partitioned among the at least two different types of repositories; and

fulfilling the data access request using the at least one identified repository.

25. The article of claim 24 wherein the machine-readable medium further stores instructions operable to cause one or more machines to perform operations comprising:

partitioning data from each single data object among the repositories based on user object attributes with which the data is associated.

26. The article of claim 24 wherein the machine-readable medium further stores instructions operable to cause one or more machines to perform operations comprising:

searching an adapter associated with each repository to identify the at least one repository for satisfying the data access request; and

wherein the data access request is fulfilled through the adapter associated with the at least one identified repository.