DBScholar

Back to papers

The Making of TPC-DS

Summary: Introducing TPC-DS as the successor to TPC-D/H for decision-support benchmarking, reflecting shifts. Describes key design choices and performance dimensions the benchmark targets, emphasizing modern workloads and data/query characteristics. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h6bf511d26e052e8c
Venue
VLDB
Year
2006
Pagerank
0.00017656775
Overall Rank
473 | 96.84%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{othayoth_vldb06,
        title = {{The Making of TPC-DS}},
        author = {Othayoth, Raghunath and Poess, Meikel},
        journal = {PVLDB},
        series = {{VLDB} '06},
        year = {2006}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 64 citing papers.

Rank Citing Paper Year Venue Pagerank
545 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001657599
1,400 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010759064
1,707 BigBench: Towards an Industry Standard Benchmark for Big Data Analytics 2013 SIGMOD 9.8031942e-05
1,839 DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models 2019 SIGMOD 9.5187688e-05
1,958 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 9.2894133e-05
2,169 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.9151935e-05
2,348 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.5910072e-05
2,619 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 8.1985665e-05
2,622 The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database 2016 VLDB 8.1976067e-05
2,673 A Layered Aggregate Engine for Analytics Workloads 2019 SIGMOD 8.1276375e-05
3,152 White-box Compression: Learning and Exploiting Compact Table Representations 2020 CIDR 7.5717115e-05
3,217 Why You Should Run TPC-DS:A Workload Analysis 2007 VLDB 7.5107676e-05
3,438 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.2807703e-05
4,048 Of Snowstorms and Bushy Trees 2014 VLDB 6.817438e-05
4,346 Analyzing and Comparing Lakehouse Storage Systems 2023 CIDR 6.6386388e-05
4,373 A Deep Dive into Common Open Formats for Analytical DBMSs 2023 VLDB 6.6191786e-05
4,726 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4329878e-05
4,752 Interactive Summarization and Exploration of Top Aggregate Query Answers 2018 VLDB 6.4226993e-05
4,792 Learned Approximate Query Processing: Make it Light, Accurate and Fast 2021 CIDR 6.4010108e-05
4,949 TPCx-AI - An Industry Standard Benchmark for Artificial Intelligence and Machine Learning Systems 2023 VLDB 6.3271767e-05
5,484 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.0980944e-05
5,687 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0201937e-05
6,113 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 5.8662826e-05
6,291 Fast and Effective Distribution-Key Recommendation for Amazon Redshift 2020 VLDB 5.8049232e-05
6,305 Declarative Sub-Operators for Universal Data Processing 2023 VLDB 5.8008469e-05
6,618 Cackle: Analytical Workload Cost and Performance Stability With Elastic Pools 2023 SIGMOD 5.715013e-05
7,347 Scalable Multi-Query Execution using Reinforcement Learning 2021 SIGMOD 5.5308106e-05
7,487 Membrane - Safe and Performant Data Access Controls in Apache Spark in the Presence of Imperative Code 2024 VLDB 5.4995746e-05
7,520 SmartBench: A Benchmark For Data Management In Smart Spaces 2020 VLDB 5.4883285e-05
7,534 Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g 2008 SIGMOD 5.4849807e-05
7,605 Unity Catalog: Open and Universal Governance for the Lakehouse and Beyond 2025 SIGMOD 5.4703362e-05
7,927 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 5.4082473e-05
7,989 Leveraging Dynamic and Heterogeneous Workload Knowledge to Boost the Performance of Index Advisors 2024 VLDB 5.3951416e-05
8,175 PIDS: Attribute Decomposition for Improved Compression and Query Performance in Columnar Storage 2020 VLDB 5.3689261e-05
8,232 LST-Bench: Benchmarking Log-Structured Tables in the Cloud 2024 SIGMOD 5.357241e-05
8,412 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 5.3211467e-05
8,517 SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries 2020 SIGMOD 5.3110227e-05
8,873 Workload-driven, Lazy Discovery of Data Dependencies for Query Optimization 2022 CIDR 5.2459234e-05
9,050 AutoComp: Automated Data Compaction for Log-Structured Tables in Data Lakes 2025 SIGMOD 5.2152045e-05
9,102 The LDBC Financial Benchmark: Transaction Workload 2025 VLDB 5.208561e-05
9,240 NeuroSketch: Fast and Approximate Evaluation of Range Aggregate Queries with Neural Networks 2023 SIGMOD 5.1867235e-05
9,245 Powering In-Database Dynamic Model Slicing for Structured Data Analytics 2024 VLDB 5.1863797e-05
9,251 Text-to-SQL Benchmarks are Broken: An In-Depth Analysis of Annotation Errors 2026 CIDR 5.1860131e-05
9,256 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB 5.1860131e-05
9,476 Saving Money for Analytical Workloads in the Cloud 2024 VLDB 5.157794e-05
9,594 Global Hash Tables Strike Back! An Analysis of Parallel GROUP BY Aggregation 2026 VLDB 5.1376962e-05
9,662 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1283524e-05
9,754 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR 5.115551e-05
9,767 PAR2QO: Parametric Penalty-Aware Robust Query Optimization 2025 VLDB 5.115551e-05
10,225 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 5.0460607e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank Cited Paper Year Venue Pagerank
2,719 Generating Thousand Benchmark Queries in Seconds 2004 VLDB 8.0785428e-05
2,731 TPC-DS, Taking Decision Support Benchmarking to the Next Level 2002 SIGMOD 8.0676575e-05
Previous Page 1 / 1 Next

Semantically Similar Papers