Normalization Rules of the Object-Oriented Data Model

  • Vojtěch Merunka
  • Jakub Tůma
Conference paper
Part of the Lecture Notes in Electrical Engineering book series (LNEE, volume 152)


There are only very few approaches to normalizing object-oriented data. Approach to object-oriented database is called class normalization. In this paper we present an approach to normalization of the object-oriented conceptual model based on UML class diagrams. First part of the paper describes the current status in the area of formal methods used for object-oriented data modeling. Second part presents four normalization rules, which are based on own experience and modified Ambler-Beck approach. These normalization rules are introduced on an example. Our method has been used in education at several universities. It has been and is also used for database design in software development projects, which we carried out. Recently, development of the CASE tool based on this approach has been started.


Class normalization Data normalization Object-oriented data model (ODM) Relational data model (RDM) First object-oriented normal form (1ONF) Second object-oriented normal form (2ONF) Third object-oriented normal form (3ONF) Fourth object-oriented normal form (4ONF) 



The authors would like to acknowledge the support of the Czech Ministry of Education, Youth and Sports by the grant project MSM 6046070904.


  1. 1.
    David SF (2003) Model driven architecture: applying MDA to enterprise computing. Wiley, New York. ISBN 0-471-31920-1Google Scholar
  2. 2.
    Goldberg A, Rubin SK (1995) Succeeding with objects—decision frameworks for project management. Addison Wesley, Reading. ISBN 0-201-62878-3Google Scholar
  3. 3.
    Kroha P (1995) Objects and databases. McGraw Hill, London. ISBN 0-07-707790-3Google Scholar
  4. 4.
    Loomis M, Chaundri A Object databases in practice. ISBN 013899725XGoogle Scholar
  5. 5.
    Vanicek J (2004) Data gathering for science and research. Agric Econ 50(1):29–34Google Scholar
  6. 6.
    Mok WY, Ng Y-K, Embley DW (1992) An improved nested normal form for use in object-oriented software systems. In: Proceedings of the 2nd international computer science conference: data and knowledge engineering: theory and applications, December 1992. Hong Kong, pp 446–452Google Scholar
  7. 7.
    Beck K (2003) Agile database techniques—effective strategies for the agile software developer. Wiley, New York. ISBN 0471202835Google Scholar
  8. 8.
    Nootenboom Henk Jan: Nuts—a online column about software design.
  9. 9.
    Khodorkovsky VV (2002) On normalization of relations in databases. Progr Comput Softw 28 (1):4–52Google Scholar
  10. 10.
    Tari Z, Stokes J, Spaccapietra S (1997) Object normal forms and dependency constraints for object-oriented schemata. ACM Trans Database Syst 22(4):513–569Google Scholar
  11. 11.
    Ambler S (1997) Building object applications that work, your step-by-step hand-book for developing robust systems using object technology. Cambridge University Press/SIGS Books, New York. ISBN 0521-64826-2Google Scholar
  12. 12.
    Ambler S (2009) Object orientation § bringing Data professionals and application developers together. Accessed Jan 2009
  13. 13.
    Barry D (1996) The object database handbook: how to select, implement, and use object-oriented databases. Wiley, New York. ISBN 0471147184Google Scholar
  14. 14.
    Blaha M, Premerlani M (1998) Object-oriented modeling and design for database applications. Prentice Hall, Upper Saddle River. ISBN 0-13-123829-9Google Scholar
  15. 15.
    Catell RG (2000) The object data normal: ODMG 3.0. Morgan Kaufmann, San Mateo. ISBN 1558606475Google Scholar
  16. 16.
    Gemstone Object Server § documentation & non-commercial version download. Accessed Jan 2009
  17. 17.
    Yonghui W, Zhou A (2001) Research on normalization design for complex object schemes, info-tech and info-net. In: Proceedings of ICII, vol 5. Beijing, pp 101–106Google Scholar

Copyright information

© Springer Science+Business Media New York 2013

Authors and Affiliations

  1. 1.Department of Information Engineering, Faculty of Economics and ManagementCzech University of Life Sciences PraguePraha 6-SuchdolCzech Republic

Personalised recommendations