In-memory embedded database vendor McObject has just released lab results demonstrating the higher speed and data durability attained when its eXtremeDB IMDS is used with with the EMC XtremSF PCIe flash cards for transaction log storage.
McObject CEO Steve Graves said the benchmark tests demonstrate the speed advantage of eXtremeDB with transaction logging and EMC XtremSF increasing along with the number of concurrent processes, delivering scalability, high throughput and the ability to leverage up-to-date multi-processor/multi-core hardware.
He said the performance speedup is due to the fact that in-memory database systems eliminate the latency associated with traditional on-disk DBMSs.
“But some applications require a higher level of data durability (i.e. recoverability if volatile memory is disrupted),” he said. “As a solution, IMDSs offer transaction logging. But critics object that logging re-introduces the storage-related latency that builds slowness into on-disk DBMSs.” McObject’s benchmark tests refute this criticism, he said.
“For the database operations most likely to induce latency, the IMDS with transaction logging (IMDS+TL) storing its transaction log on a hard disk drive (HDD) outperformed the conventional DBMS using HDD storage by more than 5 times even with the disk-based DBMS employing caching to minimize I/O,”said Graves.
“In addition, dramatic gains were achieved when using EMC XtremSF server-based PCIe flash cards to store the transaction log. The technology enabled the IMDS+TL to achieve a 2,100% speed advantage over the on-disk DBMS.
A second phase of the benchmark tested involved measuring throughput while adding concurrent processes to interact with the database system and its storage. EMC and McObject’s tests using a traditional on-disk DBMS with EMC XtremSF technology demonstrate its capabilities in this area: with 2 processes running simultaneously, the benchmark application was able to complete 3.89 loops per millisecond; with 36 concurrent processes, this grew to 12.21 loops/ms – an increase of 314%.
When switching to the eXtremeDB IMDS with transaction logging, and using EMC XtremSF technology to store the transaction log, the rate of throughput increase was even more impressive – for a gain of 505%.
According to Ken Taylor, Director, EMC Emerging Technologies Product Division. the macro trends of mobile, social, cloud and big data are forming what is known as the third platform of IT, where the emergence of in-memory database architectures is in response to the high-frequency, low-latency demands of next generation applications for the third platform.