IP Library › Granted Patent US 7,987,234
Granted Patent B1
US 7,987,234 · App. 11/250,966 · Granted Jul 26, 2011

Monitoring alert conditions

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 7,987,234
App. No.
11/250,966
Granted
Jul 26, 2011
Kind
B1
Abstract

Graphical means for setting up, monitoring and issuing alerts for data conditions are described.

Claims (110)

1. A computer implemented method, comprising:

generating a graphical user interface (GUI) comprising a canvas;

receiving, via the GUI, input from a user to graphically add to the canvas a plurality of data elements to be monitored, wherein the plurality of data elements correspond to a plurality of values that are altered dynamically during execution of an alert application;

receiving, via the GUI, input from the user to graphically add at least one operator to the canvas and to associate the at least one operator with the plurality of data elements, wherein the at least one operator operates on the plurality of data elements to produce a set of results, and wherein the at least one operator comprises SQL code for performing one or more relational database querying operations;

receiving, via the GUI, input from the user to add to the canvas at least one alert condition to be applied to the set of results, wherein the user provides a monitoring schedule associated with each alert condition indicating how often each alert condition is checked;

receiving, via the GUI, input from the user comprising a pre-trigger condition and corrective steps, wherein the pre-trigger condition specifies a threshold value of at least one of the plurality of data elements; and

automatically generating, using the plurality of data elements, the at least one operator, the at least one alert condition, and the pre-trigger condition on the canvas, the alert application which, when executed, is configured to:

monitor the data elements to identify the pre-trigger condition,

when the pre-trigger condition is satisfied, deploy the corrective steps, wherein deployment of the corrective steps prevents the data elements from producing a potential result satisfying the at least one alert condition, and

when the pre-trigger condition is not satisfied:

operate on the data elements to produce the set of results, determine whether the set of results satisfies the at least one alert condition, and

trigger the alert to be sent to the user when the at least one alert condition is satisfied by the set of results.

2. The method of claim 1 , wherein the method further comprises:

prior to automatically generating the alert application, receiving from the user, via the GUI, input specifying what action or actions are to be performed when the alert is triggered; and

wherein the alert application is automatically generated further based upon the input specifying what action or actions are to be performed such that the alert application performs such action or actions when the alert is triggered.

3. The method of claim 1 , wherein the method further comprises:

prior to automatically generating the alert application, receiving from the user, via the GUI, input specifying what information set is to be included with the alert; and

wherein the alert application is automatically generated further based upon the input specifying what information set is to be included with an alert such that the alert application includes such information set with the alert.

4. The method of claim 1 , wherein the method further comprises:

prior to automatically generating the alert application, receiving from the user, via the GUI, input specifying one of an alert interval or an alert resend frequency; and

wherein the alert application is automatically generated further based upon the input specifying the alert interval or the alert resend frequency such that the alert application behaves in accordance with the alert interval or the alert resend frequency.

5. A machine readable storage device having stored thereon instructions, which when executed by a computer, cause the computer to perform the operations of:

generating a graphical user interface (GUI) that includes a canvas;

receiving, via the GUI, input from a user to graphically add to the canvas a plurality of data elements to be monitored, wherein the plurality of data elements correspond to a plurality of values that are altered dynamically during execution of an alert application;

receiving, via the GUI, input from the user to graphically add at least one operator to the canvas and to associate the at least one operator with the plurality of data elements to indicate that the at least one operator operate on the plurality of data elements to produce a set of results, and wherein the at least one operator comprises SQL code for performing one or more relational database querying operations;

receiving, via the GUI, input from the user to add to the canvas at least one alert condition to be applied to the set of results, wherein the user provides a monitoring schedule associated with each alert condition indicating how often each alert condition is checked;

receiving, via the GUI, input from the user comprising a pre-trigger condition and corrective steps, wherein the pre-trigger condition specifies a threshold value of at least one of the plurality of data elements; and

automatically generating, using the plurality of data elements, the at least one operator, the at least one alert condition, and the pre-trigger condition on the canvas, the alert application which, when executed, is configured to:

monitor the data elements to identify the pre-trigger condition.

when the pre-trigger condition is satisfied, deploy the corrective steps, wherein deployment of the corrective steps prevents the data elements from producing a potential result satisfying the at least one alert condition, and

when the pre-trigger condition is not satisfied:

operate on the data elements to produce the set of results,

determine whether the set of results satisfies the at least one alert condition, and

