Extending UML Profiles to Model Integrity Constraints in SQL Databases

摘要

UML is a general-purpose visual modeling language that can be adapted by creating profiles based on its built-in extension mechanism. There exist UML profiles for modeling the logical design of SQL databases. The profiles allow developers to create model elements that correspond to SQL language elements. In case of many integrity constraints, developers have to manually specify the implementation of the constraint in a model. It complicates the creation of the models and the use the models to generate final code that does not need elaboration. In this paper, we propose to extend UML SQL database design profiles with stereotypes that correspond to domain-independent database design patterns about integrity constraints to raise the abstraction level of models and facilitate generation of code that implements integrity constraints. We also present the results of an experiment about extending a UML SQL database design profile.