Data Management Investigate

SQL Triggers Reacting on Time Events: An Extension Proposal

Download now Free registration required

Executive Summary

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. The authors therefore propose a seamless extension of the SQL trigger concept by time-based triggers, focusing on semantic issues arising from such an extension.

  • Format: PDF
  • Size: 205.8 KB