Optimal Deployment of Triggers for Detecting Events
In active d atabases, rules are represented in the form of ECA (event-condition-action). Database events can be detected by defining triggers on the underlying application databases. Many-a-times, temporal conditions that limit the validity period of the event are as sociated with the ECA rule. The performance of the database can get adversely affected if such temporal constraints are checked (either at the application level or at database level) for every transaction (event) irrespective of whether that transaction (event) has occurred within the said time interval. This drawback can be avoided by optimizing the temporal constraints associated with the sub-events of a composite event based on the semantics of the composite event operators. This paper describes such an algorithm that optimizes the temporal constraints associated with (composite) events and improves the efficiency of the databases by creating and destroying triggers dynamically such that the semantics of the event is unchanged. The efficiency of the technique is validated by our experimental results.
Unable to display preview. Download preview PDF.
- 4.Chamberlin, D.: A Complete Guide to DB2 Universal DatabaseGoogle Scholar
- 6.Hanson, E.N.: Rule condition testing and action execution in Ariel. In: Proceedings of the ACM SIGMOD International Conference on Management of Data (June 1992)Google Scholar
- 8.Kiernan, J., Maindreville, C.: Implementing high-level active rules on top of relational databases. In: Proceedings of the 18th International Conference on Very Large Databases (August 1992)Google Scholar
- 9.Lehner, W.: Modeling Large Scale OLAP Scenarios. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 153–167. Springer, Heidelberg (1998)Google Scholar
- 10.Miller, J., Sheth, A., Kochut, K.: Perspectives in Modeling: Simulation, Database, and Workflow, Conceptual Modeling, pp. 154–167 (1997)Google Scholar
- 14.Transaction Processing Performance Council, http://www.tpc.org/tpcr/