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 CPU @ 2.60GHz, 16 GB RAM, SSD |
ANALYZE on table |