loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Author: Pedro Nogueira Ramos

Affiliation: ADETTI /ISCTE-IUL, Portugal

ISBN: 978-989-8565-60-0

Keyword(s): UML, SQL, Case, Relational Model, Deontic Constraints.

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.

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.233.224.8

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.