IBM solidDB

Features and benefits of IBM solidDB
IBM® solidDB™ is relational in-memory database software that delivers extreme speed, performing up to ten times faster than conventional databases. It uses the familiar SQL language to allow applications to achieve throughput of tens-to-hundreds of thousands of transactions per second with response times measured in microseconds, also providing applications extreme data availability with sub-second failover.

Highlights

• Achieves Extreme Speed with In-Memory Database Technology

• Keeps Data Persistent and Recoverable

• Provides Extreme Availability

• Combines High Availability and Extreme Speed

• Balances Data Safety, Application Throughput and Recovery Time

• Lowers costs

Achieves Extreme Speed with In-Memory Database Technology
solidDB delivers extreme speed because it keeps data in main memory at all times rather than on disk. Applications can take advantage of its capability through standard ODBC, JDBC, SQL interfaces. solidDB works under the premise that all data to be accessed will be in main memory, all the time. Thus, it has data structures and access methods specifically designed for storing, searching, and processing data in main memory, with efficient concurrency control mechanisms. This has two performance advantages over conventional, disk-based databases. First, solidDB eliminates the need to transfer data blocks from disk to main memory. This is because any data requested by the application is already in main memory. Second, solidDB is faster than disk-based databases, even if the latter cache all data in main memory, since solidDB employs data structures and access methods that are optimized for main memory access.

Keeps Data Persistent and Recoverable
While solidDB works under the premise that all data is accessible in main memory, all the time, solidDB also writes updated data to disk, and uses checkpointing and transaction logging mechanisms so that the recoverability of the data is ensured.

Provides Extreme Availability
solidDB delivers extreme availability enabling applications to recover from system failures in less than a second providing the extreme data availability required by performance-critical applications. Using a two-node, hot-standby configuration, solidDB maintains copies of the data synchronized between two solidDB nodes.

Combines High Availability and Extreme Speed
solidDB can boost performance even further by providing a hot-standby configuration where read operations can be load-balanced across primary and hot-standby solidDB instances transparently to the application. To take advantage of load balancing, an application uses solidDB's ODBC or JDBC drivers that maintain only one logical connection to both primary and hot-standby solidDB instances. In this configuration, write transactions are automatically directed to the primary solidDB node, and read transactions can be directed either only to the hot-standby solidDB node, or load-balanced across primary and hot-standby solidDB instances, without application developers having to write code. Using load-balancing can yield up to a 100% performance improvement, while hot-standby configuration also provides high availability of solidDB nodes with subsecond failover in the event of a failure.

Balances Data Safety, Application Throughput and Recovery Time
solidDB offers several high availability configuration options that specify how primary and secondary database servers are synchronized, which can be selected at the system, session and transaction levels. This enables you to balance throughput, durability, and recovery time with unprecedented flexibility.

Lowers costs
The extreme speed and extreme availability of solidDB address the need for businesses to always keep data available and accessible, avoiding the costs associated with both planned and unplanned outages and delays. solidDB further reduces costs because it can be controlled by the application and run virtually unattended, letting businesses accelerate deployments and reduce administrative costs resulting in a lower total cost-of-ownership. Furthermore, because solidDB can run on commodity as well as best-of-breed hardware, it provides you with a variety of proven, cost-effective solutions.