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.
منابع مشابه
Institut für Informatik III der Rheinischen Friedrich-Wilhelms-Universität Bonn Time-based Triggers for SQL: A Lingering Issue Revisited
Being able to activate triggers by timepoints reached or 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 severa...
متن کاملActive Database Systems for Monitoring and Surveillance
In many intelligence and security tasks it is necessary to monitor data in database in order to detect certain events or changes. Currently, database systems offer triggers to provide active capabilities. Most triggers, however, are based on the Event-Condition-Action paradigm, which can express only very primitive events. In this paper we propose an extension of traditional triggers in which t...
متن کاملSoundcheck for SQL
The lion's share of datalog features have been incorporated into the SQL3 standard proposal. However, most SQL manuals still recommend to implement user-de ned conditions for data integrity nondeclaratively, by triggers or stored procedures. We describe how to implement known declarative database technology for integrity checking in SQL databases. We show how to represent and evaluate arbitrari...
متن کاملPoint-based Temporal Extensions of Sql and Their Eecient Implementation 1.2 Our Proposal 2 the Data Model for Temporal Databases 3.1 Data Deenition Language 3.2 the Query Language
This chapter introduces a new approach to temporal extensions of SQL. The main diierence from most of the current proposals is the use single time points, rather than intervals or various other complex-values for references to time, while still achieving eecient query evaluation. The proposed language, SQL/TP, extends the syntax of SQL/92 to handle temporal data in a natural way: it adds a sing...
متن کاملEmotional Triggers of Acute Myocardial Infarction
Introduction: Cardiovascular diseases are the leading causes of death around the world. Identification of triggers that lead to acute coronary events in ischemic heart diseases and their prevention can reduce the complications of myocardial infarction. Objective: The purpose of this study is to determine emotional triggers in patients with acute Myocardial Infarction (MI). Materials and Metho...
متن کامل