In-memory database

In memory database(IMDB) is a database management system, that primarily relies on main memory(RAM), where as usually database management systems primarily relies on secondar storage(Hard Disk). Main memory database systems works faster than normal database management systms.

Since main memory database systems store data in volatile memory (RAM), data is lost in case of power failures. In memory databases supports all three Atomicity, Consistency and Isolation properties.

Durability can be supported by IMDB, using various mechanisms.

1. Using Checkpoints

checkpoint provide a snapshot of the data within the database. By using check points and transaction logging IMDB systems can able to retrieve last consistent state.

2. Transaction Logging

Transaction log maintains history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. By using transaction logs we can redo transactions if a system failure occurs.

3. By using Non-volatile random-access memory technology

Non volatile random access memory retains its informaion even power turned off also.

In subsequent posts i am going to explain about in-memory database H2.

Prevoius                                                 Next                                                 Home