Transaction Chopping: Algorithms and Performances Studies - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Reports (Research Report) Year : 1995

Transaction Chopping: Algorithms and Performances Studies

Dennis Shasha
  • Function : Author
  • PersonId : 833427
Eric Simon
  • Function : Author
Patrick Valduriez


Chopping transactions into pieces is good for performance but may lead to non-serializable executions. Many researchers have reacted to this fact by either inventing new concurrency control mechanisms, weakening serializability, or both. We adopt a different approach. We assume a user who has access only to user-level tools such as (i) choosing between degree 2 and degree 3 isolation levels (degree 2 corresponds to level 1 in the new ANSI SQL terminology) (ii) the ability to execute a portion of a transaction using multiversion read consistency, and (iii) the ability to reorder the instructions in transaction programs; and knows the set of transactions that may run during a certain interval (users are likely to have such knowledge for online or real-time transactional applications). Given this information, our algorithm finds the finest partitioning of a set of transactions TranSet with the following property: {\em if the partitioned transactions execute serializably, then TranSet executes serializably.} This permits users to obtain more concurrency while preserving correctness. Besides obtaining more inter-transaction concurrency, chopping transactions in this way can enhance intra-transaction parallelism. The algorithm is inexpensive, running in O($n \times (e + m)$) time, once conflicts are identified, using a naive implementation where $n$ is the number of concurrent transactions in the interval, $e$ is the number of edges in the conflict graph among the transactions, and $m$ is the maximum number of accesses of any transaction. This makes it feasible to add as a tuning knob to real systems.


Other [cs.OH]
Fichier principal
Vignette du fichier
RR-2531.pdf (498.87 Ko) Télécharger le fichier

Dates and versions

inria-00074147 , version 1 (24-05-2006)


  • HAL Id : inria-00074147 , version 1


François Llirbat, Dennis Shasha, Eric Simon, Patrick Valduriez. Transaction Chopping: Algorithms and Performances Studies. [Research Report] RR-2531, INRIA. 1995. ⟨inria-00074147⟩
159 View
1114 Download


Gmail Facebook Twitter LinkedIn More