Solution Performance

IBM Informix* Warehouse Accelerator is an in-memory database accelerator for IBM Informix database server, which includes deep columnar and compression technology. Workload comprises of analytical queries on a set of unstructured sensor time series data.

Product and Performance Information


IBM Informix Warehouse Accelerator*: Analytical queries on a large set of sensor time series data, which originates from publicly available U.S. government data (NWIS - National Water Information System). The NoSQL data used in the workload represents periodic measurements (in 15 minute intervals) from more than 800 metering points over a period of roughly 100 years. This amounts to a total of more than 2.5 billion data records, each comprising the timestamp and multiple measurement values. The analytics workload performed on this data represents various aggregations typically done on time series data. Testing by IBM April 2017.
Baseline: 2S Intel® Xeon® processor E5-2699 v4, 2.2GHz, 22 cores, turbo and HT on, BIOS 0271.R00, 192GB total memory, 24 slots / 8GB / 1600 MT/s / DDR4 LRDIMM, 1 x 800GB Intel® SSD DC S3700, Red Hat Enterprise Linux* 7.3 kernel 3.10.0-514.16.1.el7.x86_64.
New: 2S Intel® Xeon® Platinum processor 8180, 2.5GHz, 28 cores, turbo and HT on, BIOS 86B.01.00.0412.020920172159, 192GB total memory, 12 slots / 16GB / 2677 MT/s / DDR4 LRDIMM, 1 x 800GB Intel SSD DC S3700, Red Hat Enterprise Linux* 7.3 kernel 3.10.0-514.16.1.el7.x86_64.


Benchmark results were obtained prior to implementation of recent software patches and firmware updates intended to address exploits referred to as "Spectre" and "Meltdown". Implementation of these updates may make these results inapplicable to your device or system. 

Software and workloads used in performance tests may have been optimized for performance only on Intel® microprocessors. Performance tests, such as SYSmark* and MobileMark*, are measured using specific computer systems, components, software, operations, and functions. Any change to any of those factors may cause the results to vary. You should consult other information and performance tests to assist you in fully evaluating your contemplated purchases, including the performance of that product when combined with other products. For more complete information visit