How is Altibase different from Columnar Database?
- Post by
- Altibase
- Date
- 2021-11-17
Columnar DB guarantees fast performance in tasks such as simple search, but it is difficult to develop because it does not support SQL. In addition, Columnar DB does not guarantee data processing integrity (Transaction ACID support). Because of all these reasons, there is a limit to its use in the core task of the enterprise.
Classification |
Altibase |
Columnar |
Data Store |
High-speed data store using memory is possible when inserting data |
Store in disk storage and then sync to memory, or, store in memory and then sync to disk storage Performance degradation occurs when a LOCK occurs at the time of synchronization |
Data Loading |
When DBMS starts, all data is loaded into memory, and parallel loading is used to reduce loading time |
When DBMS starts, defined column values are loaded in memory |
DML |
All the DMLs are executed in memory, ensuring high-performance transactions |
As the transaction processing unit of DML is ROW-based, performance degradation occurs due to the agent for storing changes in columns |
Select |
All the data is in memory When selecting, search only in memory |
The speed of select statement is different according to the business task |