Programming and Computer Software

, Volume 26, Issue 4, pp 207–215 | Cite as

Implementing associations among classes in an environment of active databases



The association is a native concept from relational databases, one that has been adapted to object oriented (OO) modelling. It is an interesting operator used to describe links among objects of a system, commonly included in the most popular diagram-based OO methodologies. However, those methodologies sometimes present a lack of formality that may undermine its use. In this paper we formalize the semantics of associations. Firstly, we will describe an OO model based on different kinds of constraints. Some of them will be especially useful for describing the semantics of associations. Finally, we will present some remarks about implementation by means of triggers, a new feature incorporated in databases to specify an inner active behavior.


Active Rule Local View Active Database Abstract Data Type Associate Class 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Aiken, A., Widom, J., and Hellerstein, J.M., Behaviour of Database Production Rules: Termination, Confluence, and Observable Determinism,Proc. ACM SIGMOD Int. Conf. on Management of Data, 1992, pp. 59–68.Google Scholar
  2. 2.
    Bock, C. and Odell, J., A more Complete Model of Relations and Their Implementation.J. Object-Oriented Programming, 1997, June, pp. 38–47.Google Scholar
  3. 3.
    Booch, G., Jacobson, I., and Rumbaugh, J.,The Unified Modeling Language User Guide, Addison-Wesley, 1999.Google Scholar
  4. 4.
    Bourdeau, R.H. and Cheng, B.H.C., A Formal Semantic for Object Model Diagrams,IEEE Trans. Software Eng., 1995, October.Google Scholar
  5. 5.
    Ceri, S. and Fraternali, P.,Designing Database Applications with Object Rules, Addison-Wesley, 1997.Google Scholar
  6. 6.
    Dittrich, K., Gatziu, S., and Geppert, A., The Active Database Management System Manifesto: A Rulebase of a ADBMS Features,J. SIGMOD Record, 1996, vol. 25, no. 3, pp. 40–49.CrossRefGoogle Scholar
  7. 7.
    Ehlmann, B.K. and Riccardi, G.A., An Integrated and Enhanced Methodology for Modeling and Implementing Object Relationships,J. Object-Oriented Programming, 1997, May, pp. 47–55.Google Scholar
  8. 8.
    Graham, I., Bischof, J., and Henderson-Sellers, B., Associations Considered a Bad Thing,J. Object-Oriented Programming, 1997, February, pp. 41–48.Google Scholar
  9. 9.
    Hammond, J., Producing Z Specifications from Object-Oriented Analysis, inZ User Workshop 1994. Workshops in Computing, Nicholls, J.E., Ed., Springer, 1995, pp. 316–336.Google Scholar
  10. 10.
    ISO-ANSI. Database Language SQL3, working draft, 1994.Google Scholar
  11. 11.
    Khoshafian, S.N. and Copeland, C.P., Object Identity,Object-Oriented Programming Systems, Languages and Applications, SIGPLAN Notices, 1986, vol. 22, no. 12, pp. 406–416.CrossRefGoogle Scholar
  12. 12.
    Lano, K.,Formal Object-Oriented Development, Springer, 1995.Google Scholar
  13. 13.
    PL/SQL User's Guide and Reference, Release 8.0, Oracle Corporation, 1997.Google Scholar
  14. 14.
    Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F., and Lorensen, W.,Object-Oriented Modelling and Design, Prentice Hall, 1991.Google Scholar
  15. 15.
    Shlaer, S. and Mellor, S.,Object Lifecycles: Modelling the World in States, Yourdon Press Computing Series, 1992.Google Scholar
  16. 16.
    Torres, J., Troyano, J.A., and Toro, M., Operators of Association and Aggregation in an Object Oriented Specification Language,II Workshop on Computer Science, Granada (Spain), 1996, pp. 11–21.Google Scholar
  17. 17.
    Torres, J., Object Oriented Specifications Based on Constraints,PhD Thesis, Department of Languages and Computer Systems, University of Seville, 1997.Google Scholar
  18. 18.
    Widom, J. and Ceri, S.,Active Database Systems: Triggers and Rules for Advanced Dababase Processing, San Francisco: Kaufmann, 1996.Google Scholar

Copyright information

© MAIK “Nauka/Interperiodica” 2000

Authors and Affiliations

  1. 1.Department of Languages and Computer SystemsUniversity of SevilleSpain

Personalised recommendations