Why You Should Run TPC-DS:A Workload Analysis

Summary: Characterizes TPC-DS across database loading, complex query processing, and data maintenance, quantifying each phase’s impact on the benchmark metric. Provides practitioners and researchers guidance for interpreting this emerging industry-standard decision-support workload. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h1b9e07a4ee923ae3
Venue: VLDB
Year: 2007
Pagerank: 7.5387953e-05
Overall Rank: 3,207 | 78.44%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Meikel Poess (Oracle)
2. Raghunath Othayoth Nambiar (Hewlett Packard Enterprise)
3. David Walrath (Sybase Inc)

BibTeX Citation

@article{poess_vldb07,
        title = {{Why You Should Run TPC-DS:A Workload Analysis}},
        author = {Poess, Meikel and Nambiar, Raghunath Othayoth and Walrath, David},
        journal = {PVLDB},
        series = {{VLDB} '07},
        pages = {1138--1149},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,702	BigBench: Towards an Industry Standard Benchmark for Big Data Analytics	2013	SIGMOD	9.8361594e-05
1,890	Generating Targeted Queries for Database Testing	2008	SIGMOD	9.4193315e-05
1,952	Quantifying TPC-H Choke Points and Their Optimizations	2020	VLDB	9.3189525e-05
2,155	Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries	2008	VLDB	8.9456729e-05
4,929	TPC-DI: The First Industry Benchmark for Data Integration	2014	VLDB	6.3494846e-05
6,713	G-SQL: Fast Query Processing via Graph Exploration	2016	VLDB	5.7002243e-05
8,563	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	5.3138647e-05
8,601	Towards Resource Efficiency: Practical Insights into Large-Scale Spark Workloads at ByteDance	2024	VLDB	5.3051732e-05
8,636	PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking	2025	VLDB	5.2981619e-05
9,620	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	5.1501614e-05
10,280	Chukonu: A Fully-Featured High-Performance Big Data Framework that Integrates a Native Compute Engine into Spark	2022	VLDB	5.0455234e-05
10,473	L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression	2026	SIGMOD	4.9793485e-05
10,679	Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization	2026	SIGMOD	4.9793485e-05
11,984	Vertex-centric Parallel Computation of SQL Queries	2021	SIGMOD	4.9793485e-05
12,494	Design and Implementation of a Real-Time Interactive Analytics System for Large Spatio-Temporal Data	2014	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00068998927
479	The Making of TPC-DS	2006	VLDB	0.00017622471
996	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00012634603
2,712	Generating Thousand Benchmark Queries in Seconds	2004	VLDB	8.1035277e-05
2,719	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD	8.0967665e-05
14,172	Large Scale Data Warehouses on Grid: Oracle Database 10g and HP ProLiant Servers	2005	VLDB	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,742	A Study of Database Performance Sensitivity to Experiment Settings	2022	VLDB
2	4,929	TPC-DI: The First Industry Benchmark for Data Integration	2014	VLDB
3	1,839	Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet	2024	VLDB
4	9,554	Keeping the TPC Relevant!	2013	VLDB
5	936	A Modeling Study of the TPC-C Benchmark	1993	SIGMOD
6	14,765	Database System Performance Measurement	1986	SIGMOD
7	3,431	Data Generation for Application-Specific Benchmarking	2011	VLDB
8	1,515	DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems	2021	VLDB
9	479	The Making of TPC-DS	2006	VLDB
10	2,719	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD