Database Schema Variants for Mixed OLTP and OLAP

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.