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

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.

REFERENCES

• 1: Ballinger, C., "High Noon for TPC-D; TPC-D is Relevant and Realistic", Database Programming and Design, September 1997, Vol. 10 #9
• 2: Ballinger, C., "Relevance of the TPC-D Benchmark Queries: The Questions You Ask Every Day", NCR Parallel Systems
• 3: Kimball, R., "The Data Warehouse Toolkit", John Wiley & Sons, Inc 1996
• 4: Kimball, R. Merz, R., "The Data Webhouse Toolkit", John Wiley & Sons, Inc 2000
• 5: 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)
• 6: Meikel Poess , Chris Floyd, New TPC benchmarks for decision support and web commerce, ACM SIGMOD Record, v.29 n.4, p.64-71, Dec. 2000 [doi>10.1145/369275.369291]
• 7: TPC Benchmark™ DS (Decision Support) Draft Specification

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.7 Database Administration
      H.2.8 Database applications

General Terms:
Design, Performance, Standardization

Keywords:
TPC, benchmark, data warehouse, decision support, performance evaluation