How does Altibase compare to Oracle’s database buffer cache?

Occasionally, we are asked why Altibase outperforms Oracle since Oracle uses a buffer cache to improve performance. Some say that the buffer cache resides in memory, and so it should perform equivalent to an in-memory database.

Altibase is faster than Oracle buffer cache because Altibase accesses a record directly by an operating system providing native memory pointer, whereas Oracle accesses a record indirectly through a logical Row ID (RID) using RID Oracle has to go through a buffer manager , a buffer page and a position of the record in the buffer page.

 

Altibase vs. Oracle’s Database Buffer Cache

Item

Altibase

Oracle Database Buffer Cache


Architecture

 4_How does Altibase In-Memory database compare to Oracle's database buffer cache-1-1  4_How does Altibase In-Memory database compare to Oracle's database buffer cache-1-2

INSERT

Speed

Faster

Slower

UPDATE

Speed

Faster

Slower

DELETE

Speed

Faster

Slower

SELECT

Speed

Faster

Slower

Data Access Method

Direct access by native memory pointer

Indirect access by logical Row ID

 

Comments are closed.