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
Event2nd International Workshop on Testing Database Systems, DBTest '09 - Providence, RI, United States
Duration: 29 Jun 200929 Jun 2009

Publication series

NameProceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09

Other

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

    Fingerprint

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] (Proceedings of the 2nd International Workshop on Testing Database Systems, DBTest '09). https://doi.org/10.1145/1594156.1594170