SpatialNews.com Press Release
McObject Shows You Can Have Your In-Memory Database Performance and Durability/Recoverability, Too
McObject®, developer of innovative real-time database system software for embedded systems and real-time enterprise applications, today announced lab results that show significant performance benefits for in-memory database systems (IMDSs) with transaction logging over disk-based database management systems. The tests refute the myth that adding recoverability to an IMDS eliminates its performance edge over traditional database management systems (DBMSs).
In-memory database systems – which work with data in main memory – are faster than conventional DBMSs, because the latter rely on slower persistent storage. But some potential users shy away from IMDSs due to the higher volatility of keeping records in RAM. Transaction logging, which keeps a record of changes to the database, addresses this concern by enabling recovery in the event of system failure. Naysayers argue that the persistent storage required to keep this transaction log defeats the purpose of using an IMDS, and counters any performance gains.
In one of the first tests of its kind, and using database system software from its eXtremeDB® product family, McObject measured the performance of an on-disk DBMS against an IMDS with transaction logging (IMDS+TL) using a variety of storage devices. For the database operations most likely to induce latency, the IMDS+TL storing its transaction log on a hard disk drive (HDD) outperformed the conventional DBMS using HDD storage several times over (even with the disk-based DBMS employing caching to minimize I/O). The gains were even more dramatic using state-of-the-art flash memory technology from Fusion-io. Swapping the hard drive used by the in-memory database system to store log data with a Fusion ioDrive enabled the IMDS with transaction logging to turn in a stunning 15.33x speed advantage over the disk-based DBMS.
McObject will publish a report about the testing process, components and results. A preview of the results is available now at www.mcobject.com/imdstl.
Founded by embedded database and real-time systems experts, McObject offers proven data management technology that makes applications and devices smarter, more reliable and more cost-effective to develop and maintain. McObject counts among its customers industry leaders such BAE Systems, Siemens, Phillips, 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-888-8505, or visit www.mcobject.com.