Published in


A Summary of TPC-DS

The state-of-the-art decision support benchmark.


Industry Standard Benchmarks

Decision Support Systems

  • “assessing and evaluating alternative options“ as well as
  • “evaluating the possible consequences of taking action in a situation“ ⁴.

History of TPC-DS

Characteristics of TPC-DS

  • Store
  • Catalog
  • Internet


ER-Diagram of Store_Sales and Store_Returns in TPC-DS

Data Set


  • Query workload
  • Data maintenance workload
  • a reporting part (Catalog sales channel, 40% of the entire dataset) and
  • an ad-hoc part (Internet & Store sales channels),
  • pure reporting queries
  • pure ad-hoc queries
  • iterative OLAP queries
  • extraction or data mining queries
  1. Data Extraction (E)
  2. Data Transformation (T)
  3. Data Load (L)

Benchmark Execution and Metric

TPC-DS Performance Metric


  1. Anon et al. (1985). A measure of transaction processing power.
    Datamation Volume 31 Issue 7 (pp. 112–118).
  2. Gregg, B. (2013). Systems Performance: Enterprise and the Cloud.
    Prentice Hall (p. 601).
  3. Transaction Processing Performance Council. (April 2019).
    TPC BENCHMARK ™DS Standard Specification, Version 2.11.0, tpc.org
  4. Power, D. J. Decision Support Systems Glossary. (2014). http://DSSResources.COM/glossary/
  5. Nižetić, I., Fertalj, K., & Milašinović, B. (2007, January).
    An overview of decision support system concepts.
    In 18th International Conference on Information and Intelligent Systems (pp. 251–256).
  6. Barata M., Bernardino J., Furtado P. (2015)
    An Overview of Decision Support Benchmarks: TPC-DS, TPC-H and SSB.
    In: Rocha A., Correia A., Costanzo S., Reis L. (eds) New Contributions in Information Systems and Technologies. Advances in Intelligent Systems and Computing, vol 353. Springer, Cham
  7. Raghunath Othayoth Nambiar and Meikel Poess. 2006.
    The making of TPC-DS.
    In Proceedings of the 32nd international conference on Very large data bases (VLDB ‘06), Umeshwar Dayal, Khu-Yong Whang, David Lomet, Gustavo Alonso, Guy Lohman, Martin Kersten, Sang K. Cha, and Young-Kuk Kim (Eds.). VLDB Endowment 1049–1058.
  8. Transaction Processing Performance Council. (December 2019).
    TPC BENCHMARK ™H Standard Specification, Version 2.18.0, tpc.org



Hyrise is an open-source, in-memory database, which is being under active development at Hasso Plattner Institute.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Julian Menzler

Currently, I’m doing my master’s degree in IT-Systems Engineering at Hasso-Plattner-Institute in Potsdam/Germany.