System and Method for Reviewing Role Definitions

• US 20130031066A1
• Filed: 12/12/2011
• Published: 01/31/2013
• Est. Priority Date: 07/27/2011
• Status: Active Grant

• Current Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Original Assignee: Aveksa, Inc. (Dell Technologies Inc.)
• Inventors: Ducharme, James, Taneja, Deepak, Zehme, Dan Uwe, Miller, Michael Sean
• Granted Patent: US 9,047,323 B2
• Time in Patent Office: Days
• US Class Current: 707/694
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

A system for reviewing the ownership of data resources includes a database that stores a plurality of data resource identifiers. Each of the plurality of data resource identifiers has an associated owner field. The system also includes a second database that stores data resource review definitions. The review definitions define a review processes for the plurality of data resources. The system further includes a processor that is in communication with the data resource database and the review definition database. The processor executes the data resource ownership review processes defined by the review definitions at the appropriate times.

Claims

1. A method for reviewing data resource ownership, comprising the steps of:

storing a plurality of data resource identifiers in a first database, each of the plurality of data resource identifiers identifying one of a plurality of data resources and having an associated owner field;

storing a review definition in a second database, the review definition defining a review process for at least one of the plurality of data resources; and

executing by a processor the review process defined by the review definition.

2. The method of claim 1 further comprising the step of storing a plurality of review definitions in the second database, each of the plurality of review definitions defining a review process for one of the plurality of data resources.

3. The method of claim 1 wherein the review definition defines the review process to include a first subset of the plurality of data resources.

4. The method of claim 1 wherein the review definition defines the review process to include the plurality of data resources.

5. The method of claim 1 further comprising the step of the processor creating the review definition.

6. The method of claim 5, wherein the step of creating the review definition comprises the processer receiving a selection from predetermined review options.

7. The method of claim 5, wherein the step of creating the review definition comprises the processer receiving a selection of at least one of the plurality of data resources for the review.

8. The method of claim 7, wherein the selection may be selected from the group consisting of:

data resource name, data resource state, data resource type, data resource set, data resource attribute, and data resource set attribute and data resource owner.

9. The method of claim 5, wherein the step of creating the review definition further comprises the processor receiving a schedule for the review.

10. The method of claim 5, wherein the step of creating the review definition further comprises the processor receiving a selection of at least one reviewer to perform the review.

11. The method of claim 10, wherein the step of creating the review definition further comprises the processor receiving a plurality of reviewers among which to distribute the review.

12. The method of claim 10 wherein the at least one reviewer is the associated data resource owner.

13. The method of claim 1 wherein the associated owner field is to be assigned.

14. The method of claim 10 wherein step of creating the review definition further comprises the processor receiving a selection of suggested owners to perform the review.

15. The method of claim 14 wherein the processes selects a subset of the suggested owners to perform the review.

16. The method of claim 13, further comprising the step of the processor receiving an owner for the associated owner field from at least one of the reviewers.

17. The method of claim 13 further comprising the steps of:

the processor receiving an “

owner unknown”

response for the associated owner field from at least one of the reviewers; and

the processor removing the at least one of the reviewers from a list of potential owners.

18. The method of claim 17 further comprising the step of the processor receiving an additional reviewer from the at least one of the reviewers.

19. The method of claim 1, wherein the step of executing the review process further comprises creating a first instance of the review process.

20. The method of claim 1, further comprising the step of executing the review a plurality of times, wherein an instance of the review process is created by the processor for each execution.

21. The method of claim 1, wherein the step of executing the review process further comprises notifying selected reviewers of the review.

22. The method of claim 1, further comprising the step of receiving, by the processor, an instruction to from a user regarding ownership of the at least one of the plurality of data resources.

23. The method of claim 22, wherein the instruction is to modify ownership of the at least one of the plurality of data resources.

24. The method of claim 22, wherein user identifies that the at least one of the plurality of data resources is a valid data resource and the instruction is to maintain the at least one of the plurality of data resources.

25. The method of claim 22, wherein user identifies that the at least one of the plurality of data resources is an invalid data resource and the instruction is to revoke the at least one of the plurality of data resources.

26. A system for reviewing data resource ownership, comprising:

a first database storing a plurality of data resources, each of the plurality of data resources having an associated owner;

a second database storing a review definition, the review definition defining a review process for at least one of the plurality of data resources; and

a processor in communication with the first and second databases, the processor executing the review process defined by the review definition.

27. The system of claim 26 wherein the second database stores a plurality of review definitions, each of the plurality of review definitions defining a review process for a corresponding one of the plurality of data resources.

28. The system of claim 26 wherein the processor creates the review definition by receiving information from a user.

29. The system of claim 28, wherein the processer utilizes user selections from predetermined review options to create the review definition.

30. The system of claim 28, wherein the processor utilizes a user selection of at least one of the plurality of data resources for the review to create the review definition.

31. The system of claim 30, wherein the user selection may be selected from the group consisting of:

data resource name, data resource state, data resource type, data resource set, data resource attribute, and data resource set attribute and data resource owner.

32. The system of claim 28, wherein the processor utilizes a user selection of a schedule for the review to create the review definition.

33. The system of claim 28, wherein the processor utilizes a user selection of at least one reviewer to perform the review create the review definition.

34. The system of claim 33, wherein the processor utilizes a user selection of a plurality of reviewers among which to distribute the review to create the review definition.

35. The method of claim 33 wherein the at least one reviewer is the associated data resource owner.

36. The method of claim 33 wherein the associated owner field is to be assigned.

37. The method of claim 36 wherein step of creating the review definition further comprises the processor receiving a selection of suggested owners to perform the review.

38. The method of claim 37 wherein the processes selects a subset of the suggested owners to perform the review.

39. The method of claim 36, further comprising the step of the processor receiving an owner for the associated owner field from at least one of the reviewers.

40. The method of claim 36 further comprising the steps of:

the processor receiving an unknown response for the associated owner field from at least one of the reviewers; and

the processor removing the at least one of the reviewers from a list of potential owners.

41. The method of claim 40 further comprising the step of the processor receiving an additional reviewer from the at least one of the reviewers.

42. The method of claim 33 wherein the step of creating the review definition further comprises the processor receiving a selection of at least one user type to determine reviewers to perform the review.

43. The system of claim 26, wherein the processor creates a first instance of the review process while executing the review process.

44. The system of claim 26, wherein the processor creates an instance of the review process each time the processor executes the review process.

45. The system of claim 26, wherein the processor notifies selected reviewers of the review.

46. The system of claim 26, wherein the processor modifies ownership of the at least one of the plurality of data resources in response to receiving a user instruction to modify the at least one of the plurality of data resources.

47. The system of claim 26, wherein the processor maintains the at least one of the plurality of data resources in response to receiving a user instruction that the at least one of the plurality of data resources is a valid data resource.

48. The system of claim 26, wherein the processor revokes the at least one of the plurality of data resources in response to receiving a user instruction that the at least one of the plurality of data resources is an invalid data resource.