Using UML/OCL constraints for relational database design
Birgit Demuth,Heinrich Hussmann +1 more
TLDR
This work shows how OCL, UML and SQL can be used in database constraint modeling, and discusses their advantages and limitations, and presents patterns for mapping OCL expressions to SQL code.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.read more
Citations
More filters
Book ChapterDOI
OCL as a Specification Language for Business Rules in Database Applications
TL;DR: A flexible SQL code generator is needed which can be used and adapted for different relational database systems and different object-to-table mappings and is implemented as an additional module for the OCL toolset using XML techniques.
Journal ArticleDOI
Modular architecture for a toolset supporting OCL
TL;DR: A flexible modular architecture for a UML/OCL toolset is proposed and the first results of an ongoing project which aims at the provision of such an OCL toolset for the public domain are reported.
Proceedings ArticleDOI
Handwritten Bangla Compound Character Recognition Using Gradient Feature
TL;DR: This paper deals with recognition of off-line Bangla handwritten compound characters using modified quadratic discriminant function (MQDF) and obtained 85.90% accuracy from a dataset of Bangla compound characters containing 20,543 samples.
Book ChapterDOI
UMLtoGraphDB: Mapping Conceptual Schemas to Graph Databases
TL;DR: This article describes a mapping from UML/OCL conceptual schemas to Blueprints, an abstraction layer on top of a variety of graph databases, and Gremlin, a graph traversal language, via an intermediate Graph metamodel.
Book ChapterDOI
On Querying UML Data Models with OCL
David H. Akehurst,Behzad Bordbar +1 more
TL;DR: The adoption of the ideas presented in this paper will enable query expressions to be written using OCL, that are elegant and ideally suited for use in conjunction with UML data models.
References
More filters
Book
The Unified Modeling Language User Guide
TL;DR: In The Unified Modeling Language User Guide, the original developers of the UML provide a tutorial to the core aspects of the language in a two-color format designed to facilitate learning.
Book
Fundamentals of Database Systems
TL;DR: Fundamentals of Database Systems combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions to modern database technologies.
Book
An Introduction to Database Systems
TL;DR: Readers of this book will gain a strong working knowledge of the overall structure, concepts, and objectives of database systems and will become familiar with the theoretical principles underlying the construction of such systems.
Book
Database System Concepts
TL;DR: This acclaimed revision of a classic database systems text provides the latest information combined with real-world examples to help readers master concepts in a technically complete yet easy-to-understand style.
Book
The object constraint language : precise modeling with UML
Jos Warmer,Anneke Kleppe +1 more
TL;DR: This book discusses modeling with Constraints in a UML Model, using Package Names in Navigations, using Pathnames in Inheritance Relations, and treating Instances as Collections.