Optimal use of triggers for detecting database events
First Claim
Patent Images
1. A method of monitoring events in a database comprising the steps of:
- storing in the database at least one database rule;
mapping temporal constraints of an event of the database rule to corresponding temporal events;
changing the temporal constraints associated with the temporal events based upon temporal constraints for related events of the database rule; and
selectively deploying and selectively removing the temporal events from the database based upon the changed temporal constraints.
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
15 Claims
-
1. A method of monitoring events in a database comprising the steps of:
-
storing in the database at least one database rule;
mapping temporal constraints of an event of the database rule to corresponding temporal events;
changing the temporal constraints associated with the temporal events based upon temporal constraints for related events of the database rule; and
selectively deploying and selectively removing the temporal events from the database based upon the changed temporal constraints. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A database recorded on a computer storage medium comprising:
-
software code means for mapping temporal constraints of an event of a database rule to corresponding temporal events;
software code means for changing the temporal constraints associated with the temporal events based upon temporal constraints for related events of the database rule; and
software code means for selectively deploying and selectively removing the temporal events from the database based upon the changed temporal constraints.
-
-
14. A computer system that stores a database comprising:
-
means for mapping temporal constraints of an event of a database rule to corresponding temporal events;
means for changing the temporal constraints associated with the temporal events based upon temporal constraints for related events of the database rule; and
means for selectively deploying and selectively removing the temporal events from the database based upon the changed temporal constraints.
-
-
15. A computer program product comprising:
-
software code means for mapping temporal constraints of an event of a database rule to corresponding temporal events;
software code means for changing the temporal constraints associated with the temporal events based upon temporal constraints for related events of the database rule; and
software code means for selectively deploying and selectively removing the temporal events from the database based upon the changed temporal constraints.
-
Specification