trigger the alert to be sent to the user when the at least one alert condition is satisfied by the set of results.

6. The machine readable storage device of claim 5 , wherein the instructions cause the computer to further perform the operation of:

prior to automatically generating the alert application, receiving from the user, via the GUI, input specifying what action or actions are to be performed when the alert is triggered; and

wherein the alert application is automatically generated further based upon the input specifying what action or actions are to be performed such that the alert application performs such action or actions when the alert is triggered.

7. The machine readable storage device of claim 5 , wherein the instructions cause the computer to further perform the operation of:

prior to automatically generating the alert application, receiving from the user, via the GUI, input specifying what information set is to be included with the alert; and

wherein the alert application is automatically generated further based upon the input specifying what information set is to be included with an alert such that the alert application includes such information set with the alert.

8. The machine readable storage device of claim 5 , wherein the instructions cause the computer to further perform the operation of:

prior to automatically generating the alert application, receiving from the user, via the GUI, input specifying one of an alert interval or an alert resend frequency; and

wherein the alert application is automatically generated further based upon the input specifying the alert interval or the alert resend frequency such that the alert application behaves in accordance with the alert interval or the alert resend frequency.

9. A system comprising a processor configured to perform the operations of:

generating a graphical user interface (GUI) comprising a canvas;

receiving, via the GUI, input from a user to graphically add to a canvas a plurality of data elements to be monitored, wherein the plurality of data elements correspond to a plurality of values that are altered dynamically during execution of an alert application;

receiving, via the GUI, input from the user to graphically add at least one operator to the canvas and to associate the at least one operator with the plurality of data elements, wherein the at least one operator operates on the plurality of data elements to produce a set of results, and wherein the at least one operator comprises SQL code for performing one or more relational database querying operations;

receiving, via the GUI, input from the user to add to the canvas at least one alert condition to be applied to the set of results, wherein the user provides a monitoring schedule associated with each alert condition indicating how often each alert condition is checked;

receiving, via the GUI, input from the user comprising a pre-trigger condition and corrective steps, wherein the pre-trigger condition specifies a threshold value of at least one of the plurality of data elements; and

automatically generating, using the plurality of data elements, the at least one operator, the at least one alert condition, and the pre-trigger condition on the canvas, the alert application which, when executed, is configured to:

monitor the data elements to identify the pre-trigger condition,

when the pre-trigger condition is satisfied, deploy the corrective steps, wherein deployment of the corrective steps prevents the data elements from producing a potential result satisfying the at least one alert condition, and

when the pre-trigger condition is not satisfied:

operate on the data elements to produce the set of results,

determine whether the set of results satisfies the at least one alert condition, and

trigger the alert to be sent to the user when the at least one alert condition is satisfied by the set of results.

10. A computer implemented method, comprising:

generating a graphical user interface (GUI) comprising a canvas;

receiving, via the GUI, input from a user to graphically add to a canvas a plurality of data elements to be monitored, wherein the plurality of data elements correspond to a plurality of values that are altered dynamically;

receiving, via the GUI, input from the user to graphically add at least one operator to the canvas and to associate the at least one operator with the plurality of data elements, wherein the at least one operator operates on the plurality of data elements to produce a set of results, and wherein the at least one operator comprises SQL code for performing one or more relational database querying operations;

receiving, via the GUI, input from the user to add to the canvas at least one alert condition to be applied to the set of results, wherein the user provides a monitoring schedule associated with each alert condition indicating how often each alert condition is checked;

receiving, via the GUI, input from the user comprising a pre-trigger condition and corrective steps, wherein the pre-trigger condition specifies a threshold value of at least one of the plurality of data elements;

monitoring the data elements to identify the pre-trigger condition;

when the pre-trigger condition is satisfied, deploying the corrective steps, wherein deployment of the corrective steps prevents the data elements from producing a potential result satisfying the at least one alert condition, and

when the pre-trigger condition is not satisfied:

monitoring and operating on the plurality of data elements to produce the set of results;

determining whether the set of results satisfies the at least one alert condition; and

triggering the alert, in response to a determination that the at least one alert condition is satisfied by the set of results.

11. The method of claim 10 , wherein the method further comprises:

receiving from the user, via the GUI, input specifying what action to perform when the alert is triggered; and

performing the specified action when the alert is triggered.

12. The method of claim 10 , wherein the method further comprises:

receiving from the user, via the GUI, input specifying what information set is to be included with the alert,

