Database system concepts
Fundamentals of database systems
Fundamentals of database systems
An introduction to database systems: vol. 1 (5th ed.)
An introduction to database systems: vol. 1 (5th ed.)
Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
Database modeling & design (2nd ed.): the fundamental principles
Database modeling & design (2nd ed.): the fundamental principles
Object-oriented modeling and design for database applications
Object-oriented modeling and design for database applications
Understanding SQL's stored procedures: a complete guide to SQL/PSM
Understanding SQL's stored procedures: a complete guide to SQL/PSM
The Unified Modeling Language user guide
The Unified Modeling Language user guide
The object constraint language: precise modeling with UML
The object constraint language: precise modeling with UML
SQL: 1999, formerly known as SQL3
ACM SIGMOD Record
Modular architecture for a toolset supporting OCL
Science of Computer Programming - Special issue on unified modeling language (UML 2000)
OCL as a Specification Language for Business Rules in Database Applications
«UML» '01 Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools
On Querying UML Data Models with OCL
«UML» '01 Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools
On the Precise Meaning of OCL Constraints
Object Modeling with the OCL, The Rationale behind the Object Constraint Language
Graphic Language for Describing Constraints on Diagrams of UML Classes
Programming and Computing Software
Environmental Modelling & Software
Enriching the class diagram concepts to capture natural language semantics for database access
Data & Knowledge Engineering
Journal of Systems and Software
Bridging the semantic gap in OLAP models: platform-independent queries
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
From the conceptual design of spatial constraints to their implementation in real systems
Proceedings of the 17th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses
Information Sciences: an International Journal
Formalizing the well-formedness rules of EJB3QL in UML + OCL
MoDELS'06 Proceedings of the 2006 international conference on Models in software engineering
UML'00 Proceedings of the 3rd international conference on The unified modeling language: advancing the standard
Modular architecture for a toolset supporting OCL
UML'00 Proceedings of the 3rd international conference on The unified modeling language: advancing the standard
Modeling data federations in ORM
OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems - Volume Part I
Information Sciences: an International Journal
Listen to the customer: model-driven database design
Proceedings of the Fourteenth International Database Engineering & Applications Symposium
An object-oriented framework for reconciliation and extraction in heterogeneous data federations
ADVIS'04 Proceedings of the Third international conference on Advances in Information Systems
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
MIS'04 Proceedings of the 2004 international conference on Metainformatics
APCCM '13 Proceedings of the Ninth Asia-Pacific Conference on Conceptual Modelling - Volume 143
Hi-index | 0.00 |
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.