Back to Search
Start Over
TPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark
- Source :
- Performance Characterization and Benchmarking ISBN: 9783319049359, TPCTC, Proceedings of the TPC Technology Conference on Performance Evaluation $1amp; Benchmarking (TPCTC, 2013)
- Publication Year :
- 2013
-
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.
- Subjects :
- Information retrieval
Point (typography)
Computer science
Locality
InformationSystems_DATABASEMANAGEMENT
Workload
02 engineering and technology
Expression (computer science)
Data science
Query plan
Set (abstract data type)
Data access
020204 information systems
Benchmark (surveying)
benchmarking database
0202 electrical engineering, electronic engineering, information engineering
020201 artificial intelligence & image processing
Subjects
Details
- Language :
- English
- ISBN :
- 978-3-319-04935-9
- ISBNs :
- 9783319049359
- Database :
- OpenAIRE
- Journal :
- Performance Characterization and Benchmarking ISBN: 9783319049359, TPCTC, Proceedings of the TPC Technology Conference on Performance Evaluation $1amp; Benchmarking (TPCTC, 2013)
- Accession number :
- edsair.doi.dedup.....11741e475c9c9d7da5244d5c98c340f6