Jedox GPU Accelerator FAQ

image_pdfimage_print

Related links: Jedox GPU Accelerator, Requirements of Jedox GPU Accelerator, Installation of Jedox GPU Accelerator

General

Why should I use Jedox GPU Accelerator?
What is the speedup over CPU?
How can I test the speedup for my model/reports?
Is there a special license required for testing?
What exactly is accelerated with Jedox GPU Accelerator?
Are there best practices with regard to cube design?
Can Jedox GPU Accelerator also speed up my ETL process?

Hardware

What kind of hardware is recommended?
Can I use Jedox GPU Accelerator with any NVIDIA graphics card?
How should GPUs be connected on the system mainboard?
Can I test Jedox GPU Accelerator in the Cloud?
Does the Jedox GPU Accelerator run on non-NVIDIA graphics chips or other parallel architectures, such as the Intel Xeon Phi?

 

General

Why should I use Jedox GPU Accelerator?

Today’s graphics cards (GPUs) are capable of processing large data volumes in parallel much faster than CPUs. Calculations in OLAP, such as aggregations, rule functions, and filters, can be significantly accelerated if run on a graphics card, reducing time from minutes to milliseconds. Whenever the same arithmetic operation can be applied on large amounts of data (thousands or millions of cells), then the GPU processing power is fully utilized, and significant speedups over conventional processing with a CPU can be expected. Top

 What is the speedup over CPU?

Current measurements show an average speedup of factor 5 to 10 compared to the CPU version of the Jedox In-Memory DB Server. However, there is no general answer to this question, because of the nature of each particular query and uniqueness of each particular data model. In best-case scenarios, speedup can be much higher, e.g. 70 times faster on GPU, but in worst-case scenarios, there is very little or no speedup whatsoever. For this reason we recommend testing your model/reports on a GPU-enabled server before purchasing GPUs or GPU licenses. For details on how to test your model, see the next question. Top

 How can I test the speedup for my model/reports?

We suggest using the GPU Accelerator Advisor that is implemented in Jedox Excel Add-in to determine the GPU recommendation level for a specific cube (for details see Jedox GPU Accelerator Advisor). If the result shows a potential for speedup, then the next step can be either of the following:

  • Test Jedox GPU Accelerator on Azure NC instances
  • Use a comparable consumer GPU (e.g. NVIDIA GeForce GTX 1080 or NVIDIA Titan X) and test on your own server. As of Jedox 7.0, non-Tesla™ GPUs are supported for testing purposes (viable support). Note that non-Tesla™ GPUs have a driver-side CUDA kernel execution timeout (normally 5 seconds) that can reached in extremely computation-intensive operations, such as aggregations or dimension filters. This timeout might be configurable, but Jedox does not provide any support for these types of configuration changes.
  • Contact our GPU support team (support@jedox.com) to arrange a trial on our test servers (equipped with state-of-the-art GPUs). Top
 Is there a special license required for testing?

No, you can use the 30-day Jedox test license that comes with the Jedox Trial Version to utilize up to two GPUs. Top

 What exactly is accelerated with Jedox GPU Accelerator?

Fully accelerated operations are:

  • aggregation (SUM, MAX, MIN, AVG, CNT)
  • data filters (ANY, ALL, MAX, MIN, SUM, AVG)
  • rules (arithmetic operations, IF statements, PALO.DATA)
  • accessing attribute cubes (numerical values)
  • all writeback operations

Some features are not processed on GPU yet, such as:

  • functions on element names or dimension names
  • functions that manipulate strings
  • operations on string cells

However, this is transparent for users; i.e., GPU processing is automatically applied whenever suitable, and CPU processing takes over elsewhere.

Note that cube layout changes cannot yet be performed on GPU-activated cubes. Top

 Are there best practices with regard to cube design?

As a general rule of thumb, arrange dimensions according to their sizes (base element count) and start with the smallest one as the first dimension in the cube. Time dimensions and dimensions that are typically reduced to base level in reports (high selectivity) should also be placed among the first dimensions. A dimension that is heavily used in B:Rules is also a candidate to be placed among the first dimensions. Top

Can Jedox GPU Accelerator also speed up my ETL process?

Generally not, because only In-Memory DB Server operations are accelerated. However, much of the time spent in ETL processes is typically consumed by the In-Memory DB Server performing READ and WRITE requests. If the processing of the READ requests are the bottleneck (e.g. large aggregations, B:Rule calculations, etc.), then the ETL process can indirectly profit from In-Memory DB Server acceleration, because those requests will be performed faster. Top

 

Hardware

 What kind of hardware is recommended?

We recommend the latest generations of NVIDIA Tesla™ series, particularly Tesla™ V100 (32GB) or P100 (16GB). It is possible to utilize multiple GPUs as long as they are of the same type. For the graphics card(s), you should consider their memory size with regard to the amount of data to be processed (see next question).  Top

 Can I use Jedox GPU Accelerator with any NVIDIA graphics card?

Jedox GPU Accelerator supports all NVIDIA Tesla™ graphics cards with Compute Capability (CC) 3.0 or later.  Non-Tesla™ GPUs are supported for testing purposes (viable support), such that any CUDA-capable NVIDIA GPU can be used (again, at least CC 3.0 is required).

You can check the Compute Capability of specific models here: https://developer.nvidia.com/cuda-gpus  Top

 

 How should GPUs be connected on the system mainboard?

We recommend connecting the graphics card to undivided 16-bit PCI slots. We also recommend connecting all graphics cards on a single PCIe bus controller. This practice helps to avoid data transfer congestion and/or data having to take detours over main system memory when transferring from and into the memory of GPU. Top

Can I test Jedox GPU Accelerator in the Cloud?

Yes. Jedox provides pre-installed cloud instances with GPUs for testing and proof-of-concept implementations. l  Top

Does the Jedox GPU Accelerator run on non-NVIDIA graphics chips or other parallel architectures, such as the Intel Xeon Phi?

Jedox GPU Accelerator employs the CUDA parallel computing platform by NVIDIA; therefore, NVIDIA graphics cards are required. Other graphics chips or parallel architectures are currently not supported. Top

image_pdfimage_print