Results for Exercise Sheet 12 (SPARQL)
Click "Edit (Text)" in the upper bar of this page and add your row to the table below, following the examples already there.
In the first column, write down your account name, or name1+name2 if you work in a group.
In the second column, write down the number of result rows for the query of Exercise 2.
In the third column, write down the runtime to process the query, in seconds (with exactly two digit of precision).
In the fourth column, write down the number of triples in your wikidata.tsv.
In the fifth column, write down whether you built an index for your database table or not.
In the sixth column, give a concise description about the specs of the machine you used.
In the seventh column, give a concise description about your further improvements in order to speed up the query time.
Name |
#Result Rows |
Runtime |
#Triples |
With DB Index? |
Machine Specifications |
Further Improvements |
pb1042 |
21 |
0.12s |
30,855,696 |
yes |
Intel i5-5 @ 2.00GHz; 32GB RAM; SSD |
ANALYZE on table |
rr186+in35 |
21 |
0.08s |
30,855,696 |
yes |
Intel i7-8 @ 1.80GHz; 8GB RAM; SSD |
ANALYZE on table |
sw540 |
21 |
0.05s |
30,855,696 |
yes |
Intel i7-9750H @ 1.60GHz; 32GB RAM; SSD |
ANALYZE on table |
mk1361 |
17 |
0.06s |
30,855,696 |
yes |
Intel i5-4300U @ 1.90GHz; 4GB RAM; SSD |
ANALYZE on table |
ta116 |
21 |
0.05s |
30,855,696 |
yes |
i5-6500 CPU @ 3.20GHz; 16GB RAM; SSD |
ANALYZE on table |
bw63 |
21 |
0.38s |
30,855,696 |
yes |
i5-7200U @ 2.50GHz; 8GB RAM; SSD |
ANALYZE on table |
jr74+tw246 |
21 |
2.68s |
30,855,696 |
yes |
i7-8565U @ 1.80GHz, 8 GB RAM, SSD (VM) |
ANALYZE on table |
aw221 |
21 |
9.99s |
30,855,696 |
No |
2,6 GHz 6-Core Intel Core i7, 16 GB RAM, SSD |
None |
mb925 |
21 |
21.61s |
5,000,000 |
yes |
Intel Core i7-4700MQ, 32 GB RAM, HDD |
None |
hc63 |
21 |
0.06s |
30,855,696 |
yes |
Intel Core i5-3 @ 2.60GHz; 16 GB RAM; SSD |
ANALYZE on table |
hd103+sa285 |
21 |
1.74s |
30,855,696 |
yes |
Intel i7-6700HQ @ 2.60GHz, 16 GB RAM, SSD |
ANALYZE on table |
rt53 |
21 |
2.09s |
30,855,696 |
yes |
AMD Ryzen 5 3600 @ 3.6GHz, 16 GB RAM; HDD, WSL |
ANALYZE on table |
ar479+ss1736 |
21 |
105.50s |
30,855,696 |
No |
Intel Core i7-7700HQ @ 2.8GHz, 8 GB RAM, SSD |
None |
ak482 |
21 |
0.19s |
5*10^6 |
No |
Intel(R) Core i5-5200U @ 2.20 GHz, 8GB RAM |
None |
ha86+kb368 |
21 |
0.05s |
30,855,696 |
yes |
Intel(R) Core(TM) i7-5700HQ CPU @ 2.70GHz, 16GB ddr3 ram, SSD |
ANALYZE on table |
mr427 |
21 |
0.87s |
30,855,696 |
yes |
Intel i5-5287U @ 2.90GHz; 8GB RAM; HDD |
ANALYZE on table |
sp317 |
21 |
69,64s |
30,855,696 |
yes |
Intel(R) Core(TM) i3-6006U CPU @ 2.00GHZ, 8GB RAM, SSD |
None |
ll190 |
21 |
0.03s |
30,855,696 |
yes |
AMD R5 1600 @ 3.7GHz; 32GB RAM; SSD |
ANALYZE on table (and PRAGMA optimize) |
ps504-sg490 |
21 |
0.09s |
30,855,696 |
yes |
Intel i5 @ 1.60GHz; 16GB RAM; SSD |
ANALYZE on table |
sr463 |
21 |
5.04s |
5,000,000 |
No |
Intel i5 @ 1.60GHz; 8GB RAM; SSD |
ANALYZE on table |
mt40 |
21 |
2.49s |
30,855,696 |
yes |
Intel(R) Core(TM) i5-6500 CPU @ 3.20GHz; HDD |
ANALYZE on table |
tb305 |
21 |
0.05s |
30,855,696 |
yes |
AMD Ryzen 7 3700X, 16 GB RAM, SSD |
ANALYZE on table |
ta93 |
21 |
0.15s |
30,855,696 |
yes |
Intel I7-4720HQ, 8 GB RAM, SSHD |
ANALYZE on table |
us58 |
21 |
18s |
30,855,696 |
no |
AMD Ryzen 5 1600X @ 4GHZ; 16 GB RAM; SSD |
None |
fs81 |
21 |
0.08s |
30,855,696 |
yes |
Intel Core i5-6200U @2.30GHz 8 GB RAM |
None |
rp79+tg97 |
21 |
0.03s |
30,855,696 |
yes |
AMD Ryzen 7 2700X, 32GB RAM, NVMe SSD |
ANALYZE on table |
mn228 |
21 |
0.25s |
30,855,696 |
yes |
i7-8750h, 32GB RAM |
ANALYZE on table |
pm187 |
21 |
1.14s |
30,855,696 |
yes |
Intel Core i7 3,3 GHz (Dual-Core); 16GB RAM; SSD |
ANALYZE on table |
sb655 |
21 |
0.06s |
30,855,696 |
yes |
Intel Core i7 2,6 GHz; 16GB RAM; SSD |
ANALYZE on table |
ms1415+nh198 |
21 |
15.77s |
30,855,696 |
No |
Intel Core i5 2520, 8GB RAM; SSD |
ANALYZE on table |
as1586-nh228 |
21 |
2.7s |
30,855,696 |
yes |
Intel Core i7 2,6 GHz; 16GB RAM; SSD |
None |
ka98 |
21 |
14.8s |
5,000,000 |
yes |
2,8 GHz Intel Core 2 Duo; 8GB RAM; SATA |
ANALYZE on table |