Automatic monitoring and statistical analysis of dynamic process metrics to expose meaningful changes

• US 7,072,899 B2
• Filed: 12/17/2004
• Issued: 07/04/2006
• Est. Priority Date: 12/19/2003
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: ProClarity Corp. (Microsoft Corporation)
• Inventors: Lokken, Robert C.
• Primary Examiner(s): Alam, Shahid
• Application Number:
  US11/015,719
• Publication Number:
  US 20050138020A1
• Time in Patent Office: 564 Days
• Field of Search: 707/3, 707/10, 707/100, 707/102, 707/104.1, 707/5, 707/6, 700/18, 700/19, 704/232, 704/243, 704/244, 704/245, 718/100
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3452 Performance evaluation by statistical analysis
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A selection module allows a user to specify at least one measure to be monitored in at least one dimension of a dimensional hierarchy. A control limit calculator extracts, for each specified measure and for each specified dimension, a time series from a multidimensional database for the specified measure in the specified dimension and automatically calculates one or more control limits for the specified measure in the specified dimension based on the extracted time series using a Statistical Process Control (SPC) technique. Thereafter, a monitoring module monitors newly acquired data including each specified measure in each specified dimension for an out-of-limits condition based on one or more automatically-calculated control limits. An alert module triggers an alert in response to an out-of-limits condition being detected.

Claims

1. A computer-implemented method comprising:

allowing a user to specify at least one measure to be monitored in at least one dimension of a dimensional hierarchy;

for each specified measure and for each specified dimension;

extracting a time series from a multidimensional database for the specified measure in the specified dimension;

automatically calculating one or more control limits for the specified measure in the specified dimension based on the extracted time series using a Statistical Process Control (SPC) technique;

monitoring newly acquired data including each specified measure in each specified dimension for an out-of-limits condition based on one or more stored control limits;

triggering an alert in response to an out-of-limits condition being detected; and

storing each automatically-calculated control limit.

2. The method of claim 1, further comprising:

allowing the user to specify a detection cycle, wherein monitoring further comprises periodically obtaining current data for each specified measure in each specified dimension according to the specified detection cycle.

3. The method of claim 1, further comprising:

allowing the user to specify an alert delivery method, wherein triggering further comprises delivering an alert to the user via the specified alert delivery method.

4. The method of claim 3, wherein delivering an alert comprises delivering the alert via an e-mail service.

5. The method of claim 3, wherein delivering an alert comprises delivering the alert via a Short Message Service (SMS).

6. The method of claim 3, wherein delivering an alert comprises delivering the alert via a paging service.

7. The method of claim 1, further comprising:

automatically recalculating at least one control limit after eliminating one or more outliers from existing data.

8. The method of claim 1, further comprising:

automatically recalculating at least one control limit based on newly acquired data.

9. The method of claim 1, wherein automatically calculating one or more control limits comprises automatically calculating a control limit that is a function of an average and a standard deviation of the time series.

10. The method of claim 1, wherein automatically calculating one or more control limits comprises automatically calculating an upper control limit (UCL) according to the formula:

$\mathrm{UCL}=\stackrel{\_}{X}+Z<br><br><br><br>\mathrm{\sigma <br><br>}$ $\mathrm{where}$ $\stackrel{\_}{X}=\frac{\underset{i=1}{\overset{n}{\sum <br><br>}}<br><br>X_i}{n}$ $\mathrm{\sigma <br><br>}=\sqrt{\frac{\sum <br><br>{\left(X_i-\stackrel{\_}{X}\right)}^2}{n-1}}$

X_i is a measure in the time series,

n is the number of measures in the time series, and

Z is tolerance factor.

11. The method of claim 1, wherein automatically calculating one or more control limits comprises automatically calculating a lower control limit (LCL) according to the formula:

$\mathrm{LCL}=\stackrel{\_}{X}-Z<br><br><br><br>\mathrm{\sigma <br><br>}$ $\mathrm{where}$ $\stackrel{\_}{X}=\frac{\underset{i=1}{\overset{n}{\sum <br><br>}}<br><br>X_i}{n}$ $\mathrm{\sigma <br><br>}=\sqrt{\frac{\sum <br><br>{\left(X_i-\stackrel{\_}{X}\right)}^2}{n-1}}$

X_i is a measure in the time series,

n is the number of measures in the time series, and

Z is a tolerance factor.

12. A computer program product comprising a computer-readable storage medium, the computer-readable storage medium including:

program code for allowing a user to specify at least one measure to be monitored in at least one dimension of a dimensional hierarchy;

program code for extracting, for each specified measure and for each specified dimension, a time series from a multidimensional database for the specified measure in the specified dimension and automatically calculating, one or more control limits for the specified measure in the specified dimension based on the extracted time series using a Statistical Process Control (SPC) technique;

program code for monitoring newly acquired data including each specified measure in each specified dimension for an out-of-limits condition based on one or more automatically-calculated control limits;

program code for triggering an alert in response to an out-of-limits condition being detected; and

storing each automatically-calculated control limit.

13. The computer program product of claim 12, wherein the computer-readable medium further comprises:

program code for allowing the user to specify a detection cycle, wherein monitoring further comprises periodically obtaining current data for each specified measure in each specified dimension according to the specified detection cycle.

14. The computer program product of claim 12, wherein the computer-readable medium further comprises:

