Abstract
Only limited statements can be made concerning the ability of existing data management systems to handle a mixed OLTP and OLAP workload since they have so far been treated as separate domains and separate benchmarks were created. Existing benchmarks could be applied to a combined architecture for OLTP and OLAP by simply running the benchmarks in parallel. This would only lead to a partial picture of the actual performance of such a system measuring the effects of hardware resource contention as the benchmarks are running on their own distinguished sets of tables.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
in period = i.p.
Bibliography
A. Chmura, J.M. Heumann, Logical Data Modeling: What It Is and How to Do It (Springer, New York, 2005)
M. Frolick, T.R. Ariyachandra, Business performance management: one truth. Inf. Syst. Manag. 23(1), 41–48 (2006). Winter
S. Harizopoulos, V. Shkapenyuk, A. Ailamaki, QPipe: a simultaneously pipelined relational query engine, in Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, SIGMOD ’05, Baltimore (ACM, New York, 2005), pp. 383–394
R. Johnson, S. Harizopoulos, N. Hardavellas, K. Sabirli, I. Pandis, A. Ailamaki, N.G. Mancheril, B. Falsafi, To share or not to share? in Proceedings of the 33rd International Conference on Very Large Data Bases, VLDB ’07, Vienna (VLDB Endowment, 2007), pp. 351–362
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.
C.A. Lang, B. Bhattacharjee, T. Malkemus, S. Padmanabhan, K. Wong, Increasing buffer-locality for multiple relational table scans through grouping and throttling, in Proceedings of the 23rd International Conference on Data Engineering, ICDE’07, Istanbul, ed. by R. Chirkova, A. Dogac, M.T. Özsu, T.K. Sellis (IEEE, 2007), pp. 1136–1145
R.R. Lummus, R.J. Vokurka, Defining supply chain management: a historical perspective and practical guidelines. Ind. Manag. Data Syst. 99(1), 11–17 (1999). MCB University Press
P. Mertens, Integrierte Informationsverarbeitung 1, 17th edn. (Gabler, Wiesbaden, 2009)
MySQL 5.5 Reference Manual, Revision: 26779. Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065, July 2011
Object Management Group (OMG), Business process model and notation (BPMN). Specification, version 2.0, Jan 2011. Retrieved from http://www.omg.org/spec/BPMN/2.0/PDF. Last accessed 15 June 2012
D. Pfaff, B. Skiera, T. Weitzel, Financial-Chain-Management: Ein generisches Modell zur Identifikation von Verbesserungspotenzialen. Wirtschaftsinformatik 46(2), 107–117 (2004)
T.K. Sellis, Multiple-query optimization. ACM Trans. Database Syst. 13(1), 23–52 (1988). ACM, New York
G. Stewart, Supply chain performance benchmarking study reveals keys to supply chain excellence. Logist. Inf. Manag. 8(2), 38–44 (1995)
M. Zukowski, S. Héman, N. Nes, P. Boncz, Cooperative scans: dynamic bandwidth sharing in a DBMS, in Proceedings of the 33rd International Conference on Very Large Data Bases, VLDB ’07, Vienna, ed. by C. Koch, J. Gehrke, M.N. Garofalakis, D. Srivastava, K. Aberer, A. Deshpande, D. Florescu, C.Y. Chan, V. Ganti, C.-C. Kanne, W. Klas, E.J. Neuhold (VLDB Endowment, 2007), pp. 723–734
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Bog, A. (2014). Combined Transaction Processing and Reporting Benchmark. 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_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-38070-9_4
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38069-3
Online ISBN: 978-3-642-38070-9
eBook Packages: Business and EconomicsBusiness and Management (R0)