Abstract
Many commercial relational database systems provide support for active rules, which are generally referred to as triggers. However, these facilities have been developed independently by different vendors, and triggers developed for one system generally do not work with another. This chapter describes how triggers are supported in the SQL3 standard, and in particular how the triggers relate to other features of the standard.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Roberta Cochrane and Hamid Pirahesh anhd Nelson Mattos. Integrating Triggers and Declarative Constraints in SQL Database Systems. In Proc. 22th VLDB Conference, Mumbai, India, 1996.
Stefano Ceri and Jennifer Widom. Standards and Commercial Systems. In S. Ceri J. Widom and U. Dayal (eds), editors, Active Database Systems: Triggers and Rules for Advanced Database Processing. Morgan Kaufman, 1995.
Bruce Horowitz. Intermediate States as a Source of Non-deterministic Behavior of Triggers. In Proc. 4th Int. Workshop on Research Issues in Data Engineering: Active Database Systems, 1994.
Database Language SQL. ISO/IEC 9075:1992, 1992.
Working draft: Database Language SQL (SQL3). ISO/IEC DBL MAD-007, June 1996.
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer Science+Business Media New York
About this chapter
Cite this chapter
Kulkarni, K., Mattos, N., Cochrane, R. (1999). Active Database Features in SQL3. In: Paton, N.W. (eds) Active Rules in Database Systems. Monographs in Computer Science. Springer, New York, NY. https://doi.org/10.1007/978-1-4419-8656-6_10
Download citation
DOI: https://doi.org/10.1007/978-1-4419-8656-6_10
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4612-6448-4
Online ISBN: 978-1-4419-8656-6
eBook Packages: Springer Book Archive