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

• 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: Informática; DML
• Online Access: http://hdl.handle.net/10016/8238; https://doi.org/10.1007/11788911_3

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