On Querying UML Data Models with OCL

  • D. H. Akehurst
  • B. Bordbar
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2185)


UML is the de-facto standard language for Object-Oriented analysis and design of information systems. Persistent storage and extraction of data in such systems is supported by databases and query languages. UML sustains many aspects of software engineering; however, it does not provide explicit facility for writing queries. It is crucial for any such query language to have, at least, the expressive power of Relational Algebra, which serves as a benchmark for evaluating its expressiveness. The combination of UML and OCL can form queries with the required expressive power. However, certain extensions to OCL are essential if it is to be used effectively as a Query Language. 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. This technique is illustrated by expressing the UML equivalent of an example Relational data model and associated query expressions.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Object Management Group; Unified Modelling Language Specification, version 1.3; OMG ad/99-06-08 (June 1999); http://www.omg.org.
  2. 2.
    Object Management Group; UML 2.0 RFI; OMG Document ad/99-08-08 (August 1999); http://www.omg.org.
  3. 3.
    M. Blaha, W. Premerlani; Object-Oriented Modeling and Design for Database Applications; Prentice Hall Inc., ISBN: 0-13-123829-9 (1998).Google Scholar
  4. 4.
    P. Butterworth, A. Otis, J. Stein; The GemStone Object Database Management System; Communications of the ACM, 34(10) (1991) pp 64–77.Google Scholar
  5. 5.
    R. G. G. Cattell; The Object Database Standard: ODMG 2.0; Morgan Kaufmann Publishers, Inc. (1997).Google Scholar
  6. 6.
    P. P. Chen; The Entity-Relationship Model-Toward a Unified View of Data; ACM Transactions on Database Systems, 1(1) (1976).Google Scholar
  7. 7.
    E. F. Code; Relational completeness of database sub-languages; In Data Base Systems, R. Rustin, Ed., Prentice Hall, Englewood Cliffs (1972) pp 65–98.Google Scholar
  8. 8.
    S. Cook, A. Kleppe, R. Mitchell, B. Rumpe, J. Warmer, A. Wills; The Amsterdam Manifesto on OCL; (December 1999); http://www.trireme.com/amsterdam/.
  9. 9.
    C. J. Date; An Introduction to Database Systems (Introduction to Database Systems, 7th Ed); Addison Wesley Publishing Company, ISBN: 0201385902 (August 1999).Google Scholar
  10. 10.
    C. J. Date, H. Darwin; Foundation for Object/Relational Databases: The Third Manifesto; Addison Wesley Publishing Company, ISBN: 0201309785 (June 1998).Google Scholar
  11. 11.
    B. Demuth, H. Hussmann; Using UML/OCL Constraints for Relational Database Design; Proceedings of «UML»’ 99-The Unified Modelling Language: Beyond the Standard (October 1999) pp 598–613.Google Scholar
  12. 12.
    H. Hussmann, B. Demuth, F. Finger; Modular Architecture for a Toolset Supporting OCL; Proceedings of «UML» 2000-The Unified Modeling Language: Advancing the Standard (October 2000) pp 278–293.Google Scholar
  13. 13.
    O. Deux; The O2 System; Communications of the ACM, 34(10) (1991) pp 34–48.CrossRefGoogle Scholar
  14. 14.
    M. Gogolla, M. Richters; On Constraints and Queries in UML; Proc. UML’97 Workshop ‘The Unified Modeling Language-Technical Aspects and Applications’ (1997).Google Scholar
  15. 15.
    C. Lamb, G. Landis, J. Orenstein, D. Weinreib; The ObjectStore Database System. Communications of the ACM, 34(10) (1991) pp 50–63.CrossRefGoogle Scholar
  16. 16.
    L. Mandel, M. V. Cengarle; On the Expressive Power of OCL; FM’99-Formal Methods, World Congress on Formal Methods in the Development of Computing Systems, Toulouse, France, Springer LNCS 1708 (September 1999) pp 854–874.Google Scholar
  17. 17.
    J. Melton, A. R. Simon; Understanding the New SQL: A Complete Guide; Morgan Kaufmann Publishers, Inc., ISBN: 1558602453 (1994).Google Scholar
  18. 18.
    Jan Nordén; Bold Executable Model Architecture; (June 2000); http://www.boldsoft.com/products/whitepapers/index.htm.
  19. 19.
    ModelRun; Boldsoft modelling tool; http://www.boldsoft.com/products/modelrun/.
  20. 20.
    J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy, W. Lorensen; Object-oriented Modeling and Design; Prentice Hall International Paperback Editions, ISBN: 0136300545 (March 1991).Google Scholar
  21. 21.
    B. Thalheim; Fundamentals of Entity-relationship Modeling; Springer-Verlag Berlin and Heidelberg GmbH & Co. KG, ISBN: 3540654704 (December 1999).Google Scholar
  22. 22.
    J. D. Ullman; Principles of Database Systems; Pitman Publishing Ltd, ISBN: 0273084763 (1980).Google Scholar
  23. 23.
    J. B. Warmer, A. G. Kleppe; The Object Constraint Language: Precise Modeling With Uml (Addison-Wesley Object Technology Series); Addison Wesley Publishing Company; ISBN: 0201379406 (October 1998).Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • D. H. Akehurst
    • 1
  • B. Bordbar
    • 1
  1. 1.University of Kent at CanterburyCanterburyKent

Personalised recommendations