The TPC-D benchmark was developed almost 20 years ago, and even though its current existence as TPC H could be considered superseded by TPC-DS, one can still learn from it. We focus on the technical level, summarizing the challenges posed by the TPC-H workload as we now understand them, which we call "choke points". We identify 28 di fferent such choke points, grouped into six categories: Aggregation Performance, Join Performance, Data Access Locality, Expression Calculation, Correlated Subqueries and Parallel Execution. On the meta-level, we make the point that the rich set of choke-points found in TPC-H sets an example on how to design future DBMS benchmarks.

Additional Metadata
Keywords benchmarking database
ACM Systems (acm H.2.4)
THEME Information (theme 2)
Stakeholder Unspecified
Editor M. Poess , R. Niambar
Persistent URL dx.doi.org/10.1007/978-3-319-04936-6_5
Project LOD2 - Creating Knowledge out of Interlinked Data
Conference TPC Technology Conference on Performance Evaluation and Benchmarking
Citation
Boncz, P.A, Neumann, T, & Erling, O. (2013). TPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark. In M Poess & R Niambar (Eds.), . doi:10.1007/978-3-319-04936-6_5