Publications
Search

Publications :: Search

Optimizing I/O-Intensive Transactions in Highly Interactive Applications

Show publication

On this page you see the details of the selected publication.

    Publication properties
    Title: Optimizing I/O-Intensive Transactions in Highly Interactive Applications
    Rating: (1)
    Discussion: 0 comments
    Date: 2009
    Publication type: Conference paper
    Authors:
    No. First name Last name Show
    1. Mohamed Sharaf
    2. Cristiana Amza
    3. Panos Chrysanthis
    4. Alexandros Labrinidis
    Download (by DOI): 10.1145/1559845.1559927
    BibTeX: conf/sigmod/SharafCLA09
    DBLP: db/conf/sigmod/sigmod2009.html#SharafCLA09
    Bookmark:

    The following keywords have been assigned to this publication so far. If you have logged in, you can tag this publication with additional keywords.

    Keywords
    No keywords have been assigned to this publication yet.

    If you log in you can tag this publication with additional keywords

    A publication can refer to another publication (outgoing references) or it can be referred to by other publications (incoming references).

    Incoming References
    No incoming references have been assigned to this publication yet.
    Outgoing References
    No outgoing references have been assigned to this publication yet.

    If you log in you can add references to other publications

    A publication can be assigned to a conference, a journal or a school.

    Conference Track
    Conference Name: ACM SIGMOD International Conference on Management of Data, SIGMOD 2009, Providence, Rhode Island, USA, June 29 - July 2, 2009 2009
    Track Name: Research
    URL: http://www.sigmod09.org/

    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 is measured in terms of minimizing 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; the Operating System is typically SLA unaware. In this paper, we propose a new SLA-aware policy for scheduling I/O requests in 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 constantly improve the provided performance.