Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Big Data Technologies pp 1698–1702Cite as

TPC-H

  • Reference work entry
  • First Online:

  • 47 Accesses

Synonyms

Ad hoc benchmark; Data warehouse benchmark

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 via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   849.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD   999.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

References

  • 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-5

    Google Scholar 

  • Barata M, Bernardino J, Furtado P (2015) An overview of decision support benchmarks: TPC-DS, TPC-H and SSB. WorldCIST (1):619–628

    Chapter  Google Scholar 

  • Boncz PA, Neumann T, Erling O (2013) TPC-H analyzed: hidden messages and lessons learned from an influential benchmark. TPCTC:61–76

    Google Scholar 

  • Chiba T, Onodera T (2016) Workload characterization and optimization of TPC-H queries on Apache Spark. ISPASS, pp 112–121

    Google Scholar 

  • Pöss M, Floyd C (2000) New TPC benchmarks for decision support and web commerce. SIGMOD Rec 29(4):64–71

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Server Technologies, Oracle Corporation, Redwood Shores, CA, USA

    Meikel Poess

Authors
  1. Meikel Poess
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Meikel Poess .

Editor information

Editors and Affiliations

  1. Institute of Computer Science, University of Tartu, Tartu, Estonia

    Sherif Sakr

  2. School of Information Technologies, Sydney University, Sydney, Australia

    Albert Y. Zomaya

Section Editor information

  1. Server Technologies, Oracle, Redwood Shores, California, USA

    Meikel Poess

  2. Database Systems and Information Management Group, Technische Universität Berlin, Berlin, Germany

    Tilmann Rabl

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer International Publishing AG, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Poess, M. (2019). TPC-H. In: Sakr, S., Zomaya, A.Y. (eds) Encyclopedia of Big Data Technologies. Springer, Cham. https://doi.org/10.1007/978-3-319-77525-8_126

Download citation

Publish with us

Policies and ethics

Search

Navigation