Abstract
As discussed in Sect. 2.2, a database design optimized for OLAP degrades the performance of OLTP queries and vice versa. If OLTP and OLAP workloads are to be consolidated onto one system, the question of how to design the database arises. Optimizations of the dedicated OLTP and OLAP systems that have evolved in the past might still be applicable to tune the performance of systems under mixed OLTP and OLAP workloads.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Bibliography
M. Grund, P. Cudré-Mauroux, J. Krüger, S. Madden, H. Plattner, An overview of HYRISE – a main memory hybrid storage engine. IEEE Data Eng. Bull. 35(1), 52–57 (2012)
D.D. Zilio, D.C. Zilio, J. Rao, S. Lightstone, G. Lohman, A. Storm, C. Garcia-arellano, S. Fadden, DB2 design advisor: integrated automatic physical database, in Proceedings of the Thirtieth international conference on Very Large Data Bases, Toronto, ed. by M.A. Nascimento, M.T. Özsu, D. Kossmann, R.J. Miller, J.A. Blakeley, K.B. Schiefer. Volume 30 of VLDB ’04 (VLDB Endowment, 2004), pp. 1087–1097
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Bog, A. (2014). Database Schema Variants for Mixed OLTP and OLAP. 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_5
Download citation
DOI: https://doi.org/10.1007/978-3-642-38070-9_5
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)