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.
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...
- 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
- Boncz PA, Neumann T, Erling O (2013) TPC-H analyzed: hidden messages and lessons learned from an influential benchmark. TPCTC:61–76Google Scholar
- Chiba T, Onodera T (2016) Workload characterization and optimization of TPC-H queries on Apache Spark. ISPASS, pp 112–121Google Scholar