On transformations from UML models to object-relational databases

In this paper we consider the problems of transforming UML models into object-relational databases, which consist of static aspects and dynamic aspects. For the static aspects of the database, we first remove semantically overloaded elements, and then our algorithms generate Nested Normal Form nested tables. For the dynamic aspects of the database, we show how to map statechart diagrams into triggers. We begin our analysis of a statechart that potentially leads to nontermination of execution. We pay attention to the events, conditions, and actions of the transitions of states in the given statechart. Further we investigate the properties of confluence and observable determinism of the generated triggers.