English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Zendy Plus

Presents the access of premium content as premium feature

Premium Content

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Zendy Tools

Zendy Open

There has been significant amount of excitement and recent work on GPU-baseddatabase systems. Previous work has claimed that these systems can performorders of magnitude better than CPU-based database systems on analyticalworkloads such as those found in decision support and business intelligenceapplications. A hardware expert would view these claims with suspicion. Giventhe general notion that database operators are memory-bandwidth bound, onewould expect the maximum gain to be roughly equal to the ratio of the memorybandwidth of GPU to that of CPU. In this paper, we adopt a model-based approachto understand when and why the performance gains of running queries on GPUs vson CPUs vary from the bandwidth ratio (which is roughly 16x on modernhardware). We propose Crystal, a library of parallel routines that can becombined together to run full SQL queries on a GPU with minimal materializationoverhead. We implement individual query operators to show that while thespeedups for selection, projection, and sorts are near the bandwidth ratio,joins  achieve less speedup due to differences in hardware capabilities.Interestingly, we show on a popular analytical workload that full queryperformance gain from running on GPU exceeds the bandwidth ratio despiteindividual operators having speedup less than bandwidth ratio, as a result oflimitations of vectorizing chained operators on CPUs, resulting in a 25xspeedup for GPUs over CPUs on the benchmark.

A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics (Extended Version)