Skip to main content
SpringerLink
Log in

An Overview of Decision Support Benchmarks: TPC-DS, TPC-H and SSB

  • Conference paper
New Contributions in Information Systems and Technologies

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 353))

Abstract

Database management systems form the core of all business intelligence solutions, with information being the key to success in today’s businesses. Performance evaluation of database systems is a non-trivial activity, due to different architectures and functionalities tuned for specific requirements. In this paper we provide an overview and analyze the main properties of three benchmarks: TPC-DS, TPC-H and the SSB which are online analytical processing benchmarks in order to validate the performance of a Decision Support System.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 369.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. An overview of the TPC-C benchmark on HP ProLiant servers and server blades, ftp://ftp.hp.com/pub/c-products/servers/benchmarks/HP_ProLiant_tpcc_Overview.pdf (accessed October 14, 2013)

  2. Bog, A.: Benchmarking Transaction and Analytical Processing Systems - The Creation of a Mixed Workload Benchmark and its Application. Springer, Heidelberg (2014)

    Google Scholar 

  3. Decision Support Systems, http://www.slideshare.net/siddharth4mba/dss-decision-support-system (accessed April 5, 2014)

  4. Funke, F., Kemper, A.: Benchmarking Hybrid OLTP&OLAP Database Systems. In: BTW Conference on Database Systems for Business, Technology, and Web, BTW, pp. 390–409 (2011)

    Google Scholar 

  5. Kemper, A., Neumann, T.: HyPer: A Hybrid OLTP&OLAP Main Memory Database System Based on Virtual Memory Snapshots. IEEE Data Eng. Bull 36(2), 41–47 (2013)

    Google Scholar 

  6. O’Neil, P., O’Neil, P.E., Chen, X.E.: The star schema benchmark (SSB). University of Massachusetts, Boston, Technical Report (2007)

    Google Scholar 

  7. Poess, M., Nambiar, R.O., Walrath, D.: Why You Should Run TPC-DS:A Workload Analysis. VLDB, pp. 1138–1149 (2007)

    Google Scholar 

  8. Thanopoulou, A., Carreira, P.A., Galhardas, H.P.: Benchmarking with TPC-H on Off-the-Shelf Hardware. ICEIS (1), pp. 205–208 (2012)

    Google Scholar 

  9. TPC-DS, http://www.tpc.org/information/sessions/tpc_ds.pdf (accessed October 12, 2013)

  10. Benchmark, T.H., http://www.tpc.org/tpch/spec/tpch2.8.0.pdf (accessed, April 30, 2014)

  11. TPC-H Benchmark, http://cs338-s13.cs.uwaterloo.ca/ (accessed October 18, 2013)

  12. Turban, E., Zhou, D., Ma, J.: A Methodology for Evaluating Grades of Journals: A Fuzzy Set-based Group Decision Support System. HICSS (2000)

    Google Scholar 

  13. Zopounidis, C., Doumpos, M., Matsatsinis, N.F.: On the use of knowledge-based decision support systems in financial management: A survey. Decision Support Systems 20(3), 259–277 (1997)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Polytechnic Institute of Coimbra, Rua Pedro Nunes – Quinta da Nora, 3030-199, Coimbra, Portugal

    Melyssa Barata & Jorge Bernardino

  2. University of Coimbra Pinhal de Marrocos, 3030-290, Coimbra, Portugal

    Jorge Bernardino & Pedro Furtado

Authors
  1. Melyssa Barata
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jorge Bernardino
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Pedro Furtado
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Melyssa Barata .

Editor information

Editors and Affiliations

  1. DEI/FCT, Universidade de Coimbra, Coimbra, Portugal

    Alvaro Rocha

  2. Campus de Campolide, ISEGI, Lisboa, Portugal

    Ana Maria Correia

  3. DEIS, Università della Calabria, Arcavacata di Rende, Italy

    Sandra Costanzo

  4. DIS, Universidade do Minho, Guimarães, Portugal

    Luis Paulo Reis

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Barata, M., Bernardino, J., Furtado, P. (2015). An Overview of Decision Support Benchmarks: TPC-DS, TPC-H and SSB. In: Rocha, A., Correia, A., Costanzo, S., Reis, L. (eds) New Contributions in Information Systems and Technologies. Advances in Intelligent Systems and Computing, vol 353. Springer, Cham. https://doi.org/10.1007/978-3-319-16486-1_61

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-16486-1_61

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-16485-4

  • Online ISBN: 978-3-319-16486-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation