Solution Performance

Kingbase Analytics Database (KADB) is a distributed OnLine Analytics Processing (OLAP) database. The workload is specified by Kingbase to simulate a critical business scenario that needs near-real time processing, and runs concurrent SQL queries on a 1.5TB dataset.

Visit Kingbase.com ›

Challenges

The queries in KADB are usually I/O-bound. When customers desire high performance for near-realtime processing, the best way is to cache all the needed data in memory to reduce IO. However, this approach is currently limited by memory capacity, and can be cost-prohibitive for large datasets.

Solution

With Intel® Optane™ DC persistent memory (App Direct Mode), Kingbase can take advantage of the larger memory capacities per socket to store data closer to the CPU and eliminate the I/O bottleneck, while achieving better price-performance (see chart).1 2 3

Value

Improved price-performance: Kingbase customers will benefit from similar performance (being able to process almost the same number of transactions per second), at lower cost2, and while meeting SLA targets for the response time.

Product and Performance Information

1

Performance results are based on testing by Intel and Kingbase on 1/10/19 and may not reflect all publicly available security updates. No product or component can be absolutely secure.

2

Kingbase KADB* V3R2 (self-defined workload); OS: CentOS* 7.5 Kernel 4.19.13. Testing by Intel and Kingbase completed on Jan 10, 2019. Security Mitigations for Variants 1, 2, 3 and L1TF in place. 

BASELINE: 2nd Gen Intel® Xeon® Platinum processor 8260L, 2.3 GHz, 24 cores, turbo, and HT on, BIOS 1.0180, 1536GB total memory, 24 slots / 64GB / 2666 MT/s / DDR4 LRDIMM, 1 x 240GB / Intel® SSD Data Center (Intel® SSD DC) S4500 + 1 x 2TB / Intel® SSD DC P3520.

NEW: 2nd Gen Intel® Xeon® Platinum processor 8260L, 2.3 GHz, 24 cores, turbo, and HT on, BIOS 1.0180, 192GB total memory, 12 slots / 16GB / 2666 MT/s / DDR4 LRDIMM and 1536GB DCPMM, 12 slots/ 128 GB / 2666 MT/s Intel® Optane™ DC persistent memory, 1 x 240GB / Intel® SSD DC S4500.

Pricing Guidance as of March 31, 2019 & valid until Jun 29, 2019. Intel does not guarantee any costs or cost reduction. You should consult other information and performance tests to assist you in your purchase decision.

3

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 information go to www.intel.com/benchmarks.