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).
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Alphora. Dataphor 2.0 Retrieved April 08, 2006 from http://alphora.com./tiern. asp?ID=DATAPHOR2
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-470
Codd EF (1970) A relational model of large shared data banks. Comm. ACM 13(6):377-387
Date CJ, McGoveran D (1994) The Principle of Orthogonal Design. Database Programming & Design 7, No. 6 (June 1994)
Date CJ, Darwen H (2000) Foundation for Future Database Systems: The Third Manifesto, 2nd edn. Addison-Wesley
Date CJ (2003) An Introduction to Database Systems. 8th edn. Pearson/Addison Wesley, Boston
Guizzardi G (2005) Ontological Foundations for Structural Conceptual Models. Telematica Instituut Fundamental Research Series No. 15. Ph.D. thesis, University of Twente
Gulutzan P, Pelzer T (1999) SQL-99 Complete, Really. Miller Freeman, USA
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-209
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 http://www.wiscorp.com/SQL Standards.html
Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01. Oracle Corp., Retrieved October 4, 2005, from http://download-west.oracle. com/docs/cd/B14117_01/server.101/b10759/toc.htm
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-543
Pascal F (2000) Practical issues in Database Management. A Reference for the Thinking Practioner, Addison-Wesley. Boston, Mass, 1st edition
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-263
Soutou C (2001) Modeling relationships in object-relational databases. Data and Knowledge Engineering 36(1):79-107
OMG Unified Modeling Language Specification. March 2003. Version 1.5. for-mal/03-03-01
Voorish D (2006) An Implementation of Date and Darwen’s “TutorialD” http://dbappbuilder.sourceforge.net/Rel.html (26.03.2006)
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-809
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-62
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2007 Springer Science+Business Media, LLC
About this paper
Cite this paper
Eessaar, E. (2007). Preserving Semantics of the Whole-Part Relationships in the Object-Relational Databases. In: Wojtkowski, W., Wojtkowski, W.G., Zupancic, J., Magyar, G., Knapp, G. (eds) Advances in Information Systems Development. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-70802-7_1
Download citation
DOI: https://doi.org/10.1007/978-0-387-70802-7_1
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-70801-0
Online ISBN: 978-0-387-70802-7
eBook Packages: Computer ScienceComputer Science (R0)