SQL Triggers Reacting on Time Events: An Extension Proposal

Authors:
Andreas Behrend;Christian Dorau;Rainer Manthey
Affiliations:
Institute of Computer Science III, University of Bonn, Bonn D-53117;Institute of Computer Science III, University of Bonn, Bonn D-53117;Institute of Computer Science III, University of Bonn, Bonn D-53117
Venue:
ADBIS '09 Proceedings of the 13th East European Conference on Advances in Databases and Information Systems
Year:
2009

Citing 18
Cited 1

The HiPAC project: combining active databases and timing constraints

ACM SIGMOD Record - Special Issue on Real-Time Database Systems
Snoop: an expressive event specification language for active databases

Data & Knowledge Engineering
Active database systems

ACM Computing Surveys (CSUR)
Timer-driven database triggers and alerters: semantics and a challenge

ACM SIGMOD Record
SQL:1999: understanding relational language components

SQL:1999: understanding relational language components
Active Database Systems: Triggers and Rules for Advanced Database Processing

Active Database Systems: Triggers and Rules for Advanced Database Processing
The Design and Implementation of the Ariel Active Database Rule System

IEEE Transactions on Knowledge and Data Engineering
Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award)

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Ode as an Active Database: Constraints and Triggers

VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Composite Events for Active Databases: Semantics, Contexts and Detection

VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Promises and Realities of Active Database Systems

VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Integrating Triggers and Declarative Constraints in SQL Database Sytems

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Real-Time and Active Databases: A Survey

ARTDB '97 Proceedings of the Second International Workshop on Active, Real-Time, and Temporal Database Systems
Two Approaches to Event Definition

DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
SAMOS in hindsight: experiences in building an active object-oriented DBMS

Information Systems
Oracle Database 10g PL/SQL Programming

Oracle Database 10g PL/SQL Programming
Monitoring streams: a new class of data management applications

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Incremental view-based analysis of stock market data streams

IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications

Integrating CEP and BPM: how CEP realizes functional requirements of BPM applications (industry article)

Proceedings of the 6th ACM International Conference on Distributed Event-Based Systems

Quantified Score

Hi-index	0.00

Visualization

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.