loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Author: Pedro Nogueira Ramos

Affiliation: ADETTI /ISCTE-IUL, Portugal

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.

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 44.200.194.255

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; ISSN 2184-4992, SciTePress, 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},
issn={2184-4992},
}

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
IS - 2184-4992
AU - Nogueira Ramos, P.
PY - 2013
SP - 102
EP - 109
DO - 10.5220/0004415801020109
PB - SciTePress