QShuffler

Getting the query mix right

Mumtaz Ahmad, Ashraf Aboulnaga, Shivnath Babu, Kamesh Munagala

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

12 Citations (Scopus)

Abstract

The typical workload in a database system consists of a mixture of multiple queries of different types, running concurrently and interacting with each other. Hence, optimizing performance requires reasoning about query mixes and their interactions, rather than considering individual queries or query types. In this paper, we use such a reasoning approach to develop a query scheduler. We treat the database system as a black box and experimentally build a model to estimate the performance of different query mixes. Our scheduler uses this model to decide which query mixes to schedule, with the goal of maximizing throughput. We experimentally demonstrate the effectiveness of our scheduler using queries from the TPC-H benchmark on DB2.

Original languageEnglish
Title of host publicationProceedings - International Conference on Data Engineering
Pages1415-1417
Number of pages3
DOIs
Publication statusPublished - 1 Oct 2008
Externally publishedYes
Event2008 IEEE 24th International Conference on Data Engineering, ICDE'08 - Cancun, Mexico
Duration: 7 Apr 200812 Apr 2008

Other

Other2008 IEEE 24th International Conference on Data Engineering, ICDE'08
CountryMexico
CityCancun
Period7/4/0812/4/08

Fingerprint

Throughput

ASJC Scopus subject areas

  • Information Systems
  • Signal Processing
  • Software

Cite this

Ahmad, M., Aboulnaga, A., Babu, S., & Munagala, K. (2008). QShuffler: Getting the query mix right. In Proceedings - International Conference on Data Engineering (pp. 1415-1417). [4497574] https://doi.org/10.1109/ICDE.2008.4497574

QShuffler : Getting the query mix right. / Ahmad, Mumtaz; Aboulnaga, Ashraf; Babu, Shivnath; Munagala, Kamesh.

Proceedings - International Conference on Data Engineering. 2008. p. 1415-1417 4497574.

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

Ahmad, M, Aboulnaga, A, Babu, S & Munagala, K 2008, QShuffler: Getting the query mix right. in Proceedings - International Conference on Data Engineering., 4497574, pp. 1415-1417, 2008 IEEE 24th International Conference on Data Engineering, ICDE'08, Cancun, Mexico, 7/4/08. https://doi.org/10.1109/ICDE.2008.4497574
Ahmad M, Aboulnaga A, Babu S, Munagala K. QShuffler: Getting the query mix right. In Proceedings - International Conference on Data Engineering. 2008. p. 1415-1417. 4497574 https://doi.org/10.1109/ICDE.2008.4497574
Ahmad, Mumtaz ; Aboulnaga, Ashraf ; Babu, Shivnath ; Munagala, Kamesh. / QShuffler : Getting the query mix right. Proceedings - International Conference on Data Engineering. 2008. pp. 1415-1417
@inproceedings{3f97e26a6bcc43ccb0811853e699977e,
title = "QShuffler: Getting the query mix right",
abstract = "The typical workload in a database system consists of a mixture of multiple queries of different types, running concurrently and interacting with each other. Hence, optimizing performance requires reasoning about query mixes and their interactions, rather than considering individual queries or query types. In this paper, we use such a reasoning approach to develop a query scheduler. We treat the database system as a black box and experimentally build a model to estimate the performance of different query mixes. Our scheduler uses this model to decide which query mixes to schedule, with the goal of maximizing throughput. We experimentally demonstrate the effectiveness of our scheduler using queries from the TPC-H benchmark on DB2.",
author = "Mumtaz Ahmad and Ashraf Aboulnaga and Shivnath Babu and Kamesh Munagala",
year = "2008",
month = "10",
day = "1",
doi = "10.1109/ICDE.2008.4497574",
language = "English",
isbn = "9781424418374",
pages = "1415--1417",
booktitle = "Proceedings - International Conference on Data Engineering",

}

TY - GEN

T1 - QShuffler

T2 - Getting the query mix right

AU - Ahmad, Mumtaz

AU - Aboulnaga, Ashraf

AU - Babu, Shivnath

AU - Munagala, Kamesh

PY - 2008/10/1

Y1 - 2008/10/1

N2 - The typical workload in a database system consists of a mixture of multiple queries of different types, running concurrently and interacting with each other. Hence, optimizing performance requires reasoning about query mixes and their interactions, rather than considering individual queries or query types. In this paper, we use such a reasoning approach to develop a query scheduler. We treat the database system as a black box and experimentally build a model to estimate the performance of different query mixes. Our scheduler uses this model to decide which query mixes to schedule, with the goal of maximizing throughput. We experimentally demonstrate the effectiveness of our scheduler using queries from the TPC-H benchmark on DB2.

AB - The typical workload in a database system consists of a mixture of multiple queries of different types, running concurrently and interacting with each other. Hence, optimizing performance requires reasoning about query mixes and their interactions, rather than considering individual queries or query types. In this paper, we use such a reasoning approach to develop a query scheduler. We treat the database system as a black box and experimentally build a model to estimate the performance of different query mixes. Our scheduler uses this model to decide which query mixes to schedule, with the goal of maximizing throughput. We experimentally demonstrate the effectiveness of our scheduler using queries from the TPC-H benchmark on DB2.

UR - http://www.scopus.com/inward/record.url?scp=52649094265&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=52649094265&partnerID=8YFLogxK

U2 - 10.1109/ICDE.2008.4497574

DO - 10.1109/ICDE.2008.4497574

M3 - Conference contribution

SN - 9781424418374

SP - 1415

EP - 1417

BT - Proceedings - International Conference on Data Engineering

ER -