The solidDB^® in-memory database allows you to choose the optimal balance of maximum performance and the ability to handle large volumes of data by providing a unique dual-engine Database Management System (DBMS) architecture. Inside the database server, there are two engines: a main memory engine (MME) for fastest possible access to performance-critical data and a traditional on-disk engine for efficiently handling virtually any volume of data.

The solidDB^® main memory engine is built on solidDB^® disk-based engine and solidDB^® capabilities, which means that solidDB^® main memory engine inherits all functionality of these products. The solidDB^® main memory engine can be used in embedded systems, requiring virtually no administration or maintenance. You can make solidDB^® main memory engine suitable for highly available systems by deploying solidDB^® as a High Availability configuration. You can also deploy the Advanced Replication component, which enables multiple solidDB^® main memory engine and solidDB^® disk-based engine servers to share and synchronize data with each other.

This guide introduces you to the features that allow you to optimize your database server’s performance by using in-memory database technology.

This guide assumes the reader has general knowledge of relational database management systems and familiarity with SQL. This guide also assumes that the reader has basic familiarity with the solidDB^® product family. You should read the solidDB^® Administrator Guide prior to reading this guide. If you are not already familiar with relational databases, you should also read the solidDB^® Getting Started Guide and the solidDB^® SQL Guide first.