This Article 
 Bibliographic References 
 Add to: 
Extending the ODMG Object Model with Triggers
February 2004 (vol. 16 no. 2)
pp. 170-188

Abstract—In this paper, we extend the standard for object-oriented databases, ODMG, with reactive features, by proposing a language for specifying triggers and defining its semantics. This extension has several implications, thus this work makes three different specific contributions. First, the definition of a declarative data manipulation language for ODMG, which is missing in the current version of the standard; such a definition requires revisiting data manipulation in ODMG and also addressing issues related to set-oriented versus instance-oriented computation. Then, the definition of a trigger language for ODMG, unifying also the SQL:1999 proposal and providing support for trigger inheritance and overriding. Finally, the development of a formal semantics for the proposed data manipulation and trigger languages.

[1] S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases. Addison-Wesley, 1995.
[2] M. Andries, L. Cabibbo, J. Paredaens, and J. van den Bussche, Applying an Update Method to a Set of Receivers Proc. 14th ACM SIGACT-SIGMOD-SIGART Symp. Principles of Database Systems, pp. 208-218, 1995.
[3] D. Barry and J. Duhl, Object Storage Fact Book 5.0 Object DBMSs. Barry&Assoc., Inc., 2001.
[4] C. Beeri and T. Milo, A Model for Active Object Oriented Database Proc. 17th Int'l Conf. Very Large Data Bases, G.M. Lohman, A. Sernadas, and R. Camps, eds., pp. 337-349, 1991.
[5] E. Bertino, M. Cochinwala, and M. Mesiti, UCS-Router: A Policy Engine for Enforcing Message Routing Rules in a Universal Communication System Proc. Third IEEE Int'l Conf. Mobile Data Management, 2002.
[6] E. Bertino, G. Guerrini, and I. Merlo, Formalizing the ODMG Object Model Technical Report DISI-TR-99-04, Dipartimento di Informatica e Scienze dell'Informazione, Universitàdi Ge nova, 1999.
[7] E. Bertino, G. Guerrini, and I. Merlo, Trigger Inheritance and Overriding in Active Object Database Systems IEEE Trans. Knowledge and Data Eng., vol. 12, no. 4, pp. 588-608, 2000.
[8] E. Bertino, G. Guerrini, and I. Merlo, A Set-Oriented Method Definition Language for Object Databases and Its Semantics Concurrency and Computation: Practice and Experience, 2003.
[9] E. Bertino and W. Kim, “Indexing Technique for Queries on Nested Objects,” IEEE Trans. Knowledge and Data Eng., vol. 1, no. 2, pp. 196-214, 1989.
[10] M. Carey, D. Chamberlin, S. Narayanan, B. Vance, D. Doole, S. Rielau, R. Swagerman, and N. Mattos, O-O, What's Happening to DB2? Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 511-512, 1999.
[11] R. Cattel, D. Barry, M. Berler, J. Eastman, D. Jordan, C. Russel, O. Schadow, T. Stanienda, and F. Velez, The Object Database Standard: ODMG 3.0. Morgan-Kaufmann, 1999.
[12] S. Ceri, P. Fraternali, S. Paraboschi, and L. Tanca, Active Rule Management in Chimera Active Database Systems, S. Ceri and J. Widom, eds., Morgan-Kaufmann, 1996.
[13] S. Ceri and J. Widom, Active Database Systems. Morgan-Kaufmann, 1996.
[14] D. Chamberlin, Using the New DB2 IBM's Object-Relational Database System, Morgan-Kaufmann, 1996.
[15] S. Cluet, Designing OQL: Allowing Objects to be Queried Information Systems, vol. 23, no. 5, pp. 279-305, 1998.
[16] C. Collet, T. Coupaye, and T. Svensen, Naos: Efficient and Modular Reactive Capabilities in an Object-Oriented Database System Proc. 20th Int'l Conf. Very Large Data Bases, pp. 132-143, 1994.
[17] Object Design, ObjectStore Java API User Guide (ObjectStore 6.0). Available athttp:/, 1998.
[18] Object Design, An XML Data Server for Building Enterprise Web Applications. White paper, 1999.
[19] P. Fraternali and L. Tanca, A Structured Approach for the Definition of the Semantics of Active Databases ACM Trans. Database Systems, vol. 20, no. 4, pp. 414-471, 1995.
[20] S. Gatziu and K. Dittrich, SAMOS: An Active Object-Oriented Database System IEEE Data Eng. Bull., special issue on active databases, vol. 15, no. 4, pp. 23-26, 1992.
[21] N. Gehani and H. Jagadish, Ode as an Active Database: Constraints and Triggers Proc. 17th Int'l Conf. Very Large Data Bases, pp. 327-336, 1991.
[22] P. Gulutzan and T. Pelzer, SQL-99 Complete, Really. Miller Freeman, 1999.
[23] Informix-Universal Server: Informix Guide to SQL: Syntax. Version 9.1. Menlo Park, Calif.: Informix Software Inc., 1997.
[24] Ingres Database Administrator's Guide. Ingres Corp., Version II, 1999.
[25] G. Kappel, S. Rausch-Schott, and W. Retschitzegger, Beyond Coupling Modes: Implementing Active Concepts on Top of a Commercial ooDBMS Proc. Int'l Symp. Object-Oriented Methodologies and Systems, E. Bertino and S. Urban, eds., 1994.
[26] C. Laasch and M.H. Scholl, Deterministic Semantics of Set-Oriented Update Sequences Proc. Ninth IEEE Int'l Conf. Data Eng., 1993.
[27] D. McCarthy and U. Dayal, The Architecture of an Active Data Base Management System Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 215-223, 1989.
[28] C. Medeiros and P. Pfeffer, Object Integrity Using Rules Proc. Fifth European Conf. Object-Oriented Programming, P. America, ed., pp. 219-230, 1991.
[29] J. Melton and A.R. Simon, SQL:1999 Understanding Relational Language Components. Morgan-Kaufmann, 2001.
[30] I. Merlo, Extending the ODMG Object Model with Temporal and Active Capabilities PhD thesis, Universitàdi Ge nova, 2001.
[31] Microsoft SQL Server. Microsoft Corp., Version 7.0, 1999.
[32] Oracle9i SQL Reference, Release 9.2, Oracle Corp. 2002.
[33] N. Paton, Active Rules in Database Systems. Springer-Verlag, 1999.
[34] W. Paton, J. Campin, A.A.A. Fernandes, M. Howard Williams, Formal Specification of Active Database Functionality: A Survey Rules in Database Systems, Proc. Second Int'l Workshop RIDS '95, T. Sellis, ed., pp. 21-35, 1995.
[35] POET Java Programmer's Guide (POET 6.0), POET Software. 1999.
[36] Transact-SQL User's Guide for Sybase. Release 10.0, Berkley, Calif.: SYBASE Inc., 1994.
[37] J.D. Ullman and J. Widom, A First Course in Database Systems. Prentice Hall, 1997.
[38] J. Widom, A Denotational Semantics for the Starbust Production Rule Language SIGMOD Record, vol. 21, no. 3, pp. 4-9, Sept. 1992.

Index Terms:
Triggers, active databases, object-oriented DBMSs, ODMG, ODL.
Elisa Bertino, Giovanna Guerrini, Isabella Merlo, "Extending the ODMG Object Model with Triggers," IEEE Transactions on Knowledge and Data Engineering, vol. 16, no. 2, pp. 170-188, Feb. 2004, doi:10.1109/TKDE.2004.1269596
Usage of this product signifies your acceptance of the Terms of Use.