TY - GEN
T1 - TPC-H analyzed
T2 - 5th TPC Technology Conference on Performance Characterization and Benchmarking, TPCTC 2013
AU - Boncz, Peter
AU - Neumann, Thomas
AU - Erling, Orri
PY - 2014
Y1 - 2014
N2 - 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.
AB - 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.
UR - http://www.scopus.com/inward/record.url?scp=84958530960&partnerID=8YFLogxK
U2 - 10.1007/978-3-319-04936-6_5
DO - 10.1007/978-3-319-04936-6_5
M3 - Conference contribution
AN - SCOPUS:84958530960
SN - 9783319049359
T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
SP - 61
EP - 76
BT - Performance Characterization and Benchmarking - 5th TPC Technology Conference, TPCTC 2013, Revised Selected Papers
PB - Springer Verlag
Y2 - 26 August 2013 through 26 August 2013
ER -