Preserving Semantics of the Whole-Part Relationships in the Object-Relational Databases

  • Erki Eessaar

A conceptual data model that is created for example in UML (OMG 2003) can contain aggregation and composition relationships between entity types. This article describes how to preserve the semantics of this kind of relationships in a database that is created by an Object-Relational Database Management System, which implements the prescriptions, proscriptions and suggestions of The Third Manifesto (Date and Darwen 2000).


Cardinality Constraint Secondary Characteristic Attribute Part Shareable Part Composition Relationship 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. Alphora. Dataphor 2.0 Retrieved April 08, 2006 from asp?ID=DATAPHOR2
  2. Barbier F, Henderson-Sellers B, Le Parc-Lacayrelle A, Bruel J (2003) Formaliza-tion of the Whole-Part Relationship in the Unified Modeling Language. IEEE Trans. Softw. Eng. 29(5):459-470CrossRefGoogle Scholar
  3. Codd EF (1970) A relational model of large shared data banks. Comm. ACM 13(6):377-387zbMATHCrossRefGoogle Scholar
  4. Date CJ, McGoveran D (1994) The Principle of Orthogonal Design. Database Programming & Design 7, No. 6 (June 1994)Google Scholar
  5. Date CJ, Darwen H (2000) Foundation for Future Database Systems: The Third Manifesto, 2nd edn. Addison-WesleyGoogle Scholar
  6. Date CJ (2003) An Introduction to Database Systems. 8th edn. Pearson/Addison Wesley, BostonzbMATHGoogle Scholar
  7. Guizzardi G (2005) Ontological Foundations for Structural Conceptual Models. Telematica Instituut Fundamental Research Series No. 15. Ph.D. thesis, University of TwenteGoogle Scholar
  8. Gulutzan P, Pelzer T (1999) SQL-99 Complete, Really. Miller Freeman, USAGoogle Scholar
  9. Marcos E, Vela B, Cavero JM, Caceres P (2001) Aggregation and composition in object-relational database design. In: Caplinskas A, Eder J (eds) Research Communications of ADBIS’01(1). pp 195-209Google Scholar
  10. Melton J (2005) ISO/IEC 9075-2:2003 (E) Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation). August, 2003. Retrieved December 26, 2004, from Standards.html
  11. Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01. Oracle Corp., Retrieved October 4, 2005, from com/docs/cd/B14117_01/server.101/b10759/toc.htm
  12. Pardede E, Rahayu JW, Taniar D (2004) Mapping Methods and Query for Aggre-gation and Association in Object-Relational Database using Collection. In Proc. of the ITCC(1)’2004. IEEE Computer Society, pp 539-543Google Scholar
  13. Pascal F (2000) Practical issues in Database Management. A Reference for the Thinking Practioner, Addison-Wesley. Boston, Mass, 1st editionGoogle Scholar
  14. Rahayu W, Chang E, Dillon TS (1998) Implementation of Object-Oriented Asso-ciation Relationships in Relational Databases. In: Eaglestone B, Desai BC, Shao J (eds) Proc. of the IDEAS’1998. IEEE Computer Society, pp 254-263Google Scholar
  15. Soutou C (2001) Modeling relationships in object-relational databases. Data and Knowledge Engineering 36(1):79-107zbMATHCrossRefGoogle Scholar
  16. OMG Unified Modeling Language Specification. March 2003. Version 1.5. for-mal/03-03-01Google Scholar
  17. Voorish D (2006) An Implementation of Date and Darwen’s “TutorialD” (26.03.2006)
  18. Võhandu L, Kuusik R, Torim A, Aab E, Lind G (2006) Some Monotone Systems Algorithms for Data Mining, WSEAS Transactions on Information Science & Applications 3(4):802-809Google Scholar
  19. Zhang N, Ritter N, Härder T (2001) Enriched Relationship Processing in Object-Relational Database Management Systems. In: Lu H, Spaccapietra S (eds) Proc. of the CODAS’01. IEEE Computer Society, pp 53-62Google Scholar

Copyright information

© Springer Science+Business Media, LLC 2007

Authors and Affiliations

  • Erki Eessaar
    • 1
  1. 1.Department of InformaticsTallinn University of TechnologyEstonia

Personalised recommendations