Supporting Partial Isolation in Flat Transaction

  • Authors:
  • Randi Karlsen

  • Affiliations:
  • -

  • Venue:
  • DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper describes a new adaptable correctness criterion, called ACCtr, that allows correctness requirements to be attached to each individual transaction. Correctness requirements may vary both between transactions and within a single transaction. ACCtr allows partial isolation, where isolation may be required for some parts of a transaction T, while interleaving is allowed for other parts of T. To support ACCtr, we describe a concurrency control mechanism, called Two-dimensional locking. Through early release of locks, Two-dimensional locking allows controlled access to a partially updated database. This is offered as a new type of isolation level which is available for both read and update transactions. The paper briefly considers the recovery mechanism needed to support Two-dimensional locking. Here we suggest using a combination of compensation and rollback to undo flat transactions.