A Design and Implementation of Savepoints and Partial Rollbacks Considering Transaction Isolation Levels of SQL2.

Sun Hwan Kim, Mi Suk Jung, Jun Hyun Park, Young Chul Park: A Design and Implementation of Savepoints and Partial Rollbacks Considering Transaction Isolation Levels of SQL2. DASFAA 1999: 303-312
  author    = {Sun Hwan Kim and
               Mi Suk Jung and
               Jun Hyun Park and
               Young Chul Park},
  editor    = {Arbee L. P. Chen and
               Frederick H. Lochovsky},
  title     = {A Design and Implementation of Savepoints and Partial Rollbacks
               Considering Transaction Isolation Levels of SQL2},
  booktitle = {Database Systems for Advanced Applications, Proceedings of the
               Sixth International Conference on Database Systems for Advanced
               Applications (DASFAA), April 19-21, Hsinchu, Taiwan},
  publisher = {IEEE Computer Society},
  year      = {1999},
  isbn      = {0-7695-0084-6},
  pages     = {303-312},
  ee        = {db/conf/dasfaa/KimJPP99.html},
  crossref  = {DBLP:conf/dasfaa/99},
  bibsource = {DBLP,}


A partial rollback of a transaction restores the state of the transaction and the database to the state in which they have been right after the savepoint to be rolled back has been established. Contributions of this paper toward the correctness of savepoints and partial rollbacks are the followings.

First, a savepoint sequence number is assigned to each savepoint. According to that, without generating any savepoint log record upon establishing savepoints, all the valid savepoints of a transaction can have different savepoint sequence numbers and the order of establishment of each valid savepoint can be discriminated efficiently.

Second, the lock request entries of the manual duration are not deleted from the lock table as far as some savepoints which are established after the locks are requested but before the locks are released are valid. That guarantees the correctness of savepoints and partial rollbacks under the circumstances of supporting the four transaction isolation levels of SQL2.

Third, the concept of the mini-savepoint that preserves the atomicity of update operations of the SQL level is extended and adopted to triggers and stored procedures. According to that, the atomicity of triggers and stored procedures is supported and the scope of savepoint names is restricted to the internal of the corresponding triggers or stored procedures.

Copyright © 1999 by The Institute of Electrical and Electronic Engineers, Inc. (IEEE). Abstract used with permission.


CDROM Version: Load the CDROM "DiSC, Volume 2 Number 1" and ...

ACM SIGMOD Anthology

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Online Edition: IEEE Computer Society Digital Library

Citation Page


Andrew Eisenberg: New Standard for Stored Procedures in SQL. SIGMOD Record 25(4): 81-88(1996) BibTeX
Piero Fraternali, Letizia Tanca: A Structured Approach for the Definition of the Semantics of Active Databases. ACM Trans. Database Syst. 20(4): 414-471(1995) BibTeX
Jorge F. Garza, Won Kim: Transaction Management in an Object-Oriented Database System (Invited Paper). SIGMOD Conference 1988: 37-45 BibTeX
Jim Gray, Andreas Reuter: Transaction Processing: Concepts and Techniques. Morgan Kaufmann 1993, ISBN 1-55860-190-2
Contents BibTeX
Jim Melton, Alan R. Simon: Understanding the New SQL: A Complete Guide. Morgan Kaufmann 1993, ISBN 1-55860-245-3
Contents BibTeX
C. Mohan, Donald J. Haderle, Bruce G. Lindsay, Hamid Pirahesh, Peter M. Schwarz: ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging. ACM Trans. Database Syst. 17(1): 94-162(1992) BibTeX
C. Mohan, Frank E. Levine: ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging. SIGMOD Conference 1992: 371-380 BibTeX
Young Chul Park, Peter Scheuermann, Sang Ho Lee: A Periodic Deadlock Detection and Resolution Algorithm with a New Graph Model for Sequential Transaction Processing. ICDE 1992: 202-209 BibTeX
Young Chul Park, Dae Young Huh: Mini-Savepoints: Firewalls for Atomic Updates. DASFAA 1997: 293-302 BibTeX
Jeff Richey: Condition Handling in SQL Persistent Stored Modules. SIGMOD Record 24(3): 98-103(1995) BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
DASFAA 1999 Proceedings: Copyright © by IEEE,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:05:39 2009