Optimal use of triggers for detecting database events
First Claim
Patent Images
1. A method of monitoring events in a database, said method comprising:
- storing in said database at least one database rule;
mapping temporal constraints of an event of said database rule to corresponding temporal events;
changing said temporal constraints associated with said temporal events based upon related temporal constraints for related events of said database rule to provide changed temporal constraints;
registering alarms associated with a start and end of a lifespan of each of said temporal events;
selectively deploying and selectively permanently removing ones of said temporal events from said database based upon said changed temporal constraints;
upon reaching said end of said lifespan of each of said temporal events, permanently removing from said database said alarm associated with said ones of said temporal events permanently removed from said database;
combining said temporal events using a sequence operator to form a composite event; and
associating a lifespan to said composite event using said sequence operator.
4 Assignments
0 Petitions
Accused Products
Abstract
Triggers are dynamically created and destroyed on an application database. Rules are represented in active databases as ECA (event-condition-action) items, in which an action formulates a reaction to an event and is executed after the rule is triggered when the condition is evaluated to true. The event is defined as an instantaneous and atomic (that is, the event either happens completely, or not at all) point of occurrence within an application. Events can be classified as either database, temporal, or user-defined events, and their type can be either primitive or composite.
-
Citations
17 Claims
-
1. A method of monitoring events in a database, said method comprising:
-
storing in said database at least one database rule; mapping temporal constraints of an event of said database rule to corresponding temporal events; changing said temporal constraints associated with said temporal events based upon related temporal constraints for related events of said database rule to provide changed temporal constraints; registering alarms associated with a start and end of a lifespan of each of said temporal events; selectively deploying and selectively permanently removing ones of said temporal events from said database based upon said changed temporal constraints; upon reaching said end of said lifespan of each of said temporal events, permanently removing from said database said alarm associated with said ones of said temporal events permanently removed from said database; combining said temporal events using a sequence operator to form a composite event; and associating a lifespan to said composite event using said sequence operator. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 14, 15)
-
-
11. A database recorded on a non-transitory computer storage medium comprising:
-
software code means for storing in said database at least one database rule; software code means for mapping temporal constraints of an event of said database rule to corresponding temporal events; software code means for changing said temporal constraints associated with said temporal events based upon related temporal constraints for related events of said database rule to provide changed temporal constraints; software code means for registering alarms associated with a start and end of a lifespan of each of said temporal events; software code means for selectively deploying and selectively permanently removing ones of said temporal events from said database based upon said changed temporal constraints; software code means for, upon reaching said end of said lifespan of each of said temporal events, permanently removing from said database said alarm associated with said ones of said temporal events permanently removed from said database; software code means for combining said temporal events using a sequence operator to form a composite event; and software code means for associating a lifespan to said composite event using said sequence operator.
-
-
12. A system for monitoring events in a database, said system comprising a processor performing a method comprising:
-
storing in said database at least one database rule; mapping temporal constraints of an event of said database rule to corresponding temporal events; changing said temporal constraints associated with said temporal events based upon related temporal constraints for related events of said database rule to provide changed temporal constraints; registering alarms associated with a start and end of a lifespan of each of said temporal events; selectively deploying and selectively permanently removing ones of said temporal events from said database based upon said changed temporal constraints; upon reaching said end of said lifespan of each of said temporal events, permanently removing from said database said alarm associated with said ones of said temporal events permanently removed from said database; combining said temporal events using a sequence operator to form a composite event; and associating a lifespan to said composite event using said sequence operator.
-
-
13. A non-transitory program storage device medium readable by computer, tangibly embodying a program of instructions executable by said computer to perform a method of monitoring events in a database, said method comprising:
-
storing in said database at least one database rule; mapping temporal constraints of an event of said database rule to corresponding temporal events; changing said temporal constraints associated with said temporal events based upon related temporal constraints for related events of said database rule to provide changed temporal constraints; registering alarms associated with a start and end of a lifespan of each of said temporal events; selectively deploying and selectively permanently removing the temporal events from said database based upon said changed temporal constraints; upon reaching said end of said lifespan of each of said temporal events, permanently removing from said database said alarm associated with said ones of said temporal events permanently removed from said database; combining said temporal events using a sequence operator to form a composite event; and associating a lifespan to said composite event using said sequence operator. - View Dependent Claims (16, 17)
-
Specification