Interaction-aware prediction of business intelligence workload completion times

Mumtaz Ahmad, Songyun Duan, Ashraf Aboulnaga, Shivnath Babu

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

11 Citations (Scopus)

Abstract

While planning the execution of report-generation workloads, database administrators often need to know how long different query workloads will take to run. Database systems run mixes of multiple queries of different types concurrently. Hence, estimating the completion time of a query workload requires reasoning about query mixes and inter-query interactions in the mixes; rather than considering queries or query types in isolation. This paper presents a novel approach for estimating workload completion time based on experiment-driven modeling and simulation of the impact of inter-query interactions. A preliminary evaluation of this approach with TPC-H queries on IBM DB2 shows how our approach can consistently predict workload completion times with good accuracy.

Original languageEnglish
Title of host publicationProceedings - International Conference on Data Engineering
Pages413-416
Number of pages4
DOIs
Publication statusPublished - 1 Jun 2010
Externally publishedYes
Event26th IEEE International Conference on Data Engineering, ICDE 2010 - Long Beach, CA, United States
Duration: 1 Mar 20106 Mar 2010

Other

Other26th IEEE International Conference on Data Engineering, ICDE 2010
CountryUnited States
CityLong Beach, CA
Period1/3/106/3/10

Fingerprint

Competitive intelligence
Planning
Experiments

ASJC Scopus subject areas

  • Information Systems
  • Signal Processing
  • Software

Cite this

Ahmad, M., Duan, S., Aboulnaga, A., & Babu, S. (2010). Interaction-aware prediction of business intelligence workload completion times. In Proceedings - International Conference on Data Engineering (pp. 413-416). [5447834] https://doi.org/10.1109/ICDE.2010.5447834

Interaction-aware prediction of business intelligence workload completion times. / Ahmad, Mumtaz; Duan, Songyun; Aboulnaga, Ashraf; Babu, Shivnath.

Proceedings - International Conference on Data Engineering. 2010. p. 413-416 5447834.

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

Ahmad, M, Duan, S, Aboulnaga, A & Babu, S 2010, Interaction-aware prediction of business intelligence workload completion times. in Proceedings - International Conference on Data Engineering., 5447834, pp. 413-416, 26th IEEE International Conference on Data Engineering, ICDE 2010, Long Beach, CA, United States, 1/3/10. https://doi.org/10.1109/ICDE.2010.5447834
Ahmad M, Duan S, Aboulnaga A, Babu S. Interaction-aware prediction of business intelligence workload completion times. In Proceedings - International Conference on Data Engineering. 2010. p. 413-416. 5447834 https://doi.org/10.1109/ICDE.2010.5447834
Ahmad, Mumtaz ; Duan, Songyun ; Aboulnaga, Ashraf ; Babu, Shivnath. / Interaction-aware prediction of business intelligence workload completion times. Proceedings - International Conference on Data Engineering. 2010. pp. 413-416
@inproceedings{f23630ec3e2940e7b08307622e4ce8ff,
title = "Interaction-aware prediction of business intelligence workload completion times",
abstract = "While planning the execution of report-generation workloads, database administrators often need to know how long different query workloads will take to run. Database systems run mixes of multiple queries of different types concurrently. Hence, estimating the completion time of a query workload requires reasoning about query mixes and inter-query interactions in the mixes; rather than considering queries or query types in isolation. This paper presents a novel approach for estimating workload completion time based on experiment-driven modeling and simulation of the impact of inter-query interactions. A preliminary evaluation of this approach with TPC-H queries on IBM DB2 shows how our approach can consistently predict workload completion times with good accuracy.",
author = "Mumtaz Ahmad and Songyun Duan and Ashraf Aboulnaga and Shivnath Babu",
year = "2010",
month = "6",
day = "1",
doi = "10.1109/ICDE.2010.5447834",
language = "English",
isbn = "9781424454440",
pages = "413--416",
booktitle = "Proceedings - International Conference on Data Engineering",

}

TY - GEN

T1 - Interaction-aware prediction of business intelligence workload completion times

AU - Ahmad, Mumtaz

AU - Duan, Songyun

AU - Aboulnaga, Ashraf

AU - Babu, Shivnath

PY - 2010/6/1

Y1 - 2010/6/1

N2 - While planning the execution of report-generation workloads, database administrators often need to know how long different query workloads will take to run. Database systems run mixes of multiple queries of different types concurrently. Hence, estimating the completion time of a query workload requires reasoning about query mixes and inter-query interactions in the mixes; rather than considering queries or query types in isolation. This paper presents a novel approach for estimating workload completion time based on experiment-driven modeling and simulation of the impact of inter-query interactions. A preliminary evaluation of this approach with TPC-H queries on IBM DB2 shows how our approach can consistently predict workload completion times with good accuracy.

AB - While planning the execution of report-generation workloads, database administrators often need to know how long different query workloads will take to run. Database systems run mixes of multiple queries of different types concurrently. Hence, estimating the completion time of a query workload requires reasoning about query mixes and inter-query interactions in the mixes; rather than considering queries or query types in isolation. This paper presents a novel approach for estimating workload completion time based on experiment-driven modeling and simulation of the impact of inter-query interactions. A preliminary evaluation of this approach with TPC-H queries on IBM DB2 shows how our approach can consistently predict workload completion times with good accuracy.

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

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

U2 - 10.1109/ICDE.2010.5447834

DO - 10.1109/ICDE.2010.5447834

M3 - Conference contribution

SN - 9781424454440

SP - 413

EP - 416

BT - Proceedings - International Conference on Data Engineering

ER -