mysqldatabaseperformancehsqldb

Difference between In memory databases and disk memory database


Recently i heard about the concept of In memory database.

In any type of database we are finally storing the data in the computer,from there our program will get the data .How in memory database operations are fast when compared to the others.

Will the in memory database load all the data from the database into memory(RAM).

Thanks in advance....


Solution

  • An in-memory database (IMDB; also main memory database system or MMDB or memory resident database) is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems that employ a disk storage mechanism. Main memory databases are faster than disk-optimized databases since the internal optimization algorithms are simpler and execute fewer CPU instructions. Accessing data in memory eliminates seek time when querying the data, which provides faster and more predictable performance than disk.

    Applications where response time is critical, such as those running telecommunications network equipment and mobile advertising networks, often use main-memory databases.

    In reply to your query, yes it loads the data in RAM of your computer.

    On-Disk Databases

    In-Memory Databases