Integrity Constraint Enforcement by Means of Trigger Templates
Eladio Domínguez5
, Jorge Lloret5
and María Antonia Zapata5 
| (5) |
Dpt. de Informática e Ingeniería de Sistemas., Universidad de Zaragoza., E-50009 Zaragoza., Spain |
Abstract
The specification of data integrity controls in DBMS, and particularly support for triggers, is one of the most important
features for database developers and administrators. However, it is recognized that the specification of a correct set of
triggers is a difficult and errorprone task. Our proposal aims to facilitate such a task by suggesting a different method
for determining constraints and triggers that check constraints when database updates take place. Specifically, the method
proposes to define trigger templates in order to enforce constraints imposed in a schema pattern and to store them in a database.
When the analyst specifies a particular conceptual schema (which matches the schema pattern) the associated triggers are automatically
generated from the information stored in the trigger template database.
Keywords Active database systems - Integrity constraint enforcement - Trigger generation - Trigger template
This work has been partially supported by DGES, projects TIC2000-1368-C03-01 and PB-96-0098-C04-01, and by University of Zaragoza,
project UZ-00-TEC-04.
References secured to subscribers.