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

Authors:
Meikel Poess;Bryan Smith;Lubor Kollar;Paul Larson
Affiliations:
Oracle Corporation, Redwood Shores, CA;IBM Corporation, San Jose, CA;Microsoft Corporation, Redmond, WA;Microsoft Corporation, Redmond, WA
Venue:
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Year:
2002

Citing 1
Cited 11

New TPC benchmarks for decision support and web commerce

ACM SIGMOD Record

MUDD: a multi-dimensional data generator

WOSP '04 Proceedings of the 4th international workshop on Software and performance
Goals and benchmarks for autonomic configuration recommenders

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
The making of TPC-DS

VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Generating thousand benchmark queries in seconds

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Why you should run TPC-DS: a workload analysis

VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Benchmarking data warehouses

International Journal of Business Intelligence and Data Mining
Architecture of a Database System

Foundations and Trends in Databases
A power consumption analysis of decision support systems

Proceedings of the first joint WOSP/SIPEW international conference on Performance engineering
Benchmarking spatial data warehouses

DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
A mixed transaction processing and operational reporting benchmark

Information Systems Frontiers
DWEB: a data warehouse engineering benchmark

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery

Quantified Score

Hi-index	0.00

Visualization

Abstract

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 product supplier, including data loading, multiple types of queries and data maintenance. The database consists of multiple snowflake schemas with shared dimension tables; data is skewed; and the query set is large. Overall, the benchmark is considerably more realistic than previous decision support benchmarks.