Home

About

Advanced Search

Browse by Discipline

Scientific Societies

E-print Alerts

Add E-prints

E-print Network
FAQHELPSITE MAPCONTACT US


  Advanced Search  

 
Priority Mechanisms for OLTP and Transactional Web Applications David T. McWherter Bianca Schroeder Anastassia Ailamaki Mor Harchol-Balter
 

Summary: Priority Mechanisms for OLTP and Transactional Web Applications

David T. McWherter Bianca Schroeder Anastassia Ailamaki Mor Harchol-Balter
Abstract
Transactional workloads are a hallmark of modern
OLTP and Web applications, ranging from electronic com-
merce and banking to online shopping. Often, the database
at the core of these applications is the performance bottle-
neck. 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 pri-
oritization.
This paper analyzes and proposes prioritization for
transactional workloads in traditional database systems
(DBMS). This work first performs a detailed bottleneck
analysis of resource usage by transactional workloads on
commercial and noncommercial DBMS (IBM DB2, Post-
greSQL, Shore) under a range of configurations. Second,

  

Source: Ailamaki, Anastassia - School of Computer Science, Carnegie Mellon University

 

Collections: Computer Technologies and Information Sciences