Priority Mechanisms for OLTP and Transactional Web Applications

Transactional workloads are a hallmark of modern OLTP and Web applications, ranging from electronic commerce and banking to online shopping. Often, the database at the core of these applications is the performance bottleneck. Given the limited resources available to the database, transaction execution times can vary wildly as they compete and wait for critical resources. As the competitor is "only a click away," valuable (high-priority) users must be ensured consistently good performance via QoS and transaction prioritization. This paper analyzes and proposes prioritization for transactional workloads in conventional DBMS. This work first conducts a detailed bottleneck analysis of resource usage by transactional workloads on commercial and noncommercial database systems (IBM DB2, PostgreSQL, Shore) under a variety of configurations. Our first contribution is a demonstration that for TPC-C workloads, under all of the above DBMS, transaction execution times are dominated by ti...

• Type: Conference
• Year: 2004
• Where: ICDE
• Authors: David T. McWherter, Bianca Schroeder, Anastassia Ailamaki, Mor Harchol-Balter
• Keywords: Database, ICDE 2004, Transaction Execution Times, Transaction Prioritization, Transactional Workloads