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....
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
All data stored on disk, disk I/O needed to move data into main memory when needed.
Data is always persisted to disk.
Traditional data structures like B-Trees designed to store tables and indices efficiently on disk.
Virtually unlimited database size.
Support very broad set of workloads, i.e. OLTP, data warehousing, mixed workloads, etc.
In-Memory Databases
All data stored in main memory, no need to perform disk I/O to query or update data.
Data is persistent or volatile depending on the in-memory database product.
Specialized data structures and index structures assume data is always in main memory.
Optimized for specialized workloads; i.e. communications industry-specific HLR/HSS workloads.
Database size limited by the amount of main memory.