Enforcement of integrity constraints against transactions with transition axioms

Sang Ho Lee, Lawrence Joseph Henschen, Myoung Ho Kim, Yoon Joon Lee

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Scopus citations

Abstract

This paper addresses an enforcement technique of integrity constraints against transaction updates in a relational database system. Transition axioms have been used effectively in checking integrity constraints for single update statements. In this paper we extend the idea of transition axioms to a transaction which is a sequence of read and update statements. Integrity constraints in our scheme are simplified without database access before the actual operations are performed, avoiding the need to undo an illegal transaction. We also propose transaction partitioning which can reduce the overhead of checking integrity constraints significantly. Partitioning a transaction becomes crucial when a transaction is associated with multiple integrity constraints.

Original languageEnglish (US)
Title of host publicationProceedings - COMPSAC 1992
Subtitle of host publication16th Annual International Computer Software and Applications Conference
PublisherIEEE Computer Society
Pages162-167
Number of pages6
ISBN (Electronic)0818630000
DOIs
StatePublished - Jan 1 1992
Event16th Annual International Computer Software and Applications Conference, COMPSAC 1992 - Chicago, United States
Duration: Sep 21 1992Sep 25 1992

Publication series

NameProceedings - International Computer Software and Applications Conference
ISSN (Print)0730-3157

Conference

Conference16th Annual International Computer Software and Applications Conference, COMPSAC 1992
Country/TerritoryUnited States
CityChicago
Period9/21/929/25/92

ASJC Scopus subject areas

  • Software
  • Computer Science Applications

Fingerprint

Dive into the research topics of 'Enforcement of integrity constraints against transactions with transition axioms'. Together they form a unique fingerprint.

Cite this