Synthesizing representative I/O workloads for TPC-H

Jianyong Zhang, Anand Sivasubramaniam, Hubertus Franke, Natarajan Gautam, Yanyong Zhang, Shailabh Nagar

Research output: Contribution to journalConference Articlepeer-review

48 Scopus citations


Synthesizing I/O requests that can accurately capture workload behavior is extremely valuable for the design, implementation and optimization of disk subsystems. This paper presents a synthetic workload generator for TPC-H, an important decision-support commercial workload, by completely characterizing the arrival and access patterns of its queries. We present a novel approach for parameterizing the behavior of inter-mingling streams of sequential requests, and exploit correlations between multiple attributes of these requests, to generate disk block-level traces that are shown to accurately mimic the behavior of a real trace in terms of response time characteristics for each TPC-H query.

Original languageEnglish (US)
Pages (from-to)142-151
Number of pages10
JournalIEEE High-Performance Computer Architecture Symposium Proceedings
StatePublished - 2004
Externally publishedYes
EventProceedings - 10th International Symposium on High Performance Computer Architecture - Madrid, Spain
Duration: Feb 14 2004Feb 18 2004

ASJC Scopus subject areas

  • Hardware and Architecture


Dive into the research topics of 'Synthesizing representative I/O workloads for TPC-H'. Together they form a unique fingerprint.

Cite this