Skip to main content

On Using UML Class Diagrams for Object-Oriented Database Design

Specification of Integrity Constraints

  • Conference paper
The Unified Modeling Language. «UML»’98: Beyond the Notation (UML 1998)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1618))

Included in the following conference series:

Abstract

In the course of object-oriented software engineering, the UML class diagrams are used to specify the static structure of the system under study, such as classes, types and various kinds of static relationships among them. Objects of the persistent classes can be stored in object-oriented databases or in relational databases. In the former case, the UML class diagrams are actually used for conceptual object-oriented database designs. However, the standard UML class diagram lacks the ability to specify some inherent integrity constraints, such as keys and uniqueness, for object-oriented databases. This paper proposes an extension to the UML metamodel, i.e., the introduction of two new model elements (key and IConstraint) and some new attributes to the existing metamodel, to accommodate further, additional features for constraint specification. On the model level, a compartment CONSTRAINT of the class notation and some property strings for displaying the integrity constraints are added. The database design is then mapped to the extended ODMG-ODL schema definition.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database Design: An Entity-Relationship Approach. The Benjamin/Cummings Publishing Company, Inc. (1992)

    Google Scholar 

  2. Cattell, R.G.G., Barry, D.: The Object Database Standard: ODMG 2.0. Morgan Kaufmann Publishers, Inc. (1997)

    Google Scholar 

  3. Ceri, S., Widom, J.: Deriving production rules for constraint maintenance. In: Proc. 16th Intl. Conf. in Very Large Data Bases, pp. 567–577. Morgan Kaufmann, San Mateo (1990)

    Google Scholar 

  4. Widom, J., Ceri, S. (eds.): Active Database Systems: Triggers and Rules for Advanced Database Processing. Morgan Kaufmann Publishers, San Francisco (1996)

    Google Scholar 

  5. Chen, P.P.: The Entity-Relationship Model - Toward a Unified View of Data. ACM Transactions on Database Systems 1(1), 9–36 (1976)

    Article  Google Scholar 

  6. Date, C.J.: An Introduction to Database Systems, 6th edn. Addison-Wesley Publishing Company, Inc., Reading (1995)

    MATH  Google Scholar 

  7. The DB-MAIN Database Engineering CASE Tool developed by Professor J-L. Hainaut, http://www.info.fundp.ac.be/dbm/index.html

  8. Diaz, O.: Deriving rules for constraint maintenance in an object-oriented database. In: Ramos, I., Tjoa, A.M. (eds.) Proc. Intl. Conf. on Databases and Expert Systems DEXA, pp. 332–337. Springer, Berlin (1992)

    Google Scholar 

  9. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 2nd edn. The Benjamin/Cummings Publishing Company, Inc. (1994)

    Google Scholar 

  10. ERwin Features Guide. Logic Works, Inc. (1997)

    Google Scholar 

  11. Fahrner, C., Vossen, G.: Transforming Relational Database Schemas into Object-Oriented Schemas according to ODMG-1993. In: Proceedings of the 4th International Conference on Deductive and Object-Oriented Database, National University of Singapore, December 1995, pp. 429–446 (1995)

    Google Scholar 

  12. Gehani, N., Jagadish, H.V.: Ode as an active database: Constraints and triggers. In: Proceedings of the Seventeenth International Conference on Very Large Data Bases, Barcelona, Spain, September 1991, pp. 327–336 (1991)

    Google Scholar 

  13. Jagadish, H.V., Qian, X.: Integrity Maintenance in an Object-Oriented Database. In: Proc. of the 18th Int’l Conf. on Very Large Databases, Vancouver, BC, Canada (August 1992)

    Google Scholar 

  14. Rational Rose 98: Using Rational Rose / Oracle8. Rational Software Corporation (1998)

    Google Scholar 

  15. Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F., Lorensen, W.: Object- Oriented Modeling and Design. Prentice-Hall, Englewood Cliffs (1991)

    MATH  Google Scholar 

  16. UML Notation Guide, Version 1.1, Rational Software Corporation, 1 September (1997), http://www.rational.com/uml/

  17. UML Object Constraint Language Specification, Version 1.1, Rational Software Corporation (September 1, 1997)

    Google Scholar 

  18. UML Semantics, Version 1.1, Rational Software Corporation, (September 1 1997)

    Google Scholar 

  19. Urban, S.D., Desiderio, M.: Translating constraints to rules in CONTEXT: A CONstrainT EXplanation Tool. In: Kent, W., Meersman, R.A., Khosla, S. (eds.) Object-Oriented Databases: Analysis, Design and Construction, pp. 373–392. North-Holland, Amsterdam (1991)

    Google Scholar 

  20. The O2 System. O2 Technology, Paris, France, http://www.o2tech.com

  21. Object Design Inc., Burlington, MA, USA, http://www.odi.com

  22. Servio logic Inc., Beaverton, USA, http://www.gemstone.com

  23. ONTOS Inc., Burlington, MA, USA, http://www.ontos.com

  24. Gogolla, M., Richters, M.: On Constraints and Queries in UML. In: Schader, M., Korthaus, A. (eds.) The Unified Modeling Language: Technical Aspects and Applications, pp. 109–121. Physica-Verlag, Heidelberg (1997)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Ou, Y. (1999). On Using UML Class Diagrams for Object-Oriented Database Design. In: Bézivin, J., Muller, PA. (eds) The Unified Modeling Language. «UML»’98: Beyond the Notation. UML 1998. Lecture Notes in Computer Science, vol 1618. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-48480-6_14

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-48480-6_14

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66252-5

  • Online ISBN: 978-3-540-48480-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics