Encyclopedia of Big Data Technologies

2019 Edition
| Editors: Sherif Sakr, Albert Y. Zomaya


  • Meikel PoessEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-3-319-77525-8_127



TPC-DS is an enterprise-class benchmark, published and maintained by the Transaction Processing Performance Council (TPC), to measure the performance of decision support systems running on SQL-based big data systems. TPC-DS models several generally applicable aspects of an SQL-based big data system, including queries and data maintenance. The benchmark provides a representative evaluation of performance as a general-purpose decision support system. A benchmark result measures query response time in single-user mode, query throughput in multiuser mode, and data maintenance performance for a given hardware, operating system, and data processing system configuration under a controlled, complex decision support workload. The purpose of TPC-DS benchmarks is to provide relevant, objective performance data to industry users.

Historical Background

TPC’s decision to split the benchmark TPC-D into two new benchmarks, TPC-H and TPC-R, in February 26, 1999,...

This is a preview of subscription content, log in to check access.


  1. Barata M, Bernardino J, Furtado P (2015) An overview of decision support benchmarks: TPC-DS, TPC-H and SSB. WorldCIST 1:619–628Google Scholar
  2. Chen D, Ye X, Wang J (2013) A multidimensional data model for TPC-DS benchmarking. Internetware, pp 21:1–21:4Google Scholar
  3. Nambiar RO, Poess M (2006) The making of TPC-DS. VLDB, pp 1049–1058Google Scholar
  4. Poess M, Rabl T, Jacobsen H-J (2017) Analysis of TPC-DS: the first standard benchmark for SQL-based big data systems. SoCC, pp 573–585Google Scholar
  5. Pöss M, Smith B, Kollár L, Larson P-Å (2002) TPC-DS, taking decision support benchmarking to the next level. SIGMOD conference, pp 582–587Google Scholar
  6. Pöss M, Nambiar RO, Walrath D (2007) Why you should run TPC-DS: a workload analysis. VLDB, pp 1138–1149Google Scholar
  7. Shi L, Huang B, Xu H, Ye X (2010) Implementation of TPC-DS testing tool. DBTA, pp 1–4Google Scholar
  8. Zhao H, Ye X (2013) A practice of TPC-DS multidimensional implementation on NoSQL database systems. TPCTC, pp 93–108Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2019

Authors and Affiliations

  1. 1.Server TechnologiesOracle CorporationRedwood ShoresUSA

Section editors and affiliations

  • Meikel Poess
    • 1
  • Tilmann Rabl
    • 2
  1. 1.Server TechnologiesOracleRedwood ShoresUSA
  2. 2.Database Systems and Information Management GroupTechnische Universität BerlinBerlinGermany