Optimizing I/O-intensive transactions in highly interactive applications

Mohamed A. Sharaf, Panos K. Chrysanthis, Alexandros Labrinidis, Cristiana Amza

Research output: Chapter in Book/Report/Conference proceedingConference contribution

14 Citations (Scopus)

Abstract

The performance provided by an interactive online database system is typically measured in terms of meeting certain pre-specified service level agreements (slas)With expected transaction latency being the most commonly used type of sla. this form of sla acts as a soft deadline for each transaction,And user satisfaction can be measured in terms of minimizing tardiness,that is.the deviation from sla. this objective is further complicated for i/o-intensive transactions,Where the storage system becomes the performance bottleneck. moreover,Common i/o scheduling policies employed by the operating system with a goal of improving i/o throughput or average latency may run counter to optimizing per-transaction performance since the operating system is typically oblivious to the application high-level sla specifications. in this paper,We propose a new sla-aware policy for scheduling i/o requests of database transactions. our proposed policy synergistically combines novel deadline-aware scheduling policies for database transactions with features of operating system scheduling policies designed for improving i/o throughput. this enables our proposed policy to dynamically adapt to workload and consistently provide the best performance.

Original languageEnglish
Title of host publicationSIGMOD-PODS'09 - Proceedings of the International Conference on Management of Data and 28th Symposium on Principles of Database Systems
Pages785-797
Number of pages13
DOIs
Publication statusPublished - 2009
Externally publishedYes
EventInternational Conference on Management of Data and 28th Symposium on Principles of Database Systems, SIGMOD-PODS'09 - Providence, RI, United States
Duration: Jun 29 2009Jul 2 2009

Publication series

NameSIGMOD-PODS'09 - Proceedings of the International Conference on Management of Data and 28th Symposium on Principles of Database Systems

Conference

ConferenceInternational Conference on Management of Data and 28th Symposium on Principles of Database Systems, SIGMOD-PODS'09
Country/TerritoryUnited States
CityProvidence, RI
Period6/29/097/2/09

Keywords

  • Database systems
  • I/O scheduling
  • Transaction processing

ASJC Scopus subject areas

  • Software

Fingerprint

Dive into the research topics of 'Optimizing I/O-intensive transactions in highly interactive applications'. Together they form a unique fingerprint.

Cite this