result.md

Experiment Notes

TPC-H benchmarks contain 22 queries with different scale factors.

Results under scale factors

ID	SF1	SF8
1	4x10
2	460x8
3	11620x4
4	5x2
5	5x2
6	1x1
7	4x4
8	2x2
9	175x3
10	37967x8
11	1048x2
12	2x3
13	42x2
14	1x1
15	1x5
16	18314x4
17	1x1
18	57x6
19	1x1
20	186x2
21	411x2
22	7x3

Notes: (query output limit)

• q2: limit 100
• q3: limit 10
• q10: limit 20
• q18: limit 100
• q21: limit 100

Table cardinality

Table	SF1	SF10
nation	25	25
supplier	10,000	100,000
customer	150,000	1,500,000
part	200,000	2,000,000
partsupp	800,000	8,000,000
orders	1,500,000	15,000,000
lineitem	6,001,215	59,986,052

HyPer Online Execution Time

Time: ms (single thread)

ID	Compile Time	Execution Time	Higher Compile Time
1	93.92	133.16	No
2	179.45	6.96	Yes
3	136.08	97.83	Yes
4	96.25	75.36	Yes
5	148.92	60.53	Yes
6	39.37	32.89	Yes
7	155.53	72.37	Yes
8	155.18	60.80	Yes
9	155.42	141.83	Yes
10	127.46	70.29	Yes
11	133.60	13.62	Yes
12	96.85	79.95	Yes
13	129.35	255.84	No
14	60.16	41.61	Yes
15	106.60	44.78	Yes
16	146.89	59.45	Yes
17	153.20	69.62	Yes
18	161.56	220.42	No
19	90.59	199.48	No
20	133.93	33.37	Yes
21	148.94	132.35	Yes
22	134.43	31.14	Yes

MonetDB Execution Time on Sable-Intel

Time: ms (1 or 80 threads)

ID	Compile Time	Exe. T. (1th)	Exe. T. (80th)	Hyper's Exe. T.
1	N/A	1592	158.95	133.16
2	N/A	16.29	34.396	6.96
3	N/A	200.0	159.31	97.83
4	N/A	144.7	38.12	75.36
5	N/A	265.8	77.77	60.53
6	N/A	84.41	49.02	32.89
7	N/A	221.5	95.85	72.37
8	N/A	249.7	111.80	60.80
9	N/A	308.2	108.82	141.83
10	N/A	453.8	545.15	70.29
11	N/A	39.43	40.70	13.62
12	N/A	162.2	78.37	79.95
13	N/A	267.9	191.52	255.84
14	N/A	67.91	55.08	41.61
15	N/A	27.41	35.01	44.78
16	N/A	69.97	92.48	59.45
17	N/A	293.1	171.16	69.62
18	N/A	258.4	283.30	220.42
19	N/A	985.4	189.64	199.48
20	N/A	127.5	85.07	33.37
21	N/A	487.6	1196.74	132.35
22	N/A	121.6	80.51	31.14

Data path: /mnt/local/script-tpch/temp

• Script: runtemp
• Log file: summary-thread-1.log, summary-thread-80.log
• Note: workspace is on ../