| | This Article | |
| |
| |
| | Share | |
| |
| |
| | Bibliographic References | |
| |
| |
| | Add to: | |
| |
 Digg
 Furl
 Spurl
 Blink
 Simpy
 Google
 Del.icio.us
 Y!MyWeb
| |
| | Search | |
| |
| |
| | |
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] 170 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:/www.odi.com, 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.
Citation:
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
