Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Aiken, A., Hellerstein, J.M., Widom, J.: Static Analysis Techniques for Predicting Behavior of Active Database Rules. ACM Transactions on Database Systems 20(1), 3–41 (1995)
Adaikkalavan, R., Chakravarthy, S., Snoop, I.B.: Interval-Based Event Specification and Detection for Active Databases. In: Kalinichenko, L.A., Manthey, R., Thalheim, B., Wloka, U. (eds.) ADBIS 2003. LNCS, vol. 2798, pp. 190–204. Springer, Heidelberg (2003)
Chakravarthy, S., Mishra, D.: Snoop: An Event Specification Language for Active Database. DKE 14(1), 1–26 (1994)
Chamberlin, D.: A Complete Guide to DB2 Universal Database
Dayal, U., et al.: The HiPAC project: Combining active databases and timing constraints. SIGMOD Record 17(1), 51–70 (1988)
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)
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)
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)
Miller, J., Sheth, A., Kochut, K.: Perspectives in Modeling: Simulation, Database, and Workflow, Conceptual Modeling, pp. 154–167 (1997)
http://otn.oracle.com/products/designer/pdf/9i-1_migration-guide.pdf
Paton, N.W., Diaz, O.: Active Database Systems. ACM Computing Surveys 31(1), 63–103 (1999)
Stonebraker, M., Kemnitz, G.: The POSTGRES next-generation database management system. Communications of the ACM 34(10), 78–92 (1991)
Transaction Processing Performance Council, http://www.tpc.org/tpcr/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bhide, M., Gupta, A., Joshi, M., Mohania, M. (2004). Optimal Deployment of Triggers for Detecting Events. In: Galindo, F., Takizawa, M., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2004. Lecture Notes in Computer Science, vol 3180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30075-5_7
Download citation
DOI: https://doi.org/10.1007/978-3-540-30075-5_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22936-0
Online ISBN: 978-3-540-30075-5
eBook Packages: Springer Book Archive