March 26, 2013

The Emergence of IMDB Technology

Businesses as well as consumers demand that more information be placed at their fingertips. When using mobile devices such as iPhone and Android, people expect answers to their questions in seconds rather than minutes. This reality is driving the emergence of in-memory database (IMDB) technology.

With the low cost of memory, data is increasingly being moved to IMDBs, which can provide up to 10 times faster data access than traditional disk storage devices.

Until I glanced at the above Wikipedia link, I hadn't realized that IBM acquired solidDB in 2008. The solidDB database supports both IMDB technology and disk storage access. It's used in consumer hand-held devices as well as on UNIX, AIX, Linux and Windows servers.

Once the application connects to solidDB, a subset of data from the back-end database is stored in memory. That's the role of solidDB Universal Cache, which supports DB2 for z/OS as well as DB2 for LUW, Informix, SQL Server, Oracle and Sybase. Updated data is kept in sync using IBM Infosphere CDC (Change Data Capture).

For details on solidDB 7.0, check out these links:

* The list of products included with solidDB 7.0

* An overview of the architecture

* A list of supported back-end data servers 

Another good solidDB resource is the IBM Redbook, "IBM solidDB: Delivering Data with Extreme Speed" (published May 2011).

Is your company taking advantage of IMDB technology? Please share your experiences in comments.