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.5353129e-05
Overall Rank: 3,209 | 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.8315163e-05
1,893	Generating Targeted Queries for Database Testing	2008	SIGMOD	9.4149369e-05
1,949	Quantifying TPC-H Choke Points and Their Optimizations	2020	VLDB	9.3172855e-05
2,157	Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries	2008	VLDB	8.9425625e-05
4,930	TPC-DI: The First Industry Benchmark for Data Integration	2014	VLDB	6.346494e-05
6,718	G-SQL: Fast Query Processing via Graph Exploration	2016	VLDB	5.6975275e-05
8,570	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	5.3113492e-05
8,608	Towards Resource Efficiency: Practical Insights into Large-Scale Spark Workloads at ByteDance	2024	VLDB	5.3026618e-05
8,643	PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking	2025	VLDB	5.2956539e-05
9,627	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	5.1477233e-05
10,286	Chukonu: A Fully-Featured High-Performance Big Data Framework that Integrates a Native Compute Engine into Spark	2022	VLDB	5.0431349e-05
10,484	L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression	2026	SIGMOD	4.9769913e-05
10,690	Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization	2026	SIGMOD	4.9769913e-05
11,990	Vertex-centric Parallel Computation of SQL Queries	2021	SIGMOD	4.9769913e-05
12,500	Design and Implementation of a Real-Time Interactive Analytics System for Large Spatio-Temporal Data	2014	VLDB	4.9769913e-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.0006897844
480	The Making of TPC-DS	2006	VLDB	0.00017615432
995	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00012629969
2,712	Generating Thousand Benchmark Queries in Seconds	2004	VLDB	8.0997193e-05
2,720	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD	8.0936194e-05
14,177	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,751	A Study of Database Performance Sensitivity to Experiment Settings	2022	VLDB
2	4,930	TPC-DI: The First Industry Benchmark for Data Integration	2014	VLDB
3	1,834	Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet	2024	VLDB
4	9,562	Keeping the TPC Relevant!	2013	VLDB
5	933	A Modeling Study of the TPC-C Benchmark	1993	SIGMOD
6	14,770	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	480	The Making of TPC-DS	2006	VLDB
10	2,720	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD