Skip to main content

Evaluation of Mixing the Workload and Variation of the Database Schema

  • Chapter
  • First Online:
Benchmarking Transaction and Analytical Processing Systems

Part of the book series: In-Memory Data Management Research ((IMDM))

  • 1322 Accesses

Abstract

Three fundamental techniques for performance analysis are listed by Lilja [129], Chap. 1. These are simulation, analytical modeling, and measurements of existing systems. While the last provides the most precise results, it is the most difficult and time-consuming of the three techniques in addition to a limitation of the validity of the derived statements to only the measured system.

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

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Determination of the exact turning point has not been the focus of these measurements.

Bibliography

  1. D.J. Abadi, Column stores for wide and sparse data, in CIDR 2007, Third Biennial Conference on Innovative Data Systems Research, Asilomar, 2007, pp. 292–297. Online Proceedings. Retrieved from http://www.cidrdb.org. Last accessed 15 June 2012

  2. R. Jain, The Art of Computer Systems Performance Analysis: Techniques for Experimental Design, Measurement, Simulation, and Modeling: Techniques for Experimental Design, Measurement, Simulation and Modelling (Wiley, New York, 1991)

    Google Scholar 

  3. D.J. Lilja, Measuring Computer Performance: A Practitioner’s Guide (Cambridge University Press, Cambridge/New York, 2000)

    Google Scholar 

  4. M. Stonebraker, D.J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. O’Neil, P. O’Neil, A. Rasin, N. Tran, S. Zdonik, C-store: a column-oriented DBMS, in Proceedings of the 31st International Conference on Very Large Data Bases, VLDB ’05, Trondheim (VLDB Endowment, 2005), pp. 553–564

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Bog, A. (2014). Evaluation of Mixing the Workload and Variation of the Database Schema. In: Benchmarking Transaction and Analytical Processing Systems. In-Memory Data Management Research. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38070-9_7

Download citation

Publish with us

Policies and ethics