SQL Triggers Reacting on Time Events: An Extension Proposal

Saved in:
Bibliographic Details
Title: SQL Triggers Reacting on Time Events: An Extension Proposal
Authors: Andreas Behrend, Christian Dorau, Rainer Manthey, Stefano Ceri, Roberta Cochrane, Jennifer Widom, Identified Timebased
Contributors: The Pennsylvania State University CiteSeerX Archives
Source: http://www.informatik.uni-bonn.de/~behrend/adbis09b.pdf.
Collection: CiteSeerX
Description: 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.
Document Type: text
File Description: application/pdf
Language: English
Relation: http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.158.2340
Availability: http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.158.2340
http://www.informatik.uni-bonn.de/~behrend/adbis09b.pdf
Rights: Metadata may be used without restrictions as long as the oai identifier remains attached to it.
Accession Number: edsbas.11A6F664
Database: BASE
Description
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.