EFFICIENT ACCESS CONTROL ENFORCEMENT IN A CONTENT MANAGEMENT ENVIRONMENT

• US 20070055658A1
• Filed: 09/08/2005
• Published: 03/08/2007
• Est. Priority Date: 09/08/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: RAGHAVAN, SRIRAM, HSIAO, HUI-I
• Application Number:
  US11/162,395
• Publication Number:
  US 20070055658A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation

Abstract

Provided is a system and method for optimizing CM through application-level optimization by exploiting the specific semantics of access control. Access control is enforced by rewriting user or application queries to include additional predicates. Portions of a complex CM query that are identified as those that will return an empty set of result objects are replaced by an empty or null expression. Furthermore, statistics specific to access control are collected and intelligently used in formulating the rewritten query and in controlling the order of evaluation of access control predicates. Optionally, rewriting can generate a result filter in addition to a rewritten query. This filter is applied to the results produced by executing the rewritten query, thus allowing the access control enforcement burden to be shared between the query and the filter. When combined, the aforementioned techniques serve to reduce the runtime overhead of access control enforcement in CM systems.

Claims

1. A system providing access control enforcement for a CM system;

said system comprising;

a CM application requesting a first query be executed against a CM system

an access control enforcement component incorporating access control rules for any of;

user, user-group, or object type, into a rewritten query through a semantics-based rewrite of said first query;

a resultant dataset resulting from the execution of said first query against said underlying relational database; and

a query rewrite engine generating a filter for said resultant dataset, thus limiting access to items in said resultant dataset remaining after said filter is applied.

2. A system providing access control enforcement, as per claim 1, wherein said underlying relational database stores XML data.

3. A system providing access control enforcement, as per claim 1, wherein said access control enforcement component comprises:

a rule repository component storing said access control rules and a rule matching engine for identifying a subset of said access control rules that are applicable to any of;

said user or said application.

4. A system providing access control enforcement, as per claim 3, wherein said query rewrite comprises constructing and adding to said first query at least one additional predicate incorporating said identified subset of access control rules.

5. A system providing access control enforcement, as per claim 3, wherein said access control rules stored in said rule repository component are represented as compiled using any of:

decision tree, tree automaton, annotated decision tree, path indices, and accessibility maps data structures.

6. A system providing access control enforcement, as per claim 4, wherein said rewritten query is constructed by utilizing static analyses comprising:

access control-specific statistics based on said access control rules applicable to said CM environment and contents of said database; and

static optimization identifying and replacing with a null set those predicates in said rewritten query that retrieve a null set based on access control rules applicable to said CM environment.

7. A system providing access control enforcement, as per claim 4, wherein said rewritten query is evaluated in a particular order based on descending order of selectivity wherein said particular order of evaluation is forced by any of:

hints on which of said at least one additional predicates to issue first; and

splitting said rewritten query into multiple sub-queries such that the most selective sub-query is issued first.

8. A method of enforcing access control rules in a CM system;

said method comprising;

a CM application or CM application user requesting a first query be issued against said CM system;

rewriting said first query incorporating access control rules as additional predicates representing a set access control rules applicable a user, user-group, or object-type, wherein said additional predicates are based on static analyses;

evaluating in an optimal order and issuing against a database underlying said CM system, predicates in said rewritten query; and

filtering, in accordance with said access control rules, resultant dataset obtained by executing said rewritten query against said underlying database, thus limiting access to items in said resultant dataset remaining after said filtering step.

9. A method of enforcing access control rules in a CM system, as per claim 8, wherein said underlying relational database stores XML data.

10. A method of enforcing access control rules in a CM system, as per claim 8, wherein said query rewriting step comprises identifying a subset of said access control rules applicable to any of said:

CM user or CM application.

11. A method of enforcing access control rules in a CM system, as per claim 10, where said query rewriting step further comprises constructing and adding to said first query, at least one additional predicate incorporating said identified subset of access control rules.

12. A method of enforcing access control rules in a CM system, as per claim 8, wherein a stored, compiled representation of said access control rules is any of:

decision tree, tree automaton, annotated decision tree, path index, and accessibility maps data structure.

13. A method of enforcing access control rules in a CM system, as per claim 8, wherein said rewritten query is constructed by utilizing static analyses comprising:

access control-specific statistics based on said access control rules applicable to any of said;

