Skip to main content
SpringerLink
Log in

Introduction

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

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

  • 1366 Accesses

Abstract

A wider usage of computers in the business setting started in the 1960s [185, Chap. 1]. The first task companies used computers for was the automation of simple routine tasks like payroll amount calculation. More business areas such as financial accounting, order entry, and billing soon followed. At that time, many of these tasks were semi-automatic with users entering information interactively and the system completing the task at a later point in time.

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 84.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

Bibliography

  1. S. Agrawal, E. Chu, V. Narasayya, Automatic physical design tuning: workload as a sequence, in Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data, SIGMOD ’06, Chicago (ACM, New York, 2006), pp. 683–694

    Google Scholar 

  2. AMD, HyperTransport technology I/O link, a high- bandwidth I/O architecture. White paper, Advanced Micro Devices, Inc., #25012, July 2001

    Google Scholar 

  3. A. Bog, J. Schaffner, J. Krüger, A composite benchmark for online transaction processing and operational reporting, in IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE’08), Tianjin, 2008, pp. 1–5

    Google Scholar 

  4. A. Bog, M. Domschke, J. Müller, A. Zeier, A framework for simulating combined OLTP and OLAP workloads, in 16th International Conference on Industrial Engineering and Engineering Management, IE&EM ’09, Beijing, 2009, pp. 1675–1678

    Google Scholar 

  5. A. Bog, H. Plattner, A. Zeier, A mixed transaction processing and operational reporting benchmark. Inf. Syst. Front. 13(3), 321–335 (2011). Kluwer Academic, Hingham

    Google Scholar 

  6. A. Bog, K. Sachs, A. Zeier, Benchmarking database design for mixed OLTP and OLAP workloads, in Proceedings of the Second Joint WOSP/SIPEW International Conference on Performance Engineering, ICPE ’11, Karlsruhe (ACM, New York, 2011), pp. 417–418

    Google Scholar 

  7. A. Bog, K. Sachs, A. Zeier, H. Plattner, Normalization in a mixed OLTP and OLAP workload scenario, in Third TPC Technology Conference on Performance Evaluation & Benchmarking (TPCTC), Seattle, 2011

    Google Scholar 

  8. A. Bog, K. Sachs, H. Plattner, Interactive performance monitoring of a composite OLTP and OLAP workload, in Proceedings of the 2012 International Conference on Management of Data, SIGMOD ’12, Scottsdale (ACM, New York, 2012), pp. 645–648

    Google Scholar 

  9. S. Chaudhuri, U. Dayal, An overview of data warehousing and OLAP technology. ACM SIGMOD Rec. 26(1), 65–74 (1997). ACM, New York

    Google Scholar 

  10. E.F. Codd, S.B. Codd, C.T. Salley, Providing OLAP (on-line analytical processing) to user-analysis: an IT mandate. Arbor Software, Hyperion Solutions Corp., White paper, 1993

    Google Scholar 

  11. R.L. Cross, ITJ foreword Q1, 2002. Intel Technol. J. Hyper-Threading Technol. 6(1), 3 (2002)

    Google Scholar 

  12. J. Dittrich, A. Jindal, Towards a one size fits all database architecture, in Outrageous Ideas and Vision Track, 5th Biennial Conference on Innovative Data Systems Research (CIDR 11), Asilomar, 2011. Online Proceedings. Retrieved from http://www.cidrdb.org/cidr2011/program.html. Last accessed 15 June 2012

  13. D. Fisher, Incremental, approximate database queries and uncertainty for exploratory visualization, in Proceedings of the 2011 IEEE Symposium on Large Data Analysis and Visualization (LDAV), Providence, 2011, pp. 73–80

    Google Scholar 

  14. C.D. French, Teaching an OLTP database Kernel advanced data warehousing techniques, in Proceedings of the Thirteenth International Conference on Data Engineering, ICDE ’97, Washington, D.C. (IEEE Computer Society, 1997), pp. 194–198

    Google Scholar 

  15. Gartner, Gartner identifies the top 10 strategic technologies for 2012. Press Release, Oct 2011. Retrieved from http://www.gartner.com/it/page.jsp?id=1826214. Last accessed 15 June 2012

  16. J. Gray, P. Shenoy, Rules of thumb in data engineering, in Proceedings of the 16th International Conference on Data Engineering, San Diego (IEEE Computer Society, Washington, D.C., 2000), pp. 3–12

    Google Scholar 

  17. M. Grund, J. Krüger, H. Plattner, A. Zeier, P. Cudre-Mauroux, S. Madden, HYRISE: a main memory hybrid storage engine. Proc. VLDB Endow. 4(2), 105–116 (2010)

    Google Scholar 

  18. D. Hackenberg, D. Molka, W.E. Nagel, Comparing cache architectures and coherency protocols on x86-64 multicore SMP systems, in Proceedings of the 42nd Annual IEEE/ACM International Symposium on Microarchitecture, MICRO 42, New York (ACM, New York, 2009), pp. 413–422

    Google Scholar 

  19. S. Harizopoulos, D.J. Abadi, S. Madden, M. Stonebraker, OLTP through the looking glass, and what we found there, in Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data, SIGMOD ’08, New York (ACM, 2008), pp. 981–992

    Google Scholar 

  20. B. Inmon, Budgeting for the data warehouse. BeyeNetwork Article, June 2004. Retrieved from http://www.b-eye-network.com/view/141. Last accessed 15 June 2012

  21. Intel, An introduction to the Intel QuickPath Interconnect. White paper, Jan 2009. Document Number: 320412-001US

    Google Scholar 

  22. A. Kemper, T. Neumann, One size fits all, again! The architecture of the hybrid OLTP & OLAP database management system HyPer, in Enabling Real-Time Business Intelligence, ed. by M. Castellanos, U. Dayal, V. Markl, W. Aalst, J. Mylopoulos, M. Rosemann, M.J. Shaw, C. Szyperski. Volume 84 of Lecture Notes in Business Information Processing (Springer, Berlin/Heidelberg, 2011), pp. 7–23

    Google Scholar 

  23. R. Kimball, M. Ross, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence (Wiley, Indianapolis, 2010)

    Google Scholar 

  24. G. Koch, Discovering multi-core: extending the benefits of Moores law. Technology@Intel Magazine. Intel Corporation, Tech. Rep. (2005)

    Google Scholar 

  25. J. Krüger, C. Kim, M. Grund, N. Satish, D. Schwalb, J. Chhugani, H. Plattner, P. Dubey, A. Zeier, Fast updates on read-optimized databases using multi-core CPUs. Proc. VLDB Endow. 5(1), 61–72 (2011) VLDB Endowment.

    Google Scholar 

  26. B.G. Lindsay, Jim Gray at IBM: the transaction processing revolution. ACM SIGMOD Rec. 37(2), 38–40 (2008). ACM, New York

    Google Scholar 

  27. P. Loos, J. Lechtenbörger, G. Vossen, A. Zeier, J. Krüger, J. Müller, W. Lehner, D. Kossmann, B. Fabian, O. Günther, R. Winter, In-memory databases in business information systems. Bus. Inf. Syst. Eng. 3(6), 389–395 (2011)

    Article  Google Scholar 

  28. D.T. Marr, F. Binns, D.L. Hill, G. Hinton, D.A. Koufaty, J.A. Miller, M. Upton, Hyper-threading technology architecture and microarchitecture. Intel Technol. J. Hyper-Threading Technol. 06(1), 4–15 (2002)

    Google Scholar 

  29. J. McKendrick, A new dimension to data warehousing: 2011 IOUG data warehousing survey. Produced by Unisphere Research, a Division of Information Today, Inc, Sept 2011. Research Analyst Report.

    Google Scholar 

  30. G.E. Moore, Cramming more components onto integrated circuits. Electronics 38(8), 114–117 (1965)

    Google Scholar 

  31. R. Nambiar, M. Poess, Transaction performance vs. Moores law: a trend analysis, in Performance Evaluation, Measurement and Characterization of Complex Systems, ed. by R. Nambiar, M. Poess. Volume 6417 of Lecture Notes in Computer Science (Springer, Berlin/Heidelberg, 2011), pp. 110–120

    Google Scholar 

  32. M.L. Neufeld, M. Cornog, Database history: from dinosaurs to compact discs. J. Am. Soc. Inf. Sci. 37(4), 183–190 (1986). Wiley, New York

    Google Scholar 

  33. H. Plattner, SanssouciDB: an in-memory database for processing enterprise workloads, in 14. GI-Fachtagung Datenbanksysteme für Business, Technologie und Web (BTW), ed. by T. Härder, W. Lehner, B. Mitschang, H. Schöning, H. Schwarz. Volume 180 of LNI, Kaiserslautern (GI, 2011), pp. 2–21

    Google Scholar 

  34. N. Raden, Business intelligence 2.0: simpler, more accessible, inevitable. InformationWeek. Intelligent Enterprise 1 (2007)

    Google Scholar 

  35. J.F. Rockart, The changing role of the information systems executive: a critical success factors perspective. Sloan Manag. Rev. 24(1), 3–13 (1982). Fall

    Google Scholar 

  36. M.G. Shields, E-business and ERP: rapid implementation and project planning (Wiley, New York, 2001)

    Google Scholar 

  37. A. Shoshani, Statistical databases: characteristics, problems, and some solutions, in Proceedings of the 8th International Conference on Very Large Data Bases, VLDB ’82, Mexico (Morgan Kaufmann, San Francisco, 1982), pp. 208–222

    Google Scholar 

  38. A. Shoshani, F. Olken, H.K.T. Wong, Characteristics of scientific databases, in Proceedings of the 10th International Conference on Very Large Data Bases, VLDB ’84, Singapore (Morgan Kaufmann, San Francisco, 1984), pp. 147–160

    Google Scholar 

  39. A. Shukla, P. Deshpande, J.F. Naughton, K. Ramasamy, Storage estimation for multidimensional aggregates in the presence of hierarchies, in Proceedings of the 22th International Conference on Very Large Data Bases, VLDB ’96, Bombay (Morgan Kaufmann, San Francisco, 1996), pp. 522–531

    Google Scholar 

  40. H. Sutter, The free lunch is over: a fundamental turn toward concurrency in software. Dr. Dobb’s J. 30(3), 202–210 (2005)

    Google Scholar 

  41. P. Youngworth, OLAP spells success for users and developers. Data Based Advis. 13(11), 38–49 (1995). Data Based Advisor, Escondido

    Google Scholar 

  42. Thomas Zurek and Markus Sinnwell, Datawarehousing has more colours than just black & white, in Proceedings of the 25th International Conference on Very Large Data Bases, VLDB ’99, Edinburgh, ed. by M.P. Atkinson, M.E. Orlowska, P. Valduriez, S.B. Zdonik, M.L. Brodie (VLDB Endowment, 1999), pp. 726–729

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Hasso-Plattner-Institute, University of Potsdam, Potsdam, Germany

    Anja Bog

Authors
  1. Anja Bog
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Bog, A. (2014). Introduction. 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_1

Download citation

Publish with us

Policies and ethics

Search

Navigation