Article

The making of TPC-DS

Authors:

Raghunath Othayoth Nambiar,

Meikel PoessAuthors Info & Claims

VLDB '06: Proceedings of the 32nd international conference on Very large data bases

Pages 1049 - 1058

Published: 01 September 2006 Publication History

Get Access

Abstract

For the last decade, the research community and the industry have used TPC-D and its successor TPC-H to evaluate performance of decision support technology. Recognizing a paradigm shift in the industry the Transaction Processing Performance Council has developed a new Decision Support benchmark, TPC-DS, expected to be released this year. From an ease of benchmarking perspective it is similar to past benchmarks. However, it adjusts for new technology and new approaches the industry has embarked on in recent years. This paper describes the main characteristics of TPC-DS, explains why some of the key decisions were made and which performance aspects of decision support system it measures.

References

[1]

{1} Robert H. Bonczek, Clyde W. Holsapple, and Andrew Whinston: Foundations of Decision Support Systems. Academic Press, 1981 ISBN 0-12-113050-9.

Google Scholar

[2]

{2} Gordon B. Davis: Management Information Systems: Conceptual Foundations, Structure and Development. McGraw-Hill, 1974.

Digital Library

Google Scholar

[3]

{3} Public release of TPC-DS (v0.32) preliminary draft: http://www.tpc.org/tpcds/default.asp.

Google Scholar

[4]

{4} TPC-H Specification 2.3.0: http://www.tpc.org/tpch/default.asp.

Google Scholar

[5]

{5} TPC pricing specification. http://www.tpc.org/pricing/spec/Price_V1.0.1.pdf

Google Scholar

[6]

{6} William H. Inmon: EIS and the Data Warehouse, Data Base Programming/Design, November 1992.

Google Scholar

[7]

{7} Ralph W. Kimball, Warren Thornthwaite, Laura Reeves and Margy Ross: The Data Warehouse Lifecycle Toolkit, New York, NY: John Wiley and Sons, 1998.

Digital Library

Google Scholar

[8]

{8} Meikel Pöss, Bryan Smith, Lubor Kollár, Per-Åke Larson: TPC-DS, taking decision support benchmarking to the next level. SIGMOD Conference 2002: 582-587.

Digital Library

Google Scholar

[9]

{9} Meikel Pöss, Chris Floyd: New TPC Benchmarks for Decision Support and Web Commerce. SIGMOD Record 29(4): 64-71 (2000).

Digital Library

Google Scholar

[10]

{10} Meikel Poess, John M. Stephens: Generating Thousand Benchmark Queries in Seconds. VLDB 2004: 1045-1053.

Digital Library

Google Scholar

[11]

{11} John M. Stephens, Meikel Poess: MUDD: a multi-dimensional data generator. WOSP 2004: 104-109.

Digital Library

Google Scholar

[12]

{12} US Census Bureau, Unadjusted and Adjusted Estimates of Monthly Retail and Food Services Sales by Kinds of Business: 2001, Department stores (excl.L.D) 4521. http://www.census.gov/mrts/www/data/html/ nsal01.html.

Google Scholar

Cited By

View all

Paduroiu AWi SYan YBurd RFarchtchi RFumarola G(2024)Membrane - Safe and Performant Data Access Controls in Apache Spark in the Presence of Imperative CodeProceedings of the VLDB Endowment10.14778/3685800.368580817:12(3813-3826)Online publication date: 1-Aug-2024
https://dl.acm.org/doi/10.14778/3685800.3685808
Hansert PMichel S(2024)Partition, Don't Sort! Compression Boosters for Cloud Data Ingestion PipelinesProceedings of the VLDB Endowment10.14778/3681954.368201317:11(3456-3469)Online publication date: 1-Jul-2024
https://dl.acm.org/doi/10.14778/3681954.3682013
Zhang CFarouk T(2024)Sharing Queries with Nonequivalent User-defined Aggregate FunctionsACM Transactions on Database Systems10.1145/364913349:2(1-46)Online publication date: 10-Apr-2024
https://dl.acm.org/doi/10.1145/3649133
Show More Cited By

Index Terms

The making of TPC-DS

Recommendations

Why you should run TPC-DS: a workload analysis
VLDB '07: Proceedings of the 33rd international conference on Very large data bases

