In a new benchmark report, McObject’s eXtremeDB-64 in-memory 64-bit embedded database, pushes past the known boundaries of in-memory database system (IMDS) scalability and performance, demonstrating IMDSs’ breakthrough responsiveness as well as their ability to grow to a size that is well within the range of corporate on-disk very large databases (VLDBs).
The benchmark results, obtained on a 160-core SGI® Altix® 4700 server running Louisiana Immersive Technologies Enterprise (LITE), at the Research Park of the University of Louisiana at Lafayette, has important implications for organizations that are augmenting their IT infrastructure with new high-performance systems for time-sensitive, data-intensive tasks. These activities range from business intelligence to geospatial analysis, pharmaceuticals research and telecommunications routing.
The benchmark results indicate that IMDS technology meets the scalability requirements of this new category of application, and delivers dramatically faster query, join and subquery performance than is possible using on-disk databases. It also shows IMDSs can leverage the multi-core architectures becoming common in companies, university research labs, and government, with nearly linear scalability performance from a single processor core up to 160 cores.
In-memory database performance has been largely uncharted, and as a result, McObject’s test was able to replace certain predictions and beliefs about IMDSs with facts. One myth predicted a dramatic drop in IMDSs’ data Ingest (provisioning) efficiency as the database reached maximum size. If true, the drawback could have limited IMDSs’ practicality for applications requiring very large databases, because of the time required to load the database with data.
However, in McObject’s test, eXtremeDB-64’s per-row insert time increased only moderately as the database grew to one Terabyte and beyond, with average insert time increasing from 6.9 microseconds per row for the first quartile of data to 8.3 microseconds per row for the last quartile.
McObject has published its benchmark report on www.mcobject.com. for free download. In-Memory Database Systems (IMDSs) Beyond the Terabyte Size Boundary includes test results as well as query source code (using both SQL and the native eXtremeDB interface) and database schema from the benchmark application.
Key findings include:
• For a simple SELECT against the 1.17 Terabyte, 15.54 billion row database, eXtremeDB processed 87.78 million query transactions per second using its native application programming interface (API) and 28.14 million transactions per second using a SQL ODBC API. To put these results in perspective, consider that the lingua franca for discussing query performance is transactions per minute;
• In more complex JOIN operations, the benchmark report documents performance of 11.13 million operations per second with the native API, and 4.36 million operations per second using SQL ODBC;
• When provisioning the in-memory database with data, ingest performance between the first and last quartiles decreased by just 20 percent – much less than the precipitous drop-off that is often predicted for the later stages of populating a very large database (VLDB);
• Backup and restore functions for VLDB required just a fraction of the time needed for initial provisioning, suggesting the persistence needs of time-sensitive, data-intensive applications can be met without undue latency;
• Nearly linear scalability from a one processor up to 160 processor cores is possible, with some minor and unavoidable drop-off in scalability occurring for operations that involve a higher proportion of system “housekeeping”;
“McObject’s new benchmark report, In-Memory Database Systems (IMDSs) Beyond the Terabyte Size Boundary, provides further support for IMDSs’ value in real-time applications requiring rapid analysis of very large databases. This test-based evidence, coupled with the growing role IMDSs are already playing in the enterprise, laboratories and government agencies, paints a very bright future for this technology,” Steve Graves, McObject Co-founder and CEO, said.
“The test proved that eXtremeDB-64 can support an arbitrarily large number of concurrent processes/threads and deliver consistent performance. Performance levels were maintained as database size increased to uncharted territory for IMDSs. The performance observed was in line with results obtained with much smaller databases, given a processor clock speed of 1.6 Ghz,” Graves said.
"The McObject eXtremeDB in-memory database system has proven to be an excellent high-performing solution when coupled with the unparalleled scalability of the SGI Altix server platform for real-time in-memory database operations," said Ravi Pendekanti, Senior Director of Solutions Marketing, SGI.
About McObject’s eXtremeDB In-Memory Embedded Database
With eXtremeDB-64, McObject offers a highly scalable 64-bit database management system that meets the unique performance requirements and resource constraints of intelligent devices and real-time systems. eXtremeDB-64 provides critical data management features—including transactions, concurrent access, High Availability and a high-level data definition language—while maintaining a minimal code footprint. As an in-memory database system (IMDS), eXtremeDB-64 delivers the real-time responsiveness demanded in many application categories that cannot tolerate the response latency of on-disk database systems.
eXtremeDB-64 also provides sophisticated development capabilities, such as support for complex data and varied query methods, a powerful debugging environment including a self-diagnostic API that catches a wide range of common programming errors before they slip into runtime code, and optional XML and SQL interfaces.
Introduced in 2006, eXtremeDB-64 is the 64-bit version of McObject’s eXtremeDB in-memory database system. eXtremeDB-64 supports databases that are hundreds of times larger than the 32-bit version, providing a powerful new tool in fields such as finance, science, computer simulation, and game production that demand instantaneous sorting, retrieval and manipulation of massive databases.
Founded by embedded database and real-time systems experts, McObject offers proven data management technology that makes intelligent devices and real-time applications faster, more reliable and more cost-effective to develop and maintain. McObject counts among its customers industry leaders such as DaimlerChrysler, EADS, JVC, Tyco Thermal Controls, F5 Networks, CA, Motorola and Boeing. McObject, based in Issaquah, WA, is committed to providing innovative technology and first-rate services to customers and partners. The company can be reached at +1-425-831-5964, or visit www.mcobject.com.
McObject, eXtremeDB and eXtremeDB-64 are trademarks or registered trademarks of McObject LLC or its suppliers. SGI and Altix are registered trademarks of SGI in the United States and/or other countries worldwide. Novell is a registered trademark, and SUSE is a trademark of Novell, Inc. in the United States and other countries. All other company or product names mentioned herein are trademarks or registered trademarks of their respective owners.