Encyclopedia of Big Data Technologies

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

TPC-H

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

Synonyms

Definitions

An enterprise class decision support benchmark by the Transaction Processing Performance Council examines large volumes of data to answer critical ad hoc business questions. It executes a suite of complex ad hoc SQL queries in single- and multiuser modes together with concurrent data modifications. The queries and the data populating the database have broad industry-wide relevance while maintaining a sufficient degree of ease of implementation.

Historical Background

The first decision support benchmark, TPC-D, was released to the public by the Transaction Processing Performance Council (TPC) on May 5, 1995. For the technology available at that time, TPC-D imposed many challenges both on hardware and on DBMS systems. It implemented a data warehouse using a 3rd normal form (3NF) schema consisting of eight tables. Anticipating the data explosion of data warehouses in the industry, TPC-D was developed to scale from 1 GB to...

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

References

  1. Ballinger C (1993) TPC-D: benchmarking for decision support. In: The benchmark handbook for database and transaction systems, 2nd edn. Morgan Kaufmann. ISBN 1-55860-292-5Google Scholar
  2. Barata M, Bernardino J, Furtado P (2015) An overview of decision support benchmarks: TPC-DS, TPC-H and SSB. WorldCIST (1):619–628CrossRefGoogle Scholar
  3. Boncz PA, Neumann T, Erling O (2013) TPC-H analyzed: hidden messages and lessons learned from an influential benchmark. TPCTC:61–76Google Scholar
  4. Chiba T, Onodera T (2016) Workload characterization and optimization of TPC-H queries on Apache Spark. ISPASS, pp 112–121Google Scholar
  5. Pöss M, Floyd C (2000) New TPC benchmarks for decision support and web commerce. SIGMOD Rec 29(4):64–71CrossRefGoogle 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