Partial rollback in object-oriented/object-relational database management systems

  • Authors:

  • Won-Young Kim;Kyu-Young Whang;Byung Suk Lee;Young-Koo Lee;Ji-Woong Chang

  • Affiliations:

  • Advanced Information Technology Research Center,(AITrc) Korea Advanced Institute of Science and Technology (KAIST), Daejeon, Korea;Advanced Information Technology Research Center,(AITrc) Korea Advanced Institute of Science and Technology (KAIST), Daejeon, Korea;Department of Computer Science, University of Vermont, Burlington, Vermont, USA;Advanced Information Technology Research Center,(AITrc) Korea Advanced Institute of Science and Technology (KAIST), Daejeon, Korea;Advanced Information Technology Research Center,(AITrc) Korea Advanced Institute of Science and Technology (KAIST), Daejeon, Korea

  • Venue:
  • Proceedings of the eleventh international conference on Information and knowledge management
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

In a database management system (DBMS), partial rollback is an important mechanism for canceling only part of the operations executed in a transaction back to a savepoint. Partial rollback complicates buffer management because it should restore the state of the buffers as well as that of the database. Several relational DBMSs (RDBMSs) currently provide this mechanism using page buffers. However, object-oriented or object-relational DBMSs (OO/ORDBMSs) cannot utilize the partial rollback scheme of RDBMSs as is because, unlike RDBMSs, many of them use a dual buffer consisting of an object buffer and a page buffer. In this paper, we propose a thorough study of partial rollback schemes of OO/ORDBMSs with a dual buffer. First, we classify the partial rollback schemes of OO/ORDBMSs into a single buffer-based scheme and a dual buffer-based scheme by the number of buffers used to process rollback. Next, we propose four alternative partial rollback schemes: a page buffer-based scheme, an object buffer-based scheme, a dual buffer-based scheme using a soft log, and a dual buffer-based scheme using shadows. We then evaluate their performance through simulations. The results show that the dual buffer-based partial rollback scheme using shadows provides the best performance. Partial rollback in OO/ORDBMS has not been addressed in the literature; yet, it is a useful mechanism that must be implemented. The proposed schemes are practical ones that can be implemented in such DBMSs.