IBM has joined the in-memory database (IMDB) party after launching the IBM solidDB, which it claims will deliver data 10 times faster than a conventional relational database.

It is worth noting that in memory databases are not new technology, and IBM makes no secret of the fact that it has used the technology from Finnish company Solid Information Technology, which it acquired back in December 2007.

Solid made a name for itself selling an embedded database with an in-memory database engine (IMDB), which meant it could store and retrieve data from main memory, giving faster performance than traditional disk-based systems. This has made IMDBs popular for applications that require very fast processing times, such as routing calls in a phone network or trading stocks.

IBM solidDB version 6.1 can be deployed as a cache to IBM's main relational database products, namely DB2 and Informix Dynamic Server (IDS). Alternatively, it can also be deployed as a stand-alone in-memory database. Because it keeps data in main memory, IBM claims that solidDB support tens of thousands of transaction per second with microsecond response times.

To use solidDB as a cache for DB2 or IDS, the user identifies a set of database tables that would benefit from faster access. For example, the user may select only ten performance critical tables such as shopping cart management etc. Once these tables are specified in a schema in DB2 or IDS, the solidDB connector can load the data from DB2 or IDS and make it available to applications at "extreme speed."

Scale is achieved in that solidDB cache can be partitioned across multiple servers. For example a large customer database containing 1 million customers can be partitioned into four solidDB Cache instances (each storing 250,000 customers).

Reliability is promised thanks to a two node, hot standby configuration, which allows solidDB to maintain two copies of data that is synchronized at all times between the solidDB nodes.

"We offer high availability," said Paola Lubet, director of product marketing for IBM solidDB. "It can operate on two node environment, and transactions can shift over to second node in case of hardware failure, in less than one second."

But there is no doubt that IBM's rivals have already been involved in the IMDS market for some time now. Oracle, for example, acquired Solid Information Technology competitor TimesTen back in June of 2005. Open source IMDB competitors also exist, such as FastDB, MonetDB, H2, and HSQLDB. However, some feel that IBM;s late entry to this market is not much of a setback.