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#
-
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.
-
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