Query interactions in database workloads

Mumtaz Ahmad, Ashraf Aboulnaga, Shivnath Babu

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

18 Citations (Scopus)

Abstract

Database workloads consist of mixes of queries that run concurrently and interact with each other. In this paper, we demonstrate that query interactions can have a significant impact on database system performance. Hence, we argue that it is important to take these interactions into account when characterizing workloads, designing test cases, or developing performance tuning algorithms for database systems. To capture and model query interactions, we propose using an experimental approach that is based on sampling the space of possible interactions and fitting statistical models to the sampled data. We discuss using such an approach for database testing and tuning, and we present some opportunities and research challenges.

Original languageEnglish
Title of host publicationProceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09
DOIs
Publication statusPublished - 23 Nov 2009
Externally publishedYes
Event2nd International Workshop on Testing Database Systems, DBTest '09 - Providence, RI, United States
Duration: 29 Jun 200929 Jun 2009

Other

Other2nd International Workshop on Testing Database Systems, DBTest '09
CountryUnited States
CityProvidence, RI
Period29/6/0929/6/09

Fingerprint

Tuning
Sampling
Testing
Statistical Models

ASJC Scopus subject areas

  • Computer Science Applications
  • Hardware and Architecture
  • Software

Cite this

Ahmad, M., Aboulnaga, A., & Babu, S. (2009). Query interactions in database workloads. In Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09 [1594170] https://doi.org/10.1145/1594156.1594170

Query interactions in database workloads. / Ahmad, Mumtaz; Aboulnaga, Ashraf; Babu, Shivnath.

Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09. 2009. 1594170.

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

Ahmad, M, Aboulnaga, A & Babu, S 2009, Query interactions in database workloads. in Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09., 1594170, 2nd International Workshop on Testing Database Systems, DBTest '09, Providence, RI, United States, 29/6/09. https://doi.org/10.1145/1594156.1594170
Ahmad M, Aboulnaga A, Babu S. Query interactions in database workloads. In Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09. 2009. 1594170 https://doi.org/10.1145/1594156.1594170
Ahmad, Mumtaz ; Aboulnaga, Ashraf ; Babu, Shivnath. / Query interactions in database workloads. Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09. 2009.
@inproceedings{805f99bfeedf4ba79517147f5b04e5cb,
title = "Query interactions in database workloads",
abstract = "Database workloads consist of mixes of queries that run concurrently and interact with each other. In this paper, we demonstrate that query interactions can have a significant impact on database system performance. Hence, we argue that it is important to take these interactions into account when characterizing workloads, designing test cases, or developing performance tuning algorithms for database systems. To capture and model query interactions, we propose using an experimental approach that is based on sampling the space of possible interactions and fitting statistical models to the sampled data. We discuss using such an approach for database testing and tuning, and we present some opportunities and research challenges.",
author = "Mumtaz Ahmad and Ashraf Aboulnaga and Shivnath Babu",
year = "2009",
month = "11",
day = "23",
doi = "10.1145/1594156.1594170",
language = "English",
isbn = "9781605587066",
booktitle = "Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09",

}

TY - GEN

T1 - Query interactions in database workloads

AU - Ahmad, Mumtaz

AU - Aboulnaga, Ashraf

AU - Babu, Shivnath

PY - 2009/11/23

Y1 - 2009/11/23

N2 - Database workloads consist of mixes of queries that run concurrently and interact with each other. In this paper, we demonstrate that query interactions can have a significant impact on database system performance. Hence, we argue that it is important to take these interactions into account when characterizing workloads, designing test cases, or developing performance tuning algorithms for database systems. To capture and model query interactions, we propose using an experimental approach that is based on sampling the space of possible interactions and fitting statistical models to the sampled data. We discuss using such an approach for database testing and tuning, and we present some opportunities and research challenges.

AB - Database workloads consist of mixes of queries that run concurrently and interact with each other. In this paper, we demonstrate that query interactions can have a significant impact on database system performance. Hence, we argue that it is important to take these interactions into account when characterizing workloads, designing test cases, or developing performance tuning algorithms for database systems. To capture and model query interactions, we propose using an experimental approach that is based on sampling the space of possible interactions and fitting statistical models to the sampled data. We discuss using such an approach for database testing and tuning, and we present some opportunities and research challenges.

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

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

U2 - 10.1145/1594156.1594170

DO - 10.1145/1594156.1594170

M3 - Conference contribution

SN - 9781605587066

BT - Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09

ER -