Select Page

In-memory and Persistent Database Management Systems

What is a persistent database, and how is it different?  The answer below explains first what an in-memory database is, then, in the next paragraph, how a persistent database differs. 

What is an in-memory database system?

An in-memory database system (IMDS) is a database management system that stores data entirely in main memory. This contrasts to traditional (on-disk/persistent) database systems, which are designed store data on persistent media. Because working with data in memory is much faster than writing to and reading from a file system, IMDSs can perform applications’ data management functions orders of magnitude faster. Because their design is typically simpler than that of persistent database systems, IMDSs can also impose significantly lower memory and CPU requirements.

Learn how to tell the difference between real and imitation in-memory database systems, and why it matters.

Features to reduce memory consumption in embedded systems.

Features to look for if speed matters to your project

Simple architecture of in-memory database system.

What is a persistent database system?

In contrast, on-disk or persistent database systems cache frequently requested data in memory for faster access, but write database updates, insertions and deletes through the cache to be stored to disk. On the plus side, byte-for-byte, disk storage can be cheaper than RAM, and can also take less physical space when form factor is a consideration (e.g. handheld electronics).

A hybrid of the two

With some database systems, databases can be stored all-in-memory, all-persistent, or have a mix of in-memory tables and persistent tables. This flexibility enables developers to tailor data management in order to optimize applications for speed and persistence, and make intelligent trade-offs between cost-efficiency, power consumption, and physical space-conserving data storage hardware.

eXtremeDB can combine in-memory and on-disk in a single database instance with a simple database schema declaration.  Learn more.

Chart of message path and data transfers in a persistent database system.

Message path and data transfers in a persistent database system.

Using a true in-memory database system is critical to getting all the benefits from a hybrid solution. Understanding the distinction is critical to determining the performance, cost and ultimately the success or failure of a solution.  Learn how to tell the difference between real and imitation in-memory database systems, and why it matters in our white paper: Will the Real IMDS Please Stand Up?

An in-memory database with transaction logging retains the high performance read characteristics and provides tune-able persistence while retaining much of the in-memory database insert/update/delete performance advantage.

eXtremeDB offers these options.  Learn more about our hybrid database options.

In-memory and persistent database systems can be either embedded or client/server. 

Learn more about the eXtremeDB in-memory and persistent database management system.

Learn about eXtremeDB for embedded and/or client/server

eXtremeDB named Outstanding Structured Database in the Big Data Excellence Awards

Read the press release

McObject Wins IoT Vendor of the Year Award

Read the press release