Converting TPC-H Query Templates to Use DSQGEN for Easy Extensibility

  • John M. StephensJr.
  • Meikel Poess
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5895)


The ability to automatically generate queries that are not known a-priory is crucial for ad-hoc benchmarks. TPC-H solves this problem with a query generator, QGEN, which utilizes query templates to generate SQL queries. QGEN’s architecture makes it difficult to maintain, change or adapt to new types of query templates since every modification requires code changes. DSQGEN, a generic query generator, originally written for the TPC-DS benchmark, uses a query template language, which allows for easy modification and extension of existing query templates. In this paper we show how the current set of TPC-H query templates can be migrated to the template language of DSQGEN without any change to comparability of published TPC-H results. The resulting query template model provides opportunities for easier enhancement and extension of the TPC-H workload, which we demonstrate.


Benchmark Development Databases Performance Analysis 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Stephens Jr., J.M., Poess, M.: MUDD: a multi-dimensional data generator. In: WOSP 2004, pp. 104–109 (2004)Google Scholar
  2. 2.
    Poess, M., Stephens Jr., J.M.: Generating Thousand Benchmark Queries in Seconds. In: VLDB 2004, pp. 1045–1053 (2004)Google Scholar
  3. 3.
    Poess, M.: Controlled SQL query evolution for decision support benchmarks. In: WOSP 2007, pp. 38–41 (2007)Google Scholar
  4. 4.
    Poess, M., Floyd, C.: New TPC Benchmarks for Decision Support and Web Commerce. ACM SIGMOD RECORD 29(4) (2000)Google Scholar
  5. 5.
  6. 6.
  7. 7.
    Transaction Processing Performance Council Policies Version 5.17,

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • John M. StephensJr.
    • 1
  • Meikel Poess
    • 2
  1. 1.Gradient SystemsRedwood City
  2. 2.Oracle CorporationRedwood Shores

Personalised recommendations