Abstract
The complexity of modern database applications requires powerful integrity maintenance facilities in the context of transaction processing. This paper proposes a mechanism for integrity constraint handling based on transaction modification. This mechanism conforms to the complete transaction model, complying with transaction atomicity and serializability. Further, the technique can be integrated into the normal query processing strategy of a relational DBMS, and can thus easily be applied in a real world system; this is shown for the PRISMA parallel database system. Transaction modification is fit for handling a large class of constraints and provides a high degree of flexibility and extensibility.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
S. Ceri, J. Widom; Deriving Production Rules for Constraint Maintenance; Proc. 16th VLDB Conference; Brisbane, Australia, 1990.
P.W.P.J. Grefen, P.M.G. Apers; Parallel Handling of Integrity Constraints on Fragmented Relations; Proc. International Symposium on Databases in Parallel and Distributed Systems; Dublin, Ireland, 1990.
P.W.P.J. Grefen, J. Flokstra, P.M.G. Apers; Parallel Handling of Integrity Constraints; Proc. Workshop on Parallel Database Systems; Noordwijk, The Netherlands, 1990.
Gr90c] P.W.P.J. Grefen; Integrity Constraint Enforcement through Transaction Modification; Memorandum INF90–60; University of Twente, 1990.
J.M. Nicolas; Logic for Improving Integrity Checking in Rela- tional Data Bases; Acta Informatica Vol. 18, 1982.
E. Simon, P. Valduriez; Design and Implementation of an Extendible Integrity Subsystem; Proc. 1984 SIGMOD Conference; Boston, USA, 1984.
E. Simon, P. Valduriez; Design and Analysis of a RelationalIntegrity Subsystem; MCC Technical Report Number DB-01587; MCC, Austin, USA, 1987.
M. Stonebraker; Implementation of Integrity Constraints and Views by Query Modification; Proc. 1975 SIGMOD Conference; San Jose, USA, 1975.
A.N. Wilschut, P.W.P.J. Grefen, P.M.G. Apers, M.L. Kersten; Implementing PRISMA/DB in an OOPL; Proc. 6th International Workshop on Database Machines; Deauville, France, 1989.
M.M. Zloof; Security and Integrity within the Query-by-Example Database Management Language; IBM RC 6982; Yorktown Hts., USA, 1978.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1991 Springer-Verlag Wien
About this paper
Cite this paper
Grefen, P.W.P.J., Apers, P.M.G. (1991). Integrity Constraint Enforcement through Transaction Modification. In: Karagiannis, D. (eds) Database and Expert Systems Applications. Springer, Vienna. https://doi.org/10.1007/978-3-7091-7555-2_61
Download citation
DOI: https://doi.org/10.1007/978-3-7091-7555-2_61
Publisher Name: Springer, Vienna
Print ISBN: 978-3-211-82301-9
Online ISBN: 978-3-7091-7555-2
eBook Packages: Springer Book Archive