Using UML/OCL constraints for relational database design

  • Authors:
  • Birgit Demuth;Heinrich Hussmann

  • Affiliations:
  • Dresden University of Technology, Department of Computer Science;Dresden University of Technology, Department of Computer Science

  • Venue:
  • UML'99 Proceedings of the 2nd international conference on The unified modeling language: beyond the standard
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

Integrating relational databases into object-oriented applications is state of the art in software development practice. In database applications, it is beneficial if constraints like business rules are encoded as part of the database schema and not in the application programs. The Object Constraint Language (OCL) as part of the Unified Modeling Language (UML) provides the posssibility to express constraints in a conceptual model unambiguously. We show how OCL, UML and SQL can be used in database constraint modeling, and discuss their advantages and limitations. Furthermore, we present patterns for mapping OCL expressions to SQL code.