Deontic Database Constraints - From UML to SQL

Pedro Nogueira Ramos

2013

Abstract

Deontic constraints (obligations, forbiddances, violations) can be easily and explicitly represented in UML Class Diagrams. They deal with formal representation of requirements, which ideally should always be fulfilled, but can be violated, in atypical situations. In this paper we adopt and extend previous work on deontic constraints. Our contribution is the development of a tool that fully generates code based on UML Class Diagrams representation of those constraints. We overcome some limitations of previous work, and consequently we only adopt standard UML notations. Our tool (a Sybase PowerDesigner plugin) generates OCL constraints, a standard relational model, and SQL code to hold the deontic requirements. SQL is coded in views and triggers. Since we adopt a commercial tool, these enrichments will benefit any non-professional users.

Paper Citation

in Harvard Style

Nogueira Ramos P. (2013). Deontic Database Constraints - From UML to SQL . In Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 2: ICEIS, ISBN 978-989-8565-60-0, pages 102-109. DOI: 10.5220/0004415801020109

in Bibtex Style

@conference{iceis13,
author={Pedro Nogueira Ramos},
title={Deontic Database Constraints - From UML to SQL},
booktitle={Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 2: ICEIS,},
year={2013},
pages={102-109},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004415801020109},
isbn={978-989-8565-60-0},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 2: ICEIS,
TI - Deontic Database Constraints - From UML to SQL
SN - 978-989-8565-60-0
AU - Nogueira Ramos P.
PY - 2013
SP - 102
EP - 109
DO - 10.5220/0004415801020109