From: An experimental study of group-by and aggregation on CPU-GPU processors
Notation | Workload | L-I-C | C-I-C | L-S-C | L-S-G | C-S-C | C-S-G |
---|---|---|---|---|---|---|---|
W0 | uniform data, 2M | 0.51 | 1.30 | 0.34 | 0.40 | 0.54 | 0.37 |
W1 | uniform data, 32M | 12.07 | 17.56 | 9.78 | 2.22 | 14.25 | 2.56 |
W2 | uniform data, S = 211 | 0.11 | 0.23 | 0.13 | 0.40 | 0.13 | 0.33 |
W3 | uniform data, S = 221 | 3.80 | 10.33 | 5.95 | 0.45 | 7.02 | 0.47 |
W4 | skewed data, 2M | 0.74 | 0.33 | 0.34 | 1.51 | 0.63 | 0.39 |
W5 | skewed data, 32M | 5.51 | 5.88 | 22.51 | 62.62 | 54.08 | 38.08 |
W6 | skewed data, S = 211 | 0.08 | 0.11 | 0.11 | 0.51 | 0.12 | 1.44 |
W7 | skewed data, S = 221 | 2.28 | 4.32 | 2.56 | 14.60 | 7.95 | 9.37 |