Skip to main content
SpringerLink
Log in
Book cover

International Conference on Business Process Modeling, Development and Support

International Conference on Evaluation and Modeling Methods of Systems Analysis and Development

BPMDS 2016, EMMSAD 2016: Enterprise, Business-Process and Information Systems Modeling pp 399–413Cite as

On Suitability of Standard UML Notation for Relational Database Schema Representation

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 248))

Abstract

The suitability of the standard UML notation for representation of relational database schema has been considered in this paper. Unlike the existing approaches using specialized notation (UML profiles), in this paper we propose an alternative approach for representation of relational database schema by standard UML class diagram. Apart from the analysis of the suitability of the isID (meta)attribute, we propose an alternative representation of composite keys by using class operations. The main idea of the proposed approach is based on the fact that the standardized order of operation parameters can be used to represent the order of key segments. The proposed approach is illustrated by a simple model in forward engineering of relational database.

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

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 EPUB and 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

Learn about institutional subscriptions

Notes

  1. 1.

    This fact is not explicitly represented in class diagrams, since the 1..1 multiplicity is default. Allowed null values would require that the lower multiplicity of attributes is 0, which would be shown in the class diagram in the form of [0..1].

  2. 2.

    This conclusion is valid for all UML 2.x specifications.

References

  1. Codd, E.: A relational model of data for large shared data banks. Commun. ACM 13(5), 377–387 (1970)

    Article  Google Scholar 

  2. Martin, J.: Information Engineering. Prentice Hall, Englewood Cliffs (1990)

    Google Scholar 

  3. NIST: FIPSP 184 - Integration Definition for Information Modeling (IDEF1X). NIST, Gaithersburg (1993)

    Google Scholar 

  4. OMG: Unified Modeling Language (OMG UML), v2.5. OMG (2015)

    Google Scholar 

  5. OMG: Request for Proposal Information Management Metamodel (IMM). OMG (2005)

    Google Scholar 

  6. Naiburg, E., Maksimchuk, R.: UML for Database Design. Addison-Wesley, Reading (2001)

    Google Scholar 

  7. Li, L., Zhao, X.: UML specification of relational database. J. Object Technol. 2(5), 87–100 (2003)

    Article  Google Scholar 

  8. Ambler, S.W.: Agile Database Techniques. John Wiley and Sons, Indianapolis (2003)

    Google Scholar 

  9. Lo, C.M., Hung, H.Y.: Towards a UML profile to relational database modeling. Appl. Math. Inf. Sci. 8(2), 733–743 (2014)

    Article  Google Scholar 

  10. Marcos, E., Vela, B., Cavero, J.M.: A methodological approach for object-relational database design using UML. Softw. Syst. Model. 2, 59–72 (2003)

    Article  Google Scholar 

  11. Tomic, I., Brdjanin, D., Maric, S.: A novel UML profile for representation of a relational database schema. In: Proceedings of EUROCON 2015, pp. 1–6. IEEE (2015)

    Google Scholar 

  12. Muller, R.J.: Database Design for Smarties: Using UML for Data Modeling. Morgan Kaufmann Publishers, San Francisco (1999)

    Google Scholar 

  13. Armonas, A., Nemuraite, L.: Pattern based generation of full-fledged relational schemas from UML/OCL models. Inf. Technol. Control 35(1), 27–33 (2006)

    Google Scholar 

  14. Lo, C.M., Huang, S.J.: MDA-based rapid application framework. Int. J. Advancements Comp. Tech. 4(8), 307–314 (2012)

    Article  Google Scholar 

  15. OMG: Unified Modeling Language: Infrastructure, v2.4. OMG (2010)

    Google Scholar 

  16. OMG: Unified Modeling Language: Infrastructure, v2.4.1. OMG (2011)

    Google Scholar 

  17. ISO, IEC: ISO/IEC FDIS 9075–1 Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework). ISO/IEC (2011)

    Google Scholar 

  18. ISO, IEC: Acceleo. http://www.eclipse.org/acceleo/

  19. OMG: MOF 2.0/XMI Mapping Specification, v2.1. OMG (2007)

    Google Scholar 

  20. OMG: MOF 2 XMI Mapping Specification, v2.1.1. OMG (2007)

    Google Scholar 

  21. OMG: OMG MOF 2 XMI Mapping Specification, v2.4.1. OMG (2013)

    Google Scholar 

  22. OMG: XML Metadata Interchange (XMI) Specification, v2.5.1. OMG (2015)

    Google Scholar 

  23. ISO: Information technology - Object Management Group Object Constraint Language (OCL). ISO/IEC 19507: 2012 (2012)

    Google Scholar 

  24. Heidenreich, F., Wende, C., Demuth, B.: A framework for generating query language code from OCL invariants. ECEASST 9, 1–10 (2008)

    Google Scholar 

  25. Embley, D.W., Mok, W.Y.: Mapping conceptual models to database schemas. In: Embley, D.W., Thalheim. B., (eds.) Handbook of Conceptual Modeling, pp. 123–163. Springer, Heidelberg (2011)

    Google Scholar 

  26. TOPCASED Project: Toolkit in OPen-source for Critical Application & SystEms Development, v5.3.1. http://www.topcased.org

  27. Brdjanin, D., Maric, S., Gunjic, D.: ADBdesign: an approach to automated initial conceptual database design based on business activity diagrams. In: Catania, B., Ivanović, M., Thalheim, B. (eds.) ADBIS 2010. LNCS, vol. 6295, pp. 117–131. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  28. Brdjanin, D., Maric, S.: An approach to automated conceptual database design based on the UML activity diagram. Comput. Sci. Inf. Syst. 9(1), 249–283 (2012)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Electrical Engineering, University of Banja Luka, Patre 5, 78000, Banja Luka, Bosnia and Herzegovina

    Drazen Brdjanin & Slavko Maric

  2. RT-RK Institute, Patre 5, 78000, Banja Luka, Bosnia and Herzegovina

    Zvjezdan Spasic Pavkovic

Authors
  1. Drazen Brdjanin
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Slavko Maric
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Zvjezdan Spasic Pavkovic
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Drazen Brdjanin .

Editor information

Editors and Affiliations

  1. Munich University of Applied Scienc, Munich, Germany

    Rainer Schmidt

  2. Luxembourg Inst. of Science & Technology, Esch-sur-Alzette, Luxembourg

    Wided Guédria

  3. Dept. of Computer and Systems Sciences, Stockholm University, Stockholm, Sweden

    Ilia Bider

  4. Univ. Lusófona de Humanidades e Techn., Lisboa, Portugal

    Sérgio Guerreiro

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Brdjanin, D., Maric, S., Pavkovic, Z.S. (2016). On Suitability of Standard UML Notation for Relational Database Schema Representation. In: Schmidt, R., Guédria, W., Bider, I., Guerreiro, S. (eds) Enterprise, Business-Process and Information Systems Modeling. BPMDS EMMSAD 2016 2016. Lecture Notes in Business Information Processing, vol 248. Springer, Cham. https://doi.org/10.1007/978-3-319-39429-9_25

Download citation

Publish with us

Policies and ethics

Search

Navigation