The Transaction Processing Performance Council (TPC) is completing development of TPC-DS, a new generation industry standard decision support benchmark. The TPC-DS benchmark, first introduced in the "The Making of TPC-DS" [9] paper at the 32^nd ...
TPC-DS, taking decision support benchmarking to the next level
SIGMOD '02: Proceedings of the 2002 ACM SIGMOD international conference on Management of data

TPC-DS is a new decision support benchmark currently under development by the Transaction Processing Performance Council (TPC). This paper provides a brief overview of the new benchmark. The benchmark models the decision support functions of a retail ...
TPC-E vs. TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study

TPC-E is a new OLTP benchmark recently approved by the Transaction Processing Performance Council (TPC). In this paper, we compare TPC-E with the familiar TPCC benchmark in order to understand the behavior of the new TPC-E benchmark. In particular, we ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

VLDB '06: Proceedings of the 32nd international conference on Very large data bases

September 2006

1269 pages

Publisher

VLDB Endowment

Publication History

Published: 01 September 2006

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

59
Total Citations
View Citations
895
Total Downloads

Downloads (Last 12 months)43
Downloads (Last 6 weeks)2

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Paduroiu AWi SYan YBurd RFarchtchi RFumarola G(2024)Membrane - Safe and Performant Data Access Controls in Apache Spark in the Presence of Imperative CodeProceedings of the VLDB Endowment10.14778/3685800.368580817:12(3813-3826)Online publication date: 1-Aug-2024
https://dl.acm.org/doi/10.14778/3685800.3685808
Hansert PMichel S(2024)Partition, Don't Sort! Compression Boosters for Cloud Data Ingestion PipelinesProceedings of the VLDB Endowment10.14778/3681954.368201317:11(3456-3469)Online publication date: 1-Jul-2024
https://dl.acm.org/doi/10.14778/3681954.3682013
Zhang CFarouk T(2024)Sharing Queries with Nonequivalent User-defined Aggregate FunctionsACM Transactions on Database Systems10.1145/364913349:2(1-46)Online publication date: 10-Apr-2024
https://dl.acm.org/doi/10.1145/3649133
Haroon SBrown CGulzar M(2024)DeSQL: Interactive Debugging of SQL in Data-Intensive Scalable ComputingProceedings of the ACM on Software Engineering10.1145/36437611:FSE(767-788)Online publication date: 12-Jul-2024
https://dl.acm.org/doi/10.1145/3643761
Camacho-Rodríguez JAgrawal AGruenheid AGosalia APetculescu CAguilar-Saborit JFloratou ACurino CRamakrishnan R(2024)LST-Bench: Benchmarking Log-Structured Tables in the CloudProceedings of the ACM on Management of Data10.1145/36393142:1(1-26)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639314
Jungmair MGiceva J(2023)Declarative Sub-Operators for Universal Data ProcessingProceedings of the VLDB Endowment10.14778/3611479.361153916:11(3461-3474)Online publication date: 24-Aug-2023
https://dl.acm.org/doi/10.14778/3611479.3611539
Liu CPavlenko AInterlandi MHaynes B(2023)A Deep Dive into Common Open Formats for Analytical DBMSsProceedings of the VLDB Endowment10.14778/3611479.361150716:11(3044-3056)Online publication date: 24-Aug-2023
https://dl.acm.org/doi/10.14778/3611479.3611507
Mohapatra AOh K(2023)SmartpickProceedings of the 24th International Middleware Conference10.1145/3590140.3592850(29-42)Online publication date: 27-Nov-2023
https://dl.acm.org/doi/10.1145/3590140.3592850
Perera ROetomo BRubinstein BBorovica-Gajic R(2022)HMABProceedings of the VLDB Endowment10.14778/3565816.356582416:2(216-229)Online publication date: 1-Oct-2022
https://dl.acm.org/doi/10.14778/3565816.3565824
Hilprecht BBinnig C(2022)Zero-shot cost models for out-of-the-box learned cost predictionProceedings of the VLDB Endowment10.14778/3551793.355179915:11(2361-2374)Online publication date: 29-Sep-2022
https://dl.acm.org/doi/10.14778/3551793.3551799
Show More Cited By

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Why you should run TPC-DS: a workload analysis

TPC-DS, taking decision support benchmarking to the next level

TPC-E vs. TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study