solidDB® is a relational database server that combines the high performance of in-memory tables with the nearly unlimited capacity of disk-based tables.
Pure in-memory databases are fast, but strictly limited by the size of memory. Pure disk-based databases allow nearly unlimited amounts of storage, but their performance is dominated by disk access. Even if the computer has enough memory to store the entire database in memory buffers, database servers that are designed for disk-based tables can be slow because the data structures that are optimal for disk-based tables are far from being optimal for in-memory tables. The solidDB® solution is to provide a single hybrid database server that contains two optimized engines inside it:
▪The main-memory engine (MME) is optimized for in-memory access.
▪The disk-based engine (DBE) is optimized for disk-based access.
Both engines coexist inside the same server process, and a single SQL statement can access data from both engines.
solidDB® hybrid server architecture
In addition to a fully functional relational database server, solidDB® provides synchronization features that allow updated data in one solidDB® to be sent to one or more other solidDB® instances.
The solidDB® server can also be configured for high availability. The HotStandby component enables a secondary server (a standby server) to run in parallel with the primary server (an active server) and keep an up-to-date copy of the data in the primary server.
You can also link your client application directly to the database server routines for higher performance and tighter control over the server. The direct linking capabilities are called shared memory access (SMA) or linked library access (LLA).
