Concurrency control protocols based on read-validation schemes allow transactions which are doomed to abort to still run until a subsequent validation check reveals them as invalid. These late aborts do not favor the reduction of wasted computation and can penalize performance. To counteract this problem, we present an analytical model that predicts the abort probability of transactions handled via read-validation schemes. Our goal is to determine what are the suited points-along a transaction lifetime-to carry out a validation check. This may lead to early aborting doomed transactions, thus saving CPU time. We show how to exploit the abort probability predictions returned by the model in combination with a threshold-based scheme to trigger read-validations. We also show how this approach can definitely improve performance-leading up to 14 % better turnaround-as demonstrated by some experiments carried out with a port of the TPC-C benchmark to Software Transactional Memory.

Economo, S., Silvestri, E., Di Sanzo, P., Pellegrini, A., Quaglia, F. (2018). Model-Based Proactive Read-Validation in Transaction Processing Systems. In 2018 IEEE 24th International Conference on Parallel and Distributed Systems (ICPADS) (pp.481-488). IEEE Computer Society [10.1109/PADSW.2018.8644605].

Model-Based Proactive Read-Validation in Transaction Processing Systems

Di Sanzo, Pierangelo;
2018-01-01

Abstract

Concurrency control protocols based on read-validation schemes allow transactions which are doomed to abort to still run until a subsequent validation check reveals them as invalid. These late aborts do not favor the reduction of wasted computation and can penalize performance. To counteract this problem, we present an analytical model that predicts the abort probability of transactions handled via read-validation schemes. Our goal is to determine what are the suited points-along a transaction lifetime-to carry out a validation check. This may lead to early aborting doomed transactions, thus saving CPU time. We show how to exploit the abort probability predictions returned by the model in combination with a threshold-based scheme to trigger read-validations. We also show how this approach can definitely improve performance-leading up to 14 % better turnaround-as demonstrated by some experiments carried out with a port of the TPC-C benchmark to Software Transactional Memory.
2018
9781538673089
Economo, S., Silvestri, E., Di Sanzo, P., Pellegrini, A., Quaglia, F. (2018). Model-Based Proactive Read-Validation in Transaction Processing Systems. In 2018 IEEE 24th International Conference on Parallel and Distributed Systems (ICPADS) (pp.481-488). IEEE Computer Society [10.1109/PADSW.2018.8644605].
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11590/428175
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 0
  • ???jsp.display-item.citation.isi??? 0
social impact