Using UML’s Sequence Diagrams for Representing Execution Models Associated to Triggers

11 pages, 3 figures.-- Contributed to: 23rd British National Conference on Databases (BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006). Using active rules or triggers to verify integrity constraints is a serious and complex problem because these mechanisms have behaviour that could be diff...

Full description

Bibliographic Details
Main Authors: Al-Jumaily, Harith T., Pablo-Sánchez, César de, Cuadra Fernández, María Dolores, Martínez Fernández, Paloma
Format: Conference Object
Language:English
Published: Springer 2006
Subjects:
DML
Online Access:http://hdl.handle.net/10016/8238
https://doi.org/10.1007/11788911_3
Description
Summary:11 pages, 3 figures.-- Contributed to: 23rd British National Conference on Databases (BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006). Using active rules or triggers to verify integrity constraints is a serious and complex problem because these mechanisms have behaviour that could be difficult to predict in a complex database. The situation is even worse as there are few tools available for developing and verifying them. We believe that automatic support for trigger development and verification would help database developers to adopt triggers in the database design process. Therefore, in this work we suggest a visualization add-in tool that represents and verifies triggers execution by using UML’s sequence diagrams. This tool is added in RATIONAL ROSE and it simulates the execution sequence of a set of triggers when a DML operation is produced. This tool uses the SQL standard to express the triggers semantics and execution. This work is part of the project "Software Process Management Platform: modelling, reuse and measurement". TIN2004/07083. Publicado