Benchmark Overview - WGierke/tuk1_numa_a GitHub Wiki

Simple Operations: Col vs Row Access (Local vs Remote)

Minimum table setup: 100Cols, >= 1Mio. Entries

Sequential cols: access 1, 2, 4, 8 cols Random rows: access 10, 100, 1000 rows

Baseline:

• Table with 100 columns (32-bit int) and 1M entries

Sequential Access (OLAP)

• Parameter 1: Number of read local columns (1, 2, 4, 8)

or

• Parameter 1: Number of read remote columns (1, 2, 4, 8)
• Bonus: Parameter 2: Number of entries in table (10M, 100M, 1000M)

Random Access (OLTP)

Fixed Number of selected columns (should probably be all (100) Cols) Compare local vs remote:

• Parameter 1: Number projected rows (1, 10, 100, 1000)

Complex Operations: Join

Baseline:

• Table 1: 100 columns (32-bit int) and 10M entries
• Table 2: 10 columns (32-bit int) and varying numbers of entries

Hash Join:

Join on 1

• Parameter 1 - Table 1: 100 columns, Number of entries in table (10M)
• Parameter 2 - Table 2: 10 columns, Number of entries in table (2k, 20k, 200k, 2M)
• Parameter 3: Distint values within table corresponding to entries in Table 2 (1k, 10k, 100k, 1M)
• Parameter 4 - Location:

1. local-local
2. local-remote (copy to local / do not copy to local)
3. remote-remote (copy both to local, copy 1 to another, do not copy)

--> (1 * 4 * 3 = 12 Benchmarks in total)

Bonus: More entries (e.g. 100M and 20M)