Abstract
Active databases couple database technology with rule-based programming and offer a natural way to develop applications in which the shared properties of data are centralised instead of being scattered among application programs. Unfortunately, designing, implementing and evolving applications based on the active database paradigm is still a very difficult task, mostly due to the poor understanding of the semantic issues underlying active rules. This paper provides a categorization of the dimensions of active database semantics and provides a uniform model to describe rules with different behaviours, capable of expressing the features of most commercial system and research prototypes.
Chapter PDF
Similar content being viewed by others
References
A. Aiken, J. Widom, and J.M. Hellerstein, “Behaviour of Database Production Rules: Termination, Confluence, and Observable Determinism”, Proc. ACM-SIGMOD Int. Conference, San Diego, May 1992.
Allbase Manuals, June 1992.
Anwar, E., Maugis, L. and Chakravarthy, S. (1993) “A New Perspective on Rule Support for Object-Oriented Databases”, Proc. ACM-SIGMOD Int. Conference, Washington DC, May 1993, 99–108.
Baralis, E., Ceri, S., Monteleone, G. and Paraboschi, S. (1994) “An Intelligent Database System Application: the Design of EMS”, Proc. ADB 84–International Conference on Applications of Databases, giugno 1994, Vadstena, Sweden, 172–89.
Beeri, C. and Milo, T. (1991) “A Model for Active Object Oriented Database”, Proc. 17th Int. Conference on Very Large Data Bases, Barcelona, September, 1991, 337–49.
Bonner, A.J. and Kifer. M. (1993) “Transaction Logic Programming”, University of Toronto, Tech. Rep. CSRI-270, revised July 1993.
Branding, H., Buchmann, A., Kudrass, T. and Zimmermann, J. (1993) “Rules in an Open System: The REACH Rule System”, Proc. of First Workshop on Rules in Database Systems, WICS, Edinburgh, Scotland, Aug. 1993, Springer-Verlag, Berlin, 40–57..
Brownston, L., Farrell, R., Kant, E. and Martin, N. (1985) “Programming Expert Systems in OPS5: An Introduction to Rule-Based Programming” Addison-Wesley, Reading, Massachusetts, 1985.
Cannan, S. and Otten, G. (1993) “SQL: The Standard Handbook”, McGraw-Hill, 1993.
Ceri, S., Fraternali, P. and Paraboschi, S. (1994) “Constraint Management in Chimera”, Bulletin of the Tech. Committee on Data Engineering, June 1994, Vol. 17, N. 2, 4–8.
Ceri, S., Fraternali, P., Paraboschi, S. and Tanca, L. (1994b) “Automatic generation of Produc-tion Rules for Integrity Maintenance”, ACM TODS, Vol. 19, No. 3, September 1994.
Ceri, S., Fraternali, P., Paraboschi, S. and Tanca, L. (1995) “Active Rule Management in Chimera”, in Widom and Ceri (1995).
Ceri, S., Fraternali, P., Paraboschi, S., and Widom, J. (1994d) “Active Database Systems”, Proc. PUC-Rio DB Workshop on New Database Research Challenges, Rio de Janeiro, September 1994, 35–56.
Ceri, S. and Manthey, R. (1993) “Consolidated Specification of Chimera”, ESPRIT Rep. IDEA.DE.2P.006.01, Nov. 1993.
Ceri, S. and Widom, J. (1990) “Deriving Production Rules for Constraint Maintenance”, Proc. 16th Int. Conference Very Large Data Bases, Brisbane, Aug. 1990.
Ceri, S. and Widom, J. (1990b) “Deriving Production Rules for Constraint Maintenance”, Technical Report, Politecnico di Milano, Dipartimento di Elettronica e Informazione, Laboratorio di Calcolatori, 1990.
Ceri, S. and Widom, J. (1991) “Deriving Production Rules for Incremental View Maintenance”, Proc. 17th Int. Conference Very Large Data Bases, Barcelona, Sept. 1991.
Chakravarthy, S., Anwar, E., Maugis, L. and Mishra, D. (1994) “Design of Sentinel: an object-oriented DBMS with event-based rules” Information and Software Technology, 1994 36, (9).
Chakravarthy, S., Blaustein, B., Buchmann, A.P., Carey, M., Dayal, U., Goldhirsch, D., Hsu, M., Jauhari, R., Ladin, R., Livni, M., McCarthy, D., McKee, R. and Rosenthal, A. (1989) “HiPAC: A Research Project in Active, Time-Constrained Database Management”, Tech. Rep. XAIT-89–02, Xerox Advanced Information Technology, July 1989.
Comai, S., Fraternali, P., Psaila, G. and Tanca, L. (1995) “Semantics of Active Databases”, Technical Report 014–95, Politecnico di Milano, Dipartimento di Elettronica e Informazione, Laboratorio di Calcolatori, 1995.
Delcambre, L.M.L. and Etheredge, J.N. (1988) “The relational production language: a production language for relational databases”, Proc. of the Second Int. Conf. on Expert Database Systems, pp 153–62.
Etzion, O. (1993) “Pardes- A Data-Driven Oriented Active Database Model”, SIGMOD RECORD, Vol. 22, No. 1, March 1993, 7–14.
Fraternali, P., Montesi, D. and Tanca, L. (1994) “Active Database Semantics”, Proc. ADC 94, Fifth Australasian Database Conference, University of Canterbury, New Zealand, 17–18th January, 1994.
Fraternali, P. and Tanca, L. (1993) “A Toolkit for the Design of Database Semantics”, Technical Report 078–93, Politecnico di Milano, Dipartimento di Elettronica e Informazione, Laboratorio di Calcolatori, 1993.
Gatziu, S., Geppert, A. and Dittrich, K.R. “Integrating Active Concepts into an Object-Oriented Database System”, Proc. DBPL91 Conf., 1991, pp. 341–57.
Gehani, N.H. and Jagadish, H.V. (1991) “Ode as an Active Database: Constraints and Triggers”, Proc. 17th Conference on Very Large Data Bases, Barcelona, September, 1991, pp. 327–36.
Gehani, N.H., Jagadish, H.V. and Shmueli, O. (1992) “Composite Event Specification in Active Databases: Model and Implementation”, Proc. 18th Conference on Very Large Data Bases, Vancouver, British Columbia, Canada, 1992, 327–38.
Gehani, N.H., Jagadish, H.V. and Shmueli, O. (1992b) “Event Specification in an Active Object-Oriented Database”, Proc. ACM SIGMOD Int. Conference, San Diego, May 1992, pp. 81–90
Gray, J. and Reuter, A. (1994) “Transaction processing: Concepts and Techniques”, Morgan-Kaufmann, San Mateo, California, 1994.
Hanson, E. (1992) “Rule Condition Testing and Action Execution in Ariel”, Proc. ACMSIGMOD Int. Conference, San Diego, May 1992.
Hanson, E. and Widom, J. (1992) “An Overview of Production Rules in Database Systems”, IBM RI 9023, October 1992, 83–119.
Kappel, G., Rausch-Schott, S. and Retschitzegger, W. (1994) “Beyond Coupling Modes: Implementing Active Concepts on Top of a Commercial ooDBMS”, manuscript, 1994
Informix Guide to SQL, Syntax, Version 6, March 1994, PartNo. 000–7597.
Informix Guide to SQL, Tutorial, Version 6, March 1994, PartNo. 000–7598.
Ingres Database Administrator’s Guide, Release 6.3, November 1990.
Interbase, DDL Reference Manual, 1990.
McCarthy, D. and Dayal, U. (1989) “The Architecture Of An Active Database System” Proc. ACM-SIGMOD Int. Conference, 1989.
ORACLE7 Server Concepts Manual, Part No 6693–70, December 1992.
ORACLE7 Server Application Developer’s Guide, Part No 6695–70, December 1992.
Palopoli, L and Torlone, R. (1994) “Modeling Database Applications Using Generalized Production Rules”, Proc. 4th International Workshop on Research Issues in Data Engineering: Active Database Systems (RIDE-ADS 84), Houston, Texas, February, 1994, 30–45.
Paton, N.W., Diaz, O., Williams, M.H., Campin, J., Dinn, A. and Jaime, A. (1993) “Dimensions of Active Behaviour”, Proc. of First Workshop on Rules in Database Systems, WICS, Edinburgh, Scotland, Aug. 1993, Springer-Verlag, Berlin, 40–57.
VAX Rdb/VMS SQL Reference Manual, Digital, November 1991.
SQL3 Document X3H2–94–080 and SOU–003, ISO–ANSI Working Draft, Database Language SQL, 1994.
Stonebraker, M., Jhingran, A., Goh, J. and Potamianos, S. (1990) “On Rules, Procedures, Caching, and Views in Data Base Systems”, Proc. ACM-SIGMOD Int. Conference, Atlantic City, June 1990, 281–90.
Stonebraker, M. (1992) “The Integration of Rule Systems and Database Systems”, IEEE Trans. on Knowledge an Data Engineering, Vol. 4, N. 5, Oct. 1992.
Tanca, L. (1991) “(Re)-action in deductive databases”, Proc.2nd Int. Workshop on Intelligent and Cooperative Information Systems, Como, Italy, Oct. 1991.
Transact-SQL User’s Guide for Sybase, Release 10.0.
Transact-SQL User’s Guide for Sybase, Release 4.8, April 1992.
Ullman„ J.D. (1982) “Principles of database systems”, Computer Science Press, Potomac, Maryland, 1982.
Urban, S.D., Karadimce, A.P. and Nannapaneni, R.B. (1992) “The Implementation and Evaluation of Integrity Maintenance Rules in an Object-Oriented Databas”, Proc. 8th Int. Conference on Data Engineering, Feb. 1992, Phoenix, Arizona, 565–72.
Widom, J. (1992) “A Denotational Semantics for the Starburst Production Rule Language”, SIGMOD Record, Vol 21, N. 3, Sept. 92, 4–9.
Widom, J. and Ceri, S. (1995) “Active Database Systems”, Eds., Morgan Kaufmann, San Mateo, California, to appear in August 1995.
Widom, J., Cochrane, R.J. and Lindsay, B.G. (1991) “Implementing Set-Oriented Production Rules as an Extension to Starburst”, Proc. 17th Int. Conference on Very Large Data Bases, Barcelona, Sept. 1991, 275–85.
Widom, J. and Finkelstein, S.J. (1990) “Set-oriented Production Rules in Relational Database Systems”, Proc. of ACM-SIGMOD, May 1990, 259–70.
Zaniolo, C. (1993) “A Unified Semantics for Deductive and Active Databases”, Proc. of the 1st Int. Workshop on Rules in Database Systems, Edinburgh, August 1993.
Zhou, Y. and Hsu, M. (1990) “A theory for rule triggering systems”, in Proc. of EDBT 80, LNCS 416, Springer-Verlag, Berlin, March 1990, 407–21
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1997 IFIP International Federation for Information Processing
About this chapter
Cite this chapter
Cornai, S., Fraternali, P., Psaila, G., Tanca, L. (1997). A Customizable Model for the Semantics of Active Databases. In: Meersman, R., Mark, L. (eds) Database Applications Semantics. IFIP Advances in Information and Communication Technology. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-34913-8_13
Download citation
DOI: https://doi.org/10.1007/978-0-387-34913-8_13
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-5041-2946-6
Online ISBN: 978-0-387-34913-8
eBook Packages: Springer Book Archive