Skip to content

What is the biggest difference between Altibase and disk-based DBMS?#

Overview#

This document describes the biggest difference between In-Memory-based DBMS and Disk-based DBMS.

Version#

All the versions of Altibase

The biggest difference between In-Memory-based DBMS and Disk-based DBMS#

As a Hybrid DBMS, Altibase supports both In-Memory DB and Disk-based DB.

Differences from Altibase's In-Memory DB#

  1. When operating DBMS, the location where the database resides is different.

    • In a disk-based DBMS, the entire database resides on the disk and the necessary data is cached and managed in the memory buffer, whereas the in-memory DBMS is managed by residing the entire backup database on the disk in the main memory.

  2. There is a significant difference in performance.

    • Although almost the same in terms of functionality, in-memory DBMSs are about 4 to 10 times faster than disk-based DBMSs, depending on the operating environment.

    • Altibase was configured in three ways: Memory Only, Hybrid, and Disk Only, and five virtual simultaneous transactions that meet TPC-C standards

      (order transaction, payment transaction, shipping transaction, order status transaction, stock level transaction) were
      combined to measure online transaction processing performance. As a result, it showed higher performance than Disk DBMS.

Note

What is TPC-C?

C model of the benchmark standard that measures the processing performance of an online transaction processing (OLTP) system