Batchdb:efficient Isolated Execution of Hybrid Oltp+olap workloads for Interactive applications report

Source: Internet
Author: User
Tags mixed

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.