CM user or CM application and contents of said database; and

static optimization identifying and replacing with a null set, those predicates in said rewritten query that retrieve a null set based on access control rules applicable to any of said;

CM user or CM application.

14. A method of enforcing access control rules in a CM system, as per claim 8, wherein said optimal order is based on descending order of selectivity wherein said optimal order of evaluation is forced by any of:

hints on which of said at least one additional predicates to issue first; and

splitting said rewritten query into multiple sub-queries such that the most selective sub-query is issued first.

15. A computer-based method of enforcing access control rules in a CM system;

said method comprising;

A CM application or CM application user requesting a first query be issued against said CM system;

rewriting said first query incorporating access control rules as additional predicates representing a set access control rules applicable a user, user-group, or object-type wherein said additional predicates are based on static analyses;

evaluating in an optimal order and issuing against a database underlying said CM system, predicates in said rewritten query; and

filtering, in accordance with said access control rules, resultant dataset obtained by executing said rewritten query against said underlying database.

16. A computer-based method of enforcing access control rules in a CM system, as per claim 15, wherein said underlying relational database stores XML data.

17. A computer-based method of enforcing access control rules in a CM system, as per claim 15, wherein said query rewriting step comprises identifying a subset of said access control rules applicable to any of said:

CM user or CM application.

18. A computer-based method of enforcing access control rules in a CM system, as per claim 17, where said query rewriting step further comprises constructing and adding to said first query, at least one additional predicate incorporating said identified subset of access control rules.

19. A computer-based method of enforcing access control rules in a CM system, as per claim 15, wherein a stored, compiled representation of said access control rules is any of:

decision tree, tree automaton, annotated decision tree, path index, and accessibility maps data structure.

20. A computer-based method of enforcing access control rules in a CM system, as per claim 15, wherein said rewritten query is constructed by utilizing static analyses comprising:

access control-specific statistics based on said access control rules applicable to any of said;

CM user or CM application and contents of said database; and

static optimization identifying and replacing with a null set, those predicates in said rewritten query that retrieve a null set based on access control rules applicable to any of said;

CM user or CM application.

21. A computer-based method of enforcing access control rules in a CM system, as per claim 15, wherein said optimal order is based on descending order of selectivity wherein said optimal order of evaluation is forced by any of:

hints on which of said at least one additional predicates to issue first; and

splitting said rewritten query into multiple sub-queries such that the most selective sub-query is issued first.

22. An article of manufacture comprising a computer usable medium having computer readable program code embodied therein which implements method of enforcing access control rules in a CM system;

said medium comprising modules implementing;

a CM application or CM application user requesting a first query be issued against said CM system;

rewriting said first query incorporating access control rules as additional predicates representing a set access control rules applicable a user, user-group, or object-type, wherein said additional predicates are based on static analyses;

evaluating in an optimal order and issuing against a database underlying said CM system, predicates in said rewritten query; and

filtering, in accordance with said access control rules, resultant dataset obtained by executing said rewritten query against said underlying database, thus limiting access to items in said resultant dataset remaining after said filtering step.

23. An article of manufacture comprising, as per claim 22, wherein said underlying relational database stores XML data.

24. An article of manufacture comprising, as per claim 22, wherein said query rewriting step comprises identifying a subset of said access control rules applicable to any of said:

CM user or CM application.

25. An article of manufacture comprising, as per claim 24, where said query rewriting step further comprises constructing and adding to said first query, at least one additional predicate incorporating said identified subset of access control rules.

26. An article of manufacture comprising, as per claim 22, wherein a stored, compiled representation of said access control rules is any of:

decision tree, tree automaton, annotated decision tree, path index, and accessibility maps data structure.

27. An article of manufacture comprising, as per claim 22, wherein said rewritten query is constructed by utilizing static analyses comprising:

access control-specific statistics based on said access control rules applicable to any of said;

CM user or CM application and contents of said database; and

static optimization identifying and replacing with a null set, those predicates in said rewritten query that retrieve a null set based on access control rules applicable to any of said;

CM user or CM application.

28. An article of manufacture comprising, as per claim 22, wherein said optimal order is based on descending order of selectivity wherein said optimal order of evaluation is forced by any of:

hints on which of said at least one additional predicates to issue first; and

splitting said rewritten query into multiple sub-queries such that the most selective sub-query is issued first.