skip to main content
10.1145/564691.564759acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
Article

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

Published:03 June 2002Publication History

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 #9Google ScholarGoogle Scholar
  2. Ballinger, C., "Relevance of the TPC-D Benchmark Queries: The Questions You Ask Every Day", NCR Parallel SystemsGoogle ScholarGoogle Scholar
  3. Kimball, R., "The Data Warehouse Toolkit", John Wiley & Sons, Inc 1996Google ScholarGoogle Scholar
  4. Kimball, R. Merz, R., "The Data Webhouse Toolkit", John Wiley & Sons, Inc 2000Google ScholarGoogle Scholar
  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)Google ScholarGoogle Scholar
  6. Poess, M. and Floyd, C., "New TPC Benchmarks for Decision Support and Web Commerce". ACM SIGMOD REORD, Vol 29, No 4 (Dec 2000) Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. TPC Benchmark™ DS (Decision Support) Draft SpecificationGoogle ScholarGoogle Scholar

Index Terms

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

        Recommendations

        Comments

        Login options

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

        Sign in
        • Published in

          cover image ACM Conferences
          SIGMOD '02: Proceedings of the 2002 ACM SIGMOD international conference on Management of data
          June 2002
          654 pages
          ISBN:1581134975
          DOI:10.1145/564691

          Copyright © 2002 ACM

          Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

          Publisher

          Association for Computing Machinery

          New York, NY, United States

          Publication History

          • Published: 3 June 2002

          Permissions

          Request permissions about this article.

          Request Permissions

          Check for updates

          Qualifiers

          • Article

          Acceptance Rates

          SIGMOD '02 Paper Acceptance Rate42of240submissions,18%Overall Acceptance Rate785of4,003submissions,20%

        PDF Format

        View or Download as a PDF file.

        PDF

        eReader

        View online with eReader.

        eReader