The Universal Cache capability in solidDB^® is a solution for speeding up traditional disk-based databases. It incorporates a high-speed solidDB^® in-memory database that caches performance-critical data from a disk-based database. The in-memory cache allows the processing of the application load by a fraction of the response time it takes to be executed in the backend database. This improves performance, speed, and latency.

The architecture of Universal Cache is based on three main components: the solidDB^® (in-memory) database (cache), a relational database server (backend), and the IBM Infosphere CDC data synchronization software that copies data to and from the cache and the backend.

To use Universal Cache, you must first identify the data you want to cache and configure the environment accordingly. The data can then be loaded from the backend database to the cache, so that when applications run against the cache database, they can take advantage of high performance and low latency of the solidDB^® server. As changes are made to the data, the IBM Infosphere CDC replication technology synchronizes data between the cache database and the backend database. Additionally, the SQL passthrough functionality enables applications to access data in both databases with a single interface.

The Universal Cache includes both graphical and command-line tools and utilities for installing, configuring, and administering the Universal Cache environment.

dminstancemanager and dmsubcriptionmanager are command-line utilities that make it possible to script IBM Infosphere CDC instance and subscription management.