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.
- Ballinger, C., "High Noon for TPC-D; TPC-D is Relevant and Realistic", Database Programming and Design, September 1997, Vol. 10 #9Google Scholar
- Ballinger, C., "Relevance of the TPC-D Benchmark Queries: The Questions You Ask Every Day", NCR Parallel SystemsGoogle Scholar
- Kimball, R., "The Data Warehouse Toolkit", John Wiley & Sons, Inc 1996Google Scholar
- Kimball, R. Merz, R., "The Data Webhouse Toolkit", John Wiley & Sons, Inc 2000Google Scholar
- Levine, C., Stephens Jr., J. M., DeWitt, D. (Chair), "Standard Benchmarks for Database Systems", ACM SIGMOD 1997 Industrial Session 5 (http:/www.tpc.org/information/sessions/sigmod/indexc.htm)Google Scholar
- Poess, M. and Floyd, C., "New TPC Benchmarks for Decision Support and Web Commerce". ACM SIGMOD REORD, Vol 29, No 4 (Dec 2000) Google ScholarDigital Library
- TPC Benchmark™ DS (Decision Support) Draft SpecificationGoogle Scholar
Index Terms
TPC-DS, taking decision support benchmarking to the next level
Recommendations
New Initiatives in the TPC
Performance Evaluation and BenchmarkingAbstractTPC stands for stricter standards and tougher tests in system benchmarking for over 30 years, during which technology advanced enormously. In order to stay relevant the TPC had to adapt to the advancing technology or become obsolete. Initially, ...
Controlled SQL query evolution for decision support benchmarks
WOSP '07: Proceedings of the 6th international workshop on Software and performanceThe synthesis of increased global competitiveness and the acceptance of commercially available multi purpose database management systems (DBMS) for decision support applications requires an ever more critical system evaluation and selection to be ...
Why you should run TPC-DS: a workload analysis
VLDB '07: Proceedings of the 33rd international conference on Very large data basesThe 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 32nd ...
Comments