Novel Approach For Estimating Workload Completion Time Based on Experiment-Driven Modeling and Simulation of the Impact of Inter-Query Interactions

Published in Journal

Journal of Advances in Science and Technology [JAST] (Vol:4/ Issue: 8) DOI: 10.29070/JAST
Authors: Vikrant Chauhan,
Subjects: Science & Technology

Year: Feb, 2013
Volume: 4 / Issue: 8
Pages: 0 - 0 (0)
Publisher: Ignited Minds Journals
Source:
E-ISSN: 2230-9659
DOI:
Published URL: http://ipublisher.in/I/a/1921
Published On: Feb, 2013

Article Details

Novel Approach For Estimating Workload Completion Time Based on Experiment-Driven Modeling and Simulation of the Impact of Inter-Query Interactions |

Vikrant Chauhan, in Journal of Advances in Science and Technology | Science & Technology

Download PDF

View PDF

ABSTRACT:

Whileplanning the execution of report-generation workloads, database administratorsoften 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 reasoningabout query mixes and inter-query interactions in the mixes; rather thanconsidering queries or query types in isolation. This paper presents a novelapproach for estimating workload completion time based on experiment-driven modelingand simulation of the impact of inter-query interactions. A preliminaryevaluation of this approach with TPC-H queries on IBM DB2 shows how ourapproach can consistently predict workload completion times with good accuracy.