program code for allowing the user to specify an alert delivery method, wherein the program code for triggering an alert further comprises program code for delivering an alert to the user via the specified alert delivery method.

15. The computer program product of claim 14, wherein the program code for delivering an alert comprises program code for delivering the alert via an e-mail service.

16. The computer program product of claim 14, wherein the program code for delivering an alert comprises program code for delivering the alert via a Short Message Service (SMS).

17. The computer program product of claim 14, wherein the program code for delivering an alert comprises program code for delivering the alert via a paging service.

18. The computer program product of claim 12, wherein the computer-readable medium further comprises:

program code for automatically recalculating at least one control limit after eliminating one or more outliers from existing data.

19. The computer program product of claim 12, wherein the computer-readable medium further comprises:

program code for automatically recalculating at least one control limit based on newly acquired data.

20. The computer program product of claim 12, wherein the program code for automatically calculating one or more control limits comprises program code for automatically calculating a control limit that is a function of an average and a standard deviation of the time series.

21. The computer program product of claim 12, wherein the program code for automatically calculating one or more control limits comprises program code for automatically calculating an upper control limit (UCL) according to the formula:

$\mathrm{LCL}=\stackrel{\_}{X}-Z<br><br><br><br>\mathrm{\sigma <br><br>}$ $\mathrm{where}$ $\stackrel{\_}{X}=\frac{\underset{i=1}{\overset{n}{\sum <br><br>}}<br><br>X_i}{n}$ $\mathrm{\sigma <br><br>}=\sqrt{\frac{\sum <br><br>{\left(X_i-\stackrel{\_}{X}\right)}^2}{n-1}}$

X_i is a measure in the time series,

n is the number of measures in the time series, and

Z is tolerance factor.

22. The computer program product of claim 12, wherein the program code for automatically calculating one or more control limits comprises program code for automatically calculating a lower control limit (LCL) according to the formula:

$\mathrm{LCL}=\stackrel{\_}{X}-Z<br><br><br><br>\mathrm{\sigma <br><br>}$ $\mathrm{where}$ $\stackrel{\_}{X}=\frac{\underset{i=1}{\overset{n}{\sum <br><br>}}<br><br>X_i}{n}$ $\mathrm{\sigma <br><br>}=\sqrt{\frac{\sum <br><br>{\left(X_i-\stackrel{\_}{X}\right)}^2}{n-1}}$

X_i is a measure in the time series,

n is the number of measures in the time series, and

Z is a tolerance factor.

23. A system comprising:

a selection module to allow a user to specify at least one measure to be monitored in at least one dimension of a dimensional hierarchy;

a control limit calculator to extract, for each specified measure and for each specified dimension, a time series from a multidimensional database for the specified measure in the specified dimension and automatically calculate one or more control limits for the specified measure in the specified dimension based on the extracted time series using a Statistical Process Control (SPC) technique;

a monitoring module to monitor, for newly acquired data, each specified measure in each specified dimension for an out-of-limits condition based on one or more automatically-calculated control limits;

an alert module to trigger an alert in response to an out-of-limits condition being detected; and

storing each automatically-calculated control limit.

24. The system of claim 23, wherein the selection module is to allow the user to specify a detection cycle, and wherein the monitoring module is to periodically obtain current data for each specified measure in each specified dimension according to the specified detection cycle.

25. The system of claim 23, wherein the selection module is to allow the user to specify an alert delivery service, and wherein the alert module is to deliver an alert to the user via the specified delivery service.

26. The system of claim 25, wherein the specified delivery service comprises e-mail service.

27. The system of claim 25, wherein the specified delivery service comprises a Short Message Service (SMS).

28. The system of claim 25, wherein the specified delivery service comprises a paging service.

29. The system of claim 23, wherein the control limit calculator is to automatically recalculate at least one control limit after eliminating one or more outliers from existing data.

30. The system of claim 23, wherein the control limit calculator is to automatically recalculate at least one control limit based on newly acquired data.

31. The system of claim 23, wherein the control limit calculator is to automatically calculate a control limit that is a function of an average and a standard deviation of the time series.

32. The system of claim 23, wherein the control limit calculator is to automatically calculate an upper control limit (UCL) according to the formula:

$\mathrm{UCL}=\stackrel{\_}{X}+Z<br><br><br><br>\mathrm{\sigma <br><br>}$ $\mathrm{where}$ $\stackrel{\_}{X}=\frac{\underset{i=1}{\overset{n}{\sum <br><br>}}<br><br>X_i}{n}$ $\mathrm{\sigma <br><br>}=\sqrt{\frac{\sum <br><br>{\left(X_i-\stackrel{\_}{X}\right)}^2}{n-1}}$

X_i is a measure in the time series,

n is the number of measures in the time series, and

Z is tolerance factor.

33. The system of claim 23, wherein the control limit calculator is to automatically calculate a lower control limit (LCL) according to the formula:

$\mathrm{LCL}=\stackrel{\_}{X}-Z<br><br><br><br>\mathrm{\sigma <br><br>}$ $\mathrm{where}$ $\stackrel{\_}{X}=\frac{\underset{i=1}{\overset{n}{\sum <br><br>}}<br><br>X_i}{n}$ $\mathrm{\sigma <br><br>}=\sqrt{\frac{\sum <br><br>{\left(X_i-\stackrel{\_}{X}\right)}^2}{n-1}}$

X_i is a measure in the time series,

n is the number of measures in the time series, and

Z is a tolerance factor.