Dynamic end user specific customization of an application's physical data layer through a data repository abstraction layer

• US 6,928,431 B2
• Filed: 04/25/2002
• Issued: 08/09/2005
• Est. Priority Date: 04/25/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Stevens, Richard Joseph, Dettinger, Richard Dean
• Primary Examiner(s): LE, UYEN T
• Application Number:
  US10/132,228
• Publication Number:
  US 20030208486A1
• Time in Patent Office: 1,202 Days
• Field of Search: 707 1- 4, 707/9, 707/10, 707/103.R, 707/103.Y
• US Class Current: 1/1
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

A system, method and article of manufacture are provided for accessing data independent of the particular manner in which the data is physically represented. In one embodiment, a plurality of data repository abstractions provide different logical views of the same underlying data repository. The plurality of data repository abstractions may each be associated with different users, thereby exposing a different set of data to each user. A runtime component performs translation of abstract queries into a form that can be used against a particular physical data representation.

Claims

1. A computer-implemented method for providing access to data having a particular physical data representation, comprising:

performing an operation by a computer, the operation comprising;

providing a data repository abstraction based on a plurality of logical fields for defining abstract queries;

providing a first set of mapping rules which map at least a first portion of the plurality of logical fields to a first plurality of physical entities of the data;

providing a second set of mapping rules which map at least a second portion of the plurality logical fields to a second plurality of physical entities of the data;

accessing only the first set of mapping rules for all abstract queries issued by a first user, and

accessing only the second set of mapping rules for all abstract queries issued by a second user.

2. The computer-implemented method of claim 1, wherein the abstract query comprises at least one selection criterion and a result specification.

3. The computer-implemented method of claim 1, further comprising transforming each abstract query into a query consistent with the particular physical data representation according to the respective mapping rules.

4. The computer-implemented method of claim 1, where the query consistent with the particular physical data representation s one of a SQL query and an XML query.

5. The computer-implemented method of claim 1, wherein the mapping rules each comprise different access methods for the plurality of logical fields.

6. The computer-implemented method of claim 5, wherein the access methods each describe a location of the physical entities of the data.

7. A computer-implemented method for providing access to data having a particular physical data representation, comprising:

performing an operation by a computer, the operation comprising;

providing a data repository abstraction defining a plurality of logical fields for defining abstract queries; and

providing a plurality of user profiles each defining an association with different sets of mapping rules each of which map at least a portion of the plurality of logical fields to physical entities of the data.

8. The computer-implemented method of claim 7, further comprising transforming each abstract query into a query consistent with the particular physical data representation according to the respective mapping rules.

9. The computer-implemented method of claim 7, wherein the mapping rules each comprise different access methods far the plurality of logical fields and wherein the access methods each describe a location of the physical entities of the data.

10. A computer-implemented method of accessing data having a particular physical data representation, comprising:

performing an operation by a computer, the operation comprising;

issuing, by a first user, a first abstract query to an application, wherein the first abstract query is defined according to a first plurality of logical fields;

in response to the first abstract query, accessing a first set of mapping rules having a defined association with the first user;

issuing, by a second user, a second abstract query to the application, wherein the second abstract query is defined according to a second plurality of logical response to the second abstract query, accessing a second set of mapping rules having a defined association with the second user; and

transforming each of the first and second abstract queries into queries consistent with the particular physical data representation according to respective mapping rules which map the logical fields to physical entitles of the data.

11. The computer-implemented method of claim 10, further comprising, for an initial connection with the application by the first and second users:

(i) selecting the respective set of mapping rules to use for the user;

(ii) setting a level indicator indicative of a manner in which the respective set of mapping rules were selected for the particular user accessing the mapping rules; and

(iii) loading the selected mapping rule set.

12. The computer-implemented method of claim 11, wherein selecting the set of mapping rules to use for the user comprises determining whether a predefined association between the user and a particular mapping rule set exists;

