Real-time database systems software developer McObject today announced test results that show remarkable performance benefits for in-memory database systems (IMDSs) with transaction logging over disk-based database management systems. The results also disprove the claim that adding recoverability to an IMDS eradicates its performance edge over conventional database management systems (DBMSs).
In-memory database systems are much quicker than traditional DBMSs, which rely on slower persistent storage. Users are sometimes put off IMDS, because of the higher risk of keeping records on RAM. Transaction logging responds to this issue by allowing recovery in the case of system failure. Cynics have stated that the persistent storage needed to keep the transaction log contradicts the purpose of an IMDS, countering any performance benefits.
For the test, McObject compared the performances of an on-disk DBMS and an IMDS with transaction logging, using numerous storage devices. For latency-prone operations, the IMDS with transaction logging storing its transaction log on a hard disk drive outshone the traditional DBMS using hard disk drive storage. The findings were even more impressive when using state-of-the-art flash memory technology from Fusion-io. Changing the in-memory database system hard drive for a Fusion ioDrive will see a speed of 15.33x over disk-based DBMS.
Tyler Smith, Fusion-io Vice President of Alliances, commented “In the financial services market, near real-time performance can lead to greater success, but that performance cannot sacrifice data security, so transaction logging solutions like eXtremeDB and Fusion ioMemory can ensure customers have a comprehensive solution in place. We are pleased to work with McObject to achieve such impressive results, and we look forward to continuing to collaborate with innovative new companies to deliver ultra-low latency, flash memory performance for database applications.”
Steve Graves, Co-Founder and CEO of McObject, added “These tests have important implications for low-latency financial systems, chief among them are that you don’t need to sacrifice data durability in order to gain high performance.With transaction logging, financial systems gain recoverability yet still benefit from in-memory databases’ tremendous speed. The performance advantage of an IMDS with transaction logging turns out to be dramatic even using basic hard disk storage; by moving to Fusion-io’s state-of-the-art memory tier storage, financial systems can obtain an advantage that is truly game-changing.”
The company will issue a full report detailing the test process and findings. A preview is available now: financial.mcobject.com/IMDS+TL.