An empirical study of transaction throughput thrashing across multiple relational DBMSes

Young Kyoon Suh, Richard Thomas Snodgrass, Sabah Currim

Research output: Contribution to journalArticle

3 Scopus citations

Abstract

Modern DBMSes are designed to support many transactions running simultaneously. DBMS thrashing is indicated by the existence of a sharp drop in transaction throughput. Thrashing behavior in DBMSes is a serious concern to database administrators (DBAs) as well as to DBMS implementers. From an engineering perspective, therefore, it is of critical importance to understand the causal factors of DBMS thrashing. However, understanding the origin of thrashing in modern DBMSes is challenging, due to many factors that may interact with each other.This article aims to better understand the thrashing phenomenon across multiple DBMSes. We identify some of the underlying causes of DBMS thrashing. We then propose a novel structural causal model to explicate the relationships between various factors contributing to DBMS thrashing. Our model derives a number of specific hypotheses to be subsequently tested across DBMSes, providing empirical support for this model as well as important engineering implications for improvements in transaction processing.

Original languageEnglish (US)
JournalInformation Systems
DOIs
StateAccepted/In press - Nov 17 2015

Keywords

  • DBMS Thrashing
  • Empirical Study
  • Factors
  • Structural Causal Model
  • Throughput
  • Transaction

ASJC Scopus subject areas

  • Software
  • Information Systems
  • Hardware and Architecture

Fingerprint Dive into the research topics of 'An empirical study of transaction throughput thrashing across multiple relational DBMSes'. Together they form a unique fingerprint.

  • Cite this