On Finding Suitable Designs for Whole-Part Relationships in Object-Relational Databases

  • Erki Eessaar


Whole-part relationships have secondary characteristics, the values of which determine the nature of a relationship. This chapter presents an approach that allows database designers to find a set of suitable designs for implementing a whole—part relationship in a database. This approach takes into account values of the secondary characteristics of relationships. These values determine a set of structural and behavioral constraints that must be implemented in a database. Different designs use different means for implementing these constraints. The proposed approach can be used in the context of any data model or database system. However, in this chapter we consider the underlying object-relational data model of SQL:2003.


Database Design Cardinality Constraint Suitable Design Secondary Characteristic Base Table 
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.


  1. Barbier, F., Henderson-Sellers, B., Le Parc-Lacayrelle, A. and Bruel, J. (2003) Formalization of the Whole-Part Relationship in the Unified Modeling Language. IEEE Trans. Software Eng. 29(5), 459–470.CrossRefGoogle Scholar
  2. Blaha, M.R., Premerlani, W.J. and Rumbaugh, J.E. (1988) Relational database design using an object-oriented methodology. Comm. of the ACM. 31(4), Apr., 414–427.CrossRefGoogle Scholar
  3. Date, C.J. (1984) Some principles of good language design: with especial reference to the design of database languages. SIGMOD Rec. 14(3), Nov, 1–7.CrossRefGoogle Scholar
  4. Date, C. J. (2003) An Introduction to Database Systems. 8th ed. Pearson/Addison-Wesley, Boston.MATHGoogle Scholar
  5. Date, C. J. (2006) Date on Database: Writings 2000–2006. Apress, Berkeley, CA.Google Scholar
  6. Date, C. J. and Darwen, H. (2006) Databases, Types and the Relational Model. 3rd edn. Addison-Wesley, Reading, MA.Google Scholar
  7. Guizzardi, G. (2005) Ontological Foundations for Structural Conceptual Models. Telematica Instituut Fundamental Research Series No. 15. Ph.D. thesis, University of Twente.Google Scholar
  8. Halpin, T. (2000) Modeling Collection in UML and ORM. In Proc. 5′h IFlP WG8.1 Int. Workshop on Evaluation of Modeling Method in System Analysis and Design, Kista, Sweden (June).Google Scholar
  9. Lindland, O.I., Sindre, G. and Solvberg, A. (1994) Understanding quality in conceptual modeling. IEEE Software 11(2), 42–49.CrossRefGoogle Scholar
  10. Marcos, E., Vela, B., Cavero, J. M. and 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.Google Scholar
  11. Melton, J. (2003) ISO/IEC 9075-2:2003 (E) Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation),
  12. Mok, W. Y. (2002) A comparative study of various nested normal forms. IEEE Trans. Knowledge Data Eng. 14(2), 369–385.MathSciNetCrossRefGoogle Scholar
  13. Muller, R. J. (1999) Database Design for Smarties: Using UML for Data Modeling. Morgan Kaufmann Publishers, San Francisco.Google Scholar
  14. Oracle® Database SQL (2007) Reference 10g Release 1 (10.1) Part Number B10759-01. Oracle Corp.,
  15. Pardede, E., Rahayu, J. W. and Taniar, D. (2004) Mapping Methods and Query for Aggregation and Association in Object-Relational Database using Collection. In Proc. of the ITCC(1)′2004. IEEE Computer Society, pp. 539–543.Google Scholar
  16. Pardede, E., Rahayu, J. W. and Taniar, D. (2005) Composition in Object-Relational Database. Encyclopedia of Information Science and Technology. IDEA Publishing, pp. 488–494.Google Scholar
  17. Piattini, M., Calero, C., Sahraoui, H. and Lounis, H. (2001) Object-Relational Database Metrics. L′Object, vol. March 2001.Google Scholar
  18. Smith, J. and Smith, D. (1977) Database abstractions: aggregation. Comm. ACM. 20(6), 405–413.CrossRefGoogle Scholar
  19. Soutou, C. (2001) Modeling relationships in object-relational databases. Data Knowledge Eng. 36(1), 79–107.MATHCrossRefGoogle Scholar
  20. Türker, C. and Gertz, M. (2001) Semantic integrity support in SQL:1999 and commercial (object-) relational database management systems. VLDB J. 10(4), 241–269.MATHCrossRefGoogle Scholar
  21. Zhang, N., Ritter, N. and Härder, T. (2001) Enriched Relationship Processing in Object-Relational Database Management Systems. In Proc. of the Third International Symposium on Cooperative Database Systems for Advanced Applications, pp. 50–59.Google Scholar

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • Erki Eessaar

There are no affiliations available

Personalised recommendations