Abstract
Being able to activate triggers at timepoints reached or after time intervals elapsed has been acknowledged by many authors as a valuable functionality of a DBMS. Recently, the interest in time-based triggers has been renewed in the context of data stream monitoring. However, up till now SQL triggers react to data changes only, even though research proposals and prototypes have been supporting several other event types, in particular time-based ones, since long. We therefore propose a seamless extension of the SQL trigger concept by time-based triggers, focussing on semantic issues arising from such an extension.
This is a preview of subscription content, log in via an institution to check access.
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
American National Standard ANSI/ISO/ IEC 9075-1/2:1999. Information Systems–Database Languages–SQL–Part 1/2: Framework/Foundation. American National Standards Institute, Inc. (1999)
Behrend, A., Dorau, C., Manthey, R., Schüller, G.: Incremental View-Based Analysis of Stock Market Data Streams. In: IDEAS 2008, pp. 269–275 (2008)
Carney, D., et al.: Monitoring Streams - A New Class of Data Management Applications. In: VLDB 2002, pp. 215–226 (2002)
Ceri, S., Cochrane, R., Widom, J.: Practical Applications of Triggers and Constraints: Success and Lingering Issues. In: VLDB 2000, pp. 254–262 (2000)
Chakravarthy, S., et al.: Composite Events for Active Databases: Semantics, Contexts and Detection. In: VLDB 1994, pp. 606–617 (1994)
Chakravarthy, S., Mishra, D.: Snoop: An Expressive Event Specification Language for Active Databases. DKE 14(1), 1–26 (1994)
Cochrane, R., Pirahesh, H., Mattos, N.M.: Integrating Triggers and Declarative Constraints in SQL Database Sytems. In: VLDB 1996, pp. 567–578 (1996)
Ceri, S., Widom, J.: Active Database Systems: Triggers and Rules for Advanced Data Processing. Morgan Kaufmann, San Mateo (1996)
Dayal, U., et al.: The HiPAC Project: Combining Active Databases and Timing Constraints. SIGMOD Record 17(1), 51–70 (1988)
Dittrich, K.R., et al.: SAMOS in hindsight: experiences in building an active object-oriented DBMS. Information Systems 28(5), 369–392 (2003)
Eriksson, J.: Real-Time and Active Databases: A Survey. In: Andler, S.F., Hansson, J. (eds.) ARTDB 1997. LNCS, vol. 1553, pp. 1–23. Springer, Heidelberg (1998)
Galton, A., Augusto, J.C.: Two Approaches to Event Definition. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds.) DEXA 2002. LNCS, vol. 2453, pp. 547–556. Springer, Heidelberg (2002)
Gehani, N.H., Jagadish, H.V.: Ode as an Active Database: Constraints and Triggers. In: VLDB 1991, pp. 327–336 (1991)
Hanson, E.N.: The Design and Implementation of the Ariel Active Database Rule System. DKE 8(1), 157–172 (1996)
Hanson, E.N., et al.: Scalable Trigger Processing. In: ICDE 1999 (1999)
Hanson, E.N., Noronha, L.: Timer-Driven Database Triggers and Alerters: Semantics and a Challenge. SIGMOD Record 28(4), 11–16 (1999)
Melton, J., Simon, A.R.: SQL:1999 - Understanding Relational Language Components, 2nd edn. Morgan Kaufmann, USA (2001)
Paton, N.W., DÃaz, O.: Active Database Systems. ACM Computing Surveys 31(1), 63–103 (1999)
Simon, E., Kotz Dittrich, A.: Promises and Realities of Active Database Systems. In: VLDB 1995, pp. 642–653 (1995)
Snodgrass, R.T.: The TSQL2 Temporal Query Language, 2nd edn. Kluwer Academic Publishers, Dordrecht (2007)
Urman, S., Hardman, R., McLaughlin, M.: Oracle Database 10g PL/SQL Programming. McGraw-Hill, Emeryville/CA (2004)
Wernecke, J.: Eine Erweiterung des aktiven Daten- banksystems ARTA um relative Zeitereignisspezifika- tionen. Master Thesis, University of Bonn (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Behrend, A., Dorau, C., Manthey, R. (2009). SQL Triggers Reacting on Time Events: An Extension Proposal. In: Grundspenkis, J., Morzy, T., Vossen, G. (eds) Advances in Databases and Information Systems. ADBIS 2009. Lecture Notes in Computer Science, vol 5739. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03973-7_14
Download citation
DOI: https://doi.org/10.1007/978-3-642-03973-7_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-03972-0
Online ISBN: 978-3-642-03973-7
eBook Packages: Computer ScienceComputer Science (R0)