Welcome!
To use the personalized features of this site, please log in or register.
If you have forgotten your username or password, we can help.
My Menu
Saved Items

Integrity Constraint Enforcement by Means of Trigger Templates

Eladio DomínguezContact Information, Jorge LloretContact Information and María Antonia ZapataContact Information

(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.

Contact Information Eladio Domínguez
Email: noesis@posta.unizar.es

Contact Information Jorge Lloret
Email: jlloret@posta.unizar.es

Contact Information María Antonia Zapata
Email: mazapata@posta.unizar.es
Fulltext Preview (Small, Large)
Image of the first page of the fulltext

References secured to subscribers.



Export this chapter
Export this chapter as RIS | Text
 
Remote Address: 38.107.191.105 • Server: mpweb06
HTTP User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)