Adding a Temporal Dimension to the TPC-H Benchmark

  • Mohammed Al-Kateb
  • Alain Crolotte
  • Ahmad Ghazal
  • Linda Rose
Conference paper

DOI: 10.1007/978-3-642-36727-4_4

Part of the Lecture Notes in Computer Science book series (LNCS, volume 7755)
Cite this paper as:
Al-Kateb M., Crolotte A., Ghazal A., Rose L. (2013) Adding a Temporal Dimension to the TPC-H Benchmark. In: Nambiar R., Poess M. (eds) Selected Topics in Performance Evaluation and Benchmarking. TPCTC 2012. Lecture Notes in Computer Science, vol 7755. Springer, Berlin, Heidelberg

Abstract

The importance of time in decision-support is widely recognized and has been addressed through temporal applications or through native temporal features by major DBMS vendors. In this paper we propose a framework for adding a new temporal component to the TPC-H benchmark. Our proposal includes temporal DDL, procedures to populate the temporal tables via insertselect thereby providing history, and temporal queries based on a workload that covers the temporal dimension broken down as current, history, and both. The queries we define as part of this benchmark include the typical SQL operators involved in scans, joins and aggregations. The paper concludes with experimental results. While in this paper we consider adding temporal history to a subset of the TPC-H benchmark tables namely Part/ Supplier/Partsupp, our proposed framework addresses a need and uses, as a starting point, a benchmark that is widely successful and well-understood.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Mohammed Al-Kateb
    • 1
  • Alain Crolotte
    • 1
  • Ahmad Ghazal
    • 1
  • Linda Rose
    • 1
  1. 1.Teradata CorporationEl SegundoUSA

Personalised recommendations