A Framework for Simulating Combined OLTP and OLAP Workloads

OLTP and OLAP systems are thought of as two different domains despite sharing the same base data set to operate on. The data set only differs in granularity and logical layout. Serious changes in the development of hardware and database systems have occurred since the separation of analytical systems from the transactional systems in the 1990's. As a result, the decision to set up a separate domain for OLAP applications has to be reconsidered. In this paper we propose a configurable simulation framework that can be used to validate existing database systems and their ability to handle both workloads in parallel. The framework uses a benchmark defined for a combined OLTP and OLAP workload based on real enterprise data.