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: 9714
Venue: VLDB
Year: 2007
Pagerank: 7.6664516e-05
Overall Rank: 3,173 | 78.24%
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,693	BigBench: Towards an Industry Standard Benchmark for Big Data Analytics	2013	SIGMOD	9.9965799e-05
2,069	Generating Targeted Queries for Database Testing	2008	SIGMOD	9.2293717e-05
2,150	Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries	2008	VLDB	9.081101e-05
2,202	Quantifying TPC-H Choke Points and Their Optimizations	2020	VLDB	8.9639459e-05
4,877	TPC-DI: The First Industry Benchmark for Data Integration	2014	VLDB	6.468584e-05
7,769	G-SQL: Fast Query Processing via Graph Exploration	2016	VLDB	5.5474529e-05
8,410	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	5.4309397e-05
8,457	Towards Resource Efficiency: Practical Insights into Large-Scale Spark Workloads at ByteDance	2024	VLDB	5.4217837e-05
9,441	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	5.2678428e-05
9,777	PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking	2025	VLDB	5.2209769e-05
10,076	Chukonu: A Fully-Featured High-Performance Big Data Framework that Integrates a Native Compute Engine into Spark	2022	VLDB	5.1613298e-05
10,260	L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression	2026	SIGMOD	5.093636e-05
10,492	Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization	2026	SIGMOD	5.093636e-05
11,677	Vertex-centric Parallel Computation of SQL Queries	2021	SIGMOD	5.093636e-05
12,203	Design and Implementation of a Real-Time Interactive Analytics System for Large Spatio-Temporal Data	2014	VLDB	5.093636e-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.00069513174
476	The Making of TPC-DS	2006	VLDB	0.00017860667
984	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00012825643
2,690	Generating Thousand Benchmark Queries in Seconds	2004	VLDB	8.2519326e-05
2,726	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD	8.203274e-05
13,861	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,576	A Study of Database Performance Sensitivity to Experiment Settings	2022	VLDB
2	4,877	TPC-DI: The First Industry Benchmark for Data Integration	2014	VLDB
3	2,408	Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet	2024	VLDB
4	9,451	Keeping the TPC Relevant!	2013	VLDB
5	914	A Modeling Study of the TPC-C Benchmark	1993	SIGMOD
6	14,454	Database System Performance Measurement	1986	SIGMOD
7	3,404	Data Generation for Application-Specific Benchmarking	2011	VLDB
8	1,832	DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems	2021	VLDB
9	476	The Making of TPC-DS	2006	VLDB
10	2,726	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD