What is In-Memory DB?

In Traditional Database

• Ex : Oracle , MS-SQL.
• The database is a collection of Tables.
• Tables are stored in Disk.

• The disk is made up Iron plates.
• Whenever system sends a request to CPU, CPU sends a request to RAM, RAM to Disk and it fetches the data from disk, send back to RAM, then to the CPU, CPU to Front-End.

In-Memory Database.

• Ex: SAP-HANA.
• Collection of Tables in memory( RAM- Random Access Memory) is called as an In-Memory database.
• Tables are stored in RAM.
• RAM is made up of Transistors and capacitors.
• When content kept in Transistors and capacitors, it is hundred thousand times faster in processing data compare to Disk.

• Whenever System send a request to CPU, CPU sends a request to RAM, fetches data from RAM, send back to CPU, then CPU to Front-End.

Advantages of In-Memory Database

• RAM is hundred thousand faster processing data than Disk.
• Data is kept closure to CPU.