Database Theory: What is In-memory Database?

The In-memory database, also known as a Main-memory database. (IMDB or MMDB).
As a Database Architecture, I like this topic and implementation in which data reside in a main memory area.

What is In-memory database?

In-memory database is a one kind of database whose data is stored in main memory for faster response and quick retrieval. This all data are loaded into system memory in a compressed form.
The In-memory databases are faster than general disk based databases because it doesn’t require any Disk I/O operations. The internal optimization algorithms are also simpler and require few CPU instructions.

Why not RDBMS Database Caching?

Most of RDBMS products provide feature of database caching, but with the In-memory database, we should not have only one goal to avoid disk I/O. The database caching we can use only for reading data and for writing data it requires again disk I/O, even managing database cache is also quite difficult and it is also requires substantial memory and CPU.

If a system or main memory crash, what happened?

Once device power switched off, all stored information is also removed so we can say IMDB not support “durability” of the ACID property.

Most of the IMDB systems offer features like to take snapshots periodically and written to non-volatile media. If system crash or fail, database Rollback to last completed transaction.
We can also increase the durability of IMDB by adding one or more copy of the database.
We can also configure replication and failover procedure for IMDB systems.

What kind of applications typically uses In-memory database?

The IMDB system is one type of analytic database and used for read-only system. Generally it is used by Data warehouse and Data mart for historical data. The real-time embedded system also using an IMDB system for fast manipulation.
Other application like, IP-Network routing, telecom switching and DTH system are also using IMDB systems.

You can visit this reference to find list of IMDB Systems.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

2 Comments on "Database Theory: What is In-memory Database?"

Notify of

Sort by:   newest | oldest | most voted
Amit B
6 months 4 days ago

Nice Info!!

It would be lil better if you can explain with example.

Amit Bhardwaj