IP Library Granted Patent US 9,940,340
Granted Patent B2
US 9,940,340 · App. 14/927,558 · Granted Apr 10, 2018

Ensuring data maintenance within a LDAP environment

Inventors: Annemarie R. Fitterer (Austin, TX); Richard J. Smith (Round Rock, TX); Rama Mohan Thulasi Reddy (Round Rock, TX)
Assignee: International Business Machines Corporation
G06F17/30292G06F17/3056G06F17/30368G06F17/30377G06F17/30575
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,940,340
App. No.
14/927,558
Granted
Apr 10, 2018
Kind
B2
Abstract

An approach for tracking system changes to support data maintenance within a directory service environment. Log fields are added to a directory service database for applications that interface with a directory service environment based on predetermined fields to be tracked. The log fields are updated to register database schema fields and data associated with the applications to create a history of changes. An application's identity and data access to the directory service environment are monitored and the log fields are updated to create a history of usage. The directory service database history of usage and changes are periodically analyzed to determine applications relationship dependencies and usage information. Associated maintenance actions are identified by detecting conditions in the directory service environment, based on predetermined maintenance criteria and maintenance is performed.

Claims (42)

1. A method for tracking system changes to support data maintenance within a directory service environment, the method comprising:

adding one or more log fields to a directory service database for one or more applications which interface with a directory service environment based on one or more predetermined fields to be tracked;

updating the one or more log fields to register one or more database schema fields and one or more associated data, associated with the one or more applications to create a history of changes;

monitoring one or more applications identity and one or more data access to the directory service environment;

logging a one or more log value string for each of the one or more applications identity and the one or more data access in the one or more log fields to create a history of usage;

analyzing, periodically, the directory service database, the one or more log value string in the history of usage and the history of changes to determine one or more relationship dependencies associated with the one or more applications, one or more usage information associated with the one or more applications, and one or more maintenance actions associated with the one or more applications; and

detecting a condition in the directory service environment, meeting a predetermined one or more maintenance criteria and performing at least one of the one or more maintenance actions based on the detected condition.

2. The method of claim 1 , wherein the maintenance action is at least one of deleting unused information, rollback, backup, archive, restore, and deploy changes.

3. The method of claim 1 , wherein the one or more log value string comprises delimited values of at least one of application identifier, company name, read count, write count, and last access timestamp.

4. The method of claim 3 , wherein create a history of usage comprises updating the one or more log fields with at least one of the one or more data access wherein the one or more data access comprises at least one of the one or more log value string.

5. The method of claim 3 , wherein create a history of changes comprises updating the one or more log fields with at least one of the one or more associated data wherein the one or more associated data comprises at least one of the one or more log value string.

6. The method of claim 1 , wherein the one or more maintenance actions further comprises outputting a report to directory service administrator by at least one of ad hoc, schedule and triggering event based on predetermined threshold value.

7. The method of claim 2 , wherein the one or more maintenance actions comprises at least one of, adding, deleting and changing at least one of the one or more database schema fields, the one or more associated data, and the one or more data access.

8. A computer program product for tracking system changes to support data maintenance within a directory service environment, the computer program product comprising:

one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions comprising:

program instructions to, add one or more log fields to a directory service database for one or more applications which interface with a directory service environment based on one or more predetermined fields to be tracked;

program instructions to, update the one or more log fields to register one or more database schema fields and one or more associated data, associated with the one or more applications to create a history of changes;

program instructions to, monitor at least one of one or more applications identity and one or more data access to the directory service environment;

program instructions to, log a one or more log value string for each of the one or more applications identity and the one or more data access in the one or more log fields to create a history of usage;

program instructions to, analyze, periodically, the directory service database, the one or more log value string in the history of usage and the history of changes to determine one or more relationship dependencies associated with the one or more applications, one or more usage information associated with the one or more applications, and one or more maintenance actions associated with the one or more applications; and

program instructions to, detect a condition in the directory service environment, meeting a predetermined one or more maintenance criteria and performing at least one of the one or more maintenance actions based on the detected condition.

9. The computer program product of claim 8 , wherein the maintenance action is at least one of deleting unused information, rollback, backup, archive, restore, and deploy changes.

10. The computer program product of claim 8 , wherein the one or more log value string comprises delimited values of at least one of application identifier, company name, read count, write count, and last access timestamp.

11. The computer program product of claim 10 , wherein create a history of usage comprises updating the one or more log fields with at least one of the one or more data access wherein the one or more data access comprises at least one of the one or more log value string.

12. The computer program product of claim 10 , wherein create a history of changes comprises updating the one or more log fields with at least one of the one or more associated data wherein the one or more associated data comprises at least one of the one or more log value string.

13. The computer program product of claim 8 , wherein the one or more maintenance actions further comprises outputting a report to directory service administrator by at least one of ad hoc, schedule and triggering event based on predetermined threshold value.

14. The computer program product of claim 9 , wherein the one or more maintenance actions comprises at least one of, adding, deleting and changing at least one of the one or more database schema fields, the one or more associated data, and the one or more data access.

15. A computer system for tracking system changes to support data maintenance within a directory service environment, the computer system comprising:

one or more computer processors;

one or more computer readable storage media;

program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:

program instructions to, add one or more log fields to a directory service database for one or more applications which interface with a directory service environment based on one or more predetermined fields to be tracked;

program instructions to, update the one or more log fields to register one or more database schema fields and one or more associated data, associated with the one or more applications to create a history of changes;

program instructions to, monitor at least one of one or more applications identity and one or more data access to the directory service environment;

program instructions to, log a one or more log value string for each of the one or more applications identity and the one or more data access in the one or more log fields to create a history of usage;

program instructions to, analyze, periodically, the directory service database, the one or more log value string in the history of usage and the history of changes to determine one or more relationship dependencies associated with the one or more applications, one or more usage information associated with the one or more applications, and one or more maintenance actions associated with the one or more applications; and

program instructions to, detect a condition in the directory service environment, meeting a predetermined one or more maintenance criteria and performing at least one of the one or more maintenance actions based on the detected condition.

16. The computer system of claim 15 , wherein the maintenance action is at least one of deleting unused information, rollback, backup, archive, restore, and deploy changes.

17. The computer system of claim 15 , wherein the one or more log value string comprises delimited values of at least one of application identifier, company name, read count, write count, and last access timestamp.

18. The computer system of claim 17 , wherein create a history of usage comprises updating the one or more log fields with at least one of the one or more data access wherein the one or more data access comprises at least one of the one or more log value string.

19. The computer system of claim 17 , wherein create a history of changes comprises updating the one or more log fields with at least one of the one or more associated data wherein the one or more associated data comprises at least one of the one or more log value string.

20. The computer system of claim 15 , wherein the one or more maintenance actions further comprises outputting a report to directory service administrator by at least one of ad hoc, schedule and triggering event based on predetermined threshold value.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 30, 2015
From: FITTERER, ANNEMARIE R.; SMITH, RICHARD J.; THULASI REDDY, RAMA MOHAN
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 036919/0927 →
Continuity (1)
Related Publication 20170124121A1 · May 4, 2017