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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Blaha, M., Premerlani, W.: Object-Oriented Modeling and Design for Database Applications. Prentice Hall, 1998
Booch, G., Rumbaugh, J., Jacobson, I.: The Unified Modeling Language User Guide. Addison-Wesley, 1999
Bruce, K., Whitenack, B.: Crossing Chasms-A Pattern Language for Object-RDBMS Integration. Knowledge Systems Corp., ftp://members.aol.com/kgb1001001/Chasms/chasms.pdf
Date, C.: An Introduction to Database Systems. Volume I, Fifth Edition, Addison-Wesley, 1990
Demuth, B., Geppert, A., Gorchs, T.: Algebraic Query Optimization in the CoOMS Structurally Object-oriented Database System. in: Freytag, Ch., Maier, D., Vossen, G. (Ed.): Query Processing For Advanced Database Systems. Morgan Kaufmann, 1994
Dresden UML Toolset, http://www-st.inf.tu-dresden.de/UMLToolset
Eisenberg, A., Melton, J.: SQL: 1999, formerly known as SQL-3. ACM SIGMOD Record, 22(1999)1, 131–138
Elmasri, R., Navathe, S.: Fundamentals of Database Systems. Benjamin/Cummings, 1989
Gogolla, M., Richters, M.: On Constraints and Queries in UML. in: Schader, M., Korthaus, A., (Ed.): The Unified Modeling Language. Technical Aspects and Applications. Physica-Verlag, 1998
Korth, H., Silberschatz, A.: Database System Concepts. Second Edition. McGraw-Hill, 1991
Melton, J., Simon, A.: Understanding the New SQL: A Complete Guide. Morgan Kaufmann, 1993
Melton, J.: SQL’s Stored Procedures. A Complete Guide to SQL/PSM. Morgan Kaufmann, 1998
Olson, St. et. al.: The Sybase Architecture for Extensible Data Management. Bulletin of the Technical Committee on Data Engineering, IEEE Computer Society, 21(1998)3, 12–24
OMG UML Specification v. 1.3 draft
Ricardo, C.: Database Systems. Principles, Design, and Implementation. Macmillan, 1990
Schmidt, A.: Untersuchungen zur Abbildung von OCL-Ausdruecken auf SQL. Technische Universitaet Dresden, Diplomarbeit, 1998
Simons, A., Graham, I.: 37 Things that Don’t Work in Object-Oriented Modeling with UML. in: Kilov, H., Rumpe, B. (Ed.): Second ECOOP Workshop on Precise Behavioral Semantics. Technical Report, Technische Universitaet Muenchen, TUM-19813, Juni 1998
Teorey, T.: Database Modeling & Design. The Fundamental Principles. Second Edition, Morgan Kaufmann, 1990
Warmer, J., Kleppe, A.: The Object Constraint Language. Precise Modeling with UML. Addison-Wesley, 1999
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Demuth, B., Hussmann, H. (1999). Using UML/OCL Constraints for Relational Database Design. In: France, R., Rumpe, B. (eds) «UML»’99 — The Unified Modeling Language. UML 1999. Lecture Notes in Computer Science, vol 1723. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46852-8_42
Download citation
DOI: https://doi.org/10.1007/3-540-46852-8_42
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66712-4
Online ISBN: 978-3-540-46852-3
eBook Packages: Springer Book Archive