wherein triggering the alert comprises including such information set with the alert.

13. The method of claim 10 , wherein the method further comprises:

receiving from the user, via the GUI, input specifying one of an alert interval or an alert resend frequency; and

wherein triggering the alert comprises behaving in accordance with the one of the alert interval or the alert resend frequency.

14. A machine readable storage device having stored thereon instructions which, when executed by a computer, cause the computer to perform the operations of:

generating a graphical user interface (GUI) comprising a canvas;

receiving, via the GUI, input from a user to graphically add to a canvas a plurality of data elements to be monitored, wherein the plurality of data elements correspond to a plurality of values that are altered dynamically;

receiving, via the GUI, input from the user to graphically add at least one operator to the canvas and to associate the at least one operator with the plurality of data elements, wherein the at least one operator operates on the plurality of data elements to produce a set of results, and wherein the at least one operator comprises SQL code for performing one or more relational database querying operations;

receiving, via the GUI, input from the user to add to the canvas at least one alert condition to be applied to the set of results, wherein the user provides a monitoring schedule associated with each alert condition indicating how often each alert condition is checked;

receiving, via the GUI, input from the user comprising a pre-trigger condition and corrective steps, wherein the pre-trigger condition specifies a threshold value of at least one of the plurality of data elements;

monitoring the data elements to identify the pre-trigger condition;

when the pre-trigger condition is satisfied, deploying the corrective steps, wherein deployment of the corrective steps prevents the data elements from producing a potential result satisfying the at least one alert condition, and

when the pre-trigger condition is not satisfied:

monitoring and operating on the plurality of data elements to produce the set of results;

determining whether the set of results satisfies the at least one alert condition; and

triggering the alert, in response to a determination that the at least one alert condition is satisfied by the set of results.

15. The machine readable storage device of claim 14 , wherein the instructions cause the computer to further perform the operation of:

receiving from the user, via the GUI, input specifying what action or actions are to be performed when an alert is triggered;

wherein triggering one or more alerts comprises performing the specified action or actions.

16. The machine readable storage device of claim 14 , wherein the instructions cause the computer to further perform the operation of:

receiving from the user, via the GUI, input specifying what information set is to be included with the alert;

wherein triggering one or more alerts comprises including such information set with an alert.

17. The machine readable storage device of claim 14 , wherein the instructions cause the computer to further perform the operation of:

receiving from the user, via the GUI, input specifying one of an alert interval or an alert resend frequency;

wherein triggering the alert comprises behaving in accordance with the alert interval or the alert resend frequency.

18. A computer system comprising one or more processors configured to perform the operations of:

generating a graphical user interface (GUI) comprising a canvas;

receiving, via the GUI, input from a user to graphically add to a canvas a plurality of data elements to be monitored, wherein the plurality of data elements correspond to a plurality of values that are altered dynamically;

receiving, via the GUI, input from the user to graphically add at least one operator to the canvas and to associate the at least one operator with the plurality of data elements, wherein the at least one operator operates on the plurality of data elements to produce a set of results, and wherein the at least one operator comprises SQL code for performing one or more relational database querying operations;

receiving, via the GUI, input from the user to add to the canvas at least one alert condition to be applied to the set of results, wherein the user provides a monitoring schedule associated with each alert condition indicating how often each alert condition is checked;

receiving, via the GUI, input from the user comprising a pre-trigger condition and corrective steps, wherein the pre-trigger condition specifies a threshold value of at least one of the plurality of data elements;

monitoring the data elements to identify the pre-trigger condition;

when the pre-trigger condition is satisfied, deploying the corrective steps, wherein deployment of the corrective steps prevents the data elements from producing a potential result satisfying the at least one alert condition, and

when the pre-trigger condition is not satisfied:

monitoring and operating on the plurality of data elements to produce the set of results;

determining whether the set of results satisfies the at least one alert condition; and

triggering the alert, in response to a determination that the at least one alert condition is satisfied by the set of results.

Assignments (2)
MERGER AND CHANGE OF NAME Recorded Dec 16, 2015
From: ORACLE USA, INC.; SUN MICROSYSTEMS, INC.; ORACLE AMERICA, INC.
To: ORACLE AMERICA, INC.
Reel/Frame 037311/0101 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 20, 2006
From: WALDORF, JERRY A.
To: SUN MICROSYSTEMS, INC.
Reel/Frame 017512/0876 →