SQL Triggers Reacting on Time Events: An Extension Proposal

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.

[1]  Eric N. Hanson,et al.  Timer-driven database triggers and alerters: semantics and a challenge , 1999, SGMD.

[2]  Juan Carlos Augusto,et al.  Two Approaches to Event Definition , 2002, DEXA.

[3]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[4]  Joakim Eriksson,et al.  Real-Time and Active Databases: A Survey , 1997, ARTDB.

[5]  Sharma Chakravarthy,et al.  Snoop: An Expressive Event Specification Language for Active Databases , 1994, Data Knowl. Eng..

[6]  Jennifer Widom,et al.  Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award) , 2000, VLDB.

[7]  Peter Scheuermann,et al.  Active Database Systems , 2008, Wiley Encyclopedia of Computer Science and Engineering.

[8]  Hamid Pirahesh,et al.  Integrating Triggers and Declarative Constraints in SQL Database Systems , 1996, VLDB.

[9]  Sharma Chakravarthy,et al.  Composite Events for Active Databases: Semantics, Contexts and Detection , 1994, VLDB.

[10]  Narain H. Gehani,et al.  Ode as an Active Database: Constraints and Triggers , 1991, VLDB.

[11]  Klaus R. Dittrich,et al.  SAMOS in hindsight: experiences in building an active object-oriented DBMS , 2003, Inf. Syst..

[12]  Andreas Behrend,et al.  Incremental view-based analysis of stock market data streams , 2008, IDEAS '08.

[13]  Umeshwar Dayal,et al.  The HiPAC project: combining active databases and timing constraints , 1988, SGMD.

[14]  Eric Simon,et al.  Promises and Realities of Active Database Systems , 1995, VLDB.

[15]  Eric N. Hanson,et al.  The Design and Implementation of the Ariel Active Database Rule System , 1996, IEEE Trans. Knowl. Data Eng..

[16]  Alan R. Simon,et al.  Sql: 1999 Understanding Relational Language Components , 2002 .

[17]  Lan Huang,et al.  Scalable trigger processing , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[18]  Lisa McClain,et al.  Oracle Database 10g PL/SQL Programming , 2004 .

[19]  Jennifer Widom,et al.  Active Database Systems: Triggers and Rules For Advanced Database Processing , 1994 .

[20]  Jörgen Hansson,et al.  Active, Real-Time, and Temporal Database Systems , 2000, Lecture Notes in Computer Science.

[21]  Wenfei Fan,et al.  Keys with Upward Wildcards for XML , 2001, DEXA.

[22]  Jennifer Widom,et al.  Practical Applications of Triggers and Constraints: Successes and Lingering Issues , 2000 .

[23]  Michael Stonebraker,et al.  Monitoring Streams - A New Class of Data Management Applications , 2002, VLDB.