On Querying UML Data Models with OCL
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.
- 1.Object Management Group; Unified Modelling Language Specification, version 1.3; OMG ad/99-06-08 (June 1999); http://www.omg.org.
- 2.Object Management Group; UML 2.0 RFI; OMG Document ad/99-08-08 (August 1999); http://www.omg.org.
- 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.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.R. G. G. Cattell; The Object Database Standard: ODMG 2.0; Morgan Kaufmann Publishers, Inc. (1997).Google Scholar
- 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.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.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.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.C. J. Date, H. Darwin; Foundation for Object/Relational Databases: The Third Manifesto; Addison Wesley Publishing Company, ISBN: 0201309785 (June 1998).Google Scholar
- 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.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
- 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
- 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.J. Melton, A. R. Simon; Understanding the New SQL: A Complete Guide; Morgan Kaufmann Publishers, Inc., ISBN: 1558602453 (1994).Google Scholar
- 18.Jan Nordén; Bold Executable Model Architecture; (June 2000); http://www.boldsoft.com/products/whitepapers/index.htm.
- 19.ModelRun; Boldsoft modelling tool; http://www.boldsoft.com/products/modelrun/.
- 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.B. Thalheim; Fundamentals of Entity-relationship Modeling; Springer-Verlag Berlin and Heidelberg GmbH & Co. KG, ISBN: 3540654704 (December 1999).Google Scholar
- 22.J. D. Ullman; Principles of Database Systems; Pitman Publishing Ltd, ISBN: 0273084763 (1980).Google Scholar
- 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