In this paper we present BATCHDB, a in-memory database engine designed for hybrid OLTP and OLAP workloads. BATCHDB achieves good performance, provides a high level of data freshness, and minimizes load interaction between the TRA Nsactional and analytical engines, thus enabling real time analysis over fresh data under tight SLAs for both OLTP and OLA P workloads.
This article describes a memory database engine specifically designed for mixed OLTP and OLAP workloads, BATCHDB has good performance, and provides high levels of data freshness, minimizing the interaction load between the transaction and the analysis engine. This enables real-time analysis of real-time data for OLTP and OLAP work under a compact SLA.
BATCHDB Features
relies on primary and secondary replica structures, optimizes OLTP and OLAP-specific loads, and transactional updates for lightweight transmissions. The assessment shows that for standard tpc-c and tpc-h benchmarks,
When providing the isolation level and running time for predicting OLTP and OLAP mixed transactions, BATCHDB can provide good performance for transactional and transactional analysis through a dedicated engine. The primary replica processes the OLTP workload and updates it to a level two replica that handles OLAP workloads. In order to enable query processing of the most recent data for snapshot isolation, and to ensure minimal impact on query performance, query and update operations in an OLAP copy are queued and dispatched by batch, and the system works once on a batch. In addition, extracting from an OLTP replica updates an OLAP copy, resulting in a small overhead for the entire execution time.