TPC-H analyzed: Hidden messages and lessons learned from an influential benchmark

P Boncz, T Neumann, O Erling - Technology Conference on Performance …, 2013 - Springer
Technology Conference on Performance Evaluation and Benchmarking, 2013Springer
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 different such
choke points, grouped into six categories: Aggregation Performance, Join Performance,
Data Access Locality, Expression Calculation, Correlated Subqueries and Parallel …
Abstract
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 different 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.
Springer
以上显示的是最相近的搜索结果。 查看全部搜索结果