25 - 29 de Noviembre de 2002

Montevideo, Uruguay

Radisson Victoria Plaza Hotel

 
CL30
 
Towards the Mapping of Dynamic Properties of Objects, described by UML State Diagrams, on Rel-dbs

José M. Maciel
University of Caixas do Sul. Sciences and Comunication Dept.
jmmaciel@ucs.br
Duncan D. Ruiz
Pontifical Catholic University of RS, Dept. of applied Computing
duncan@inf.pucrs.br
 
Abstract

The work presents an approach to map objects behavior, described by UML State Diagrams, to Relational Database Systems description models by the use of SQL Triggers (E-C-A rules of active databases). The UML State Diagram concepts properly handled by our approach are: states, composite states (without concurrent sub-states), events, simple transitions and transitions to and from composite states, according with the terminology presented by the latest OMG-UML standard (1.4). We argue the intra-objects dynamic properties can be properly implemented using triggers, by the use of implementation patterns and well-defined mapping rules. The contribution of this research is a method to describe a larger part of an application being modeled into the application database and managed by the corresponding DBMS. This approach relieves the amount of programming needed and improves the autonomy of such application database. In addition, such approach improves the robustness of databases against undesirable changes.

Keywords: Relational databases, Active databases, SQL Triggers, UML.



Volver

infoUYclei 2002