Benchmark Report on In-Memory Database Systems Performance

This benchmark report analyzes the performance of in-memory database systems (IMDSs), specifically focusing on their capabilities with very large databases (VLDBs). The report utilizes McObject’s 64-bit eXtremeDB technology to create a database of 1.17 terabytes and 15.54 billion rows on a high-performance 160-core SGI Altix 4700 server. It documents the time required for database provisioning, backup, and restore, and presents benchmark results that indicate query transaction rates reaching up to 87.78 million transactions per second. The report examines the efficiency of utilizing all 160 processors during tests and includes the full database schema along with relevant application source code. Additionally, it discusses the goals of the benchmark, including demonstrating efficient provisioning of a terabyte-sized database and maintaining nearly linear performance scalability across multiple CPU cores. The findings contribute valuable insights into the operational limits and performance characteristics of IMDS technology.