if so, selecting the particular mapping rule set as the set of mapping rules to be accessed for queries issued by the user; and

if not, selecting a default mapping rule set as the set of mapping rules to be accessed for queries issued by the user.

13. The computer-implemented method of claim 11, further comprising, for each access of the respective set of mapping rules by the first and second users:

determining the level indicator of the set of mapping rules being accessed;

for at least a first level indicator, determining whether the set of mapping rules being accessed has changed relative to when the mapping rules set being accessed was loaded for the user, and if so, performing steps (i)-(iii); and

for at least a second level indicator, determining whether another level exists for the user, and if so, performing steps (i)-(iii).

14. The computer-implemented method of claim 13, wherein the first level indicator is a user level indicator indicating that the set of mapping rules being accessed by the respective user has a defined association with the user and wherein the second level indicator is at least one of:

(i) a group level indicator indicating that the set of mapping rules being accessed by the respective user has a defined association with a group of which the user is member; and

(ii) an application level indicator indicating that the set of mapping rules being accessed by the respective user is a default set of mapping rules.

15. The computer-implemented method of claim 10, wherein the mapping rules each comprise at least one access method for each logical field of the abstract query.

16. The computer-implemented method of claim 15, wherein the access methods each describe a physical location of a physical entity of the data.

17. A computer program product for use in a computer system, comprising:

a computer-readable medium containing computer-readable program code for a database access environment which provides access to data having a particular physical data representation, the database access environment comprising;

a data repository abstraction defining;

a plurality of logical fields for defining abstract queries; and

a plurality of mapping rules sets which map the plurality of logical fields to physical entitles of the data, and wherein at least two of the plurality of mapping rules sets map the plurality of logical fields to different sets of the physical entitles of the data and are uniquely associated with at least one of two different requesting entities selected from one of two different users, two different groups of users, and a group of users and a user.

18. The computer program product of claim 17, further comprising computer-readable program code for a runtime component which transforms an abstract query issued by one of the two different requesting entities, and defined according to the data repository abstraction, into a query consistent with the particular physical data representation according to the respective mapping rules of the two different requesting entitles.

19. The computer program product of claim 17, wherein the mapping rules comprise at least one access method for each of the plurality of logical fields.

20. The computer program product of claim 19, wherein the access method describes a location of the physical entities of the data.

21. A computer-readable medium containing a program which, when executed by a processor, performs an operation of accessing data having a particular physical data representation, the operation comprising:

receiving a plurality of abstract queries from different users, wherein each respective abstract query from a respective user is composed on the basis of a respective data repository abstraction component for the respective user, each data repository abstraction component comprising a plurality of logical fields that map to physical entities of the data; and

transforming the respective abstract query into a query consistent with the particular physical data representation according to the respective data repository abstraction component for the respective user;

wherein different data repository abstraction components are associated with at least two of the users.

22. The computer-readable medium of claim 21, wherein the mapping rules comprise an access method for each logical field of the abstract query.

23. The computer-readable medium of claim 22, wherein the access method describes a physical location of the physical entities of the data.

24. A computer, comprising:

a memory containing at least (i) an application defining a query specification providing an interface to data repository abstraction components which provide a definition for an abstract query according to logical fields, (ii) a plurality of data repository abstraction components which map the logical fields to physical entities of data, wherein at least a portion of the data repository abstraction components have a programmatically defined association with different users, and (iii) a runtime component for transforming the abstract query into a query consistent with the physical entities of data according to the data repository abstraction components, wherein a first data repository abstraction component is utilized for transforming a first plurality of abstract queries from a first user and a second data repository abstraction component is utilized for transforming a second plurality of abstract queries from a second user; and

a processor adapted to execute contents of the memory.

25. The computer of claim 24, wherein the data repository abstraction components comprise an access method for each of the plurality of logical fields.

26. The computer of claim 24, further comprising a storage device containing the data.

27. The computer of claim 26, wherein the access method describes a location of the physical entitles of the data.