1823
Comment:
|
2314
|
Deletions are marked like this. | Additions are marked like this. |
Line 8: | Line 8: |
||jm700 || 241 || 0.03s ||38,234,712 ||yes || Intel(R) Core(TM) i7-11700U CPU @ 4.80GHz || || ||jm700 || 241 || 7.26s ||38,234,712 ||no || Intel(R) Core(TM) i7-11700U CPU @ 4.80GHz || || |
||jm700 || 241 || 0.03s ||38,234,712 ||yes || Intel(R) Core(TM) i7-11700 CPU @ 4.80GHz || || ||jm700 || 241 || 7.26s ||38,234,712 ||no || Intel(R) Core(TM) i7-11700 CPU @ 4.80GHz || || |
Line 15: | Line 15: |
||kd130|| 229 || 24.97s || 38,234,712 || no || Intel® Core™ i5-7200U CPU @ 2.50GHz × 4, 8 GB RAM || || ||tk309 || 229 || 26.53s ||38,234,712 ||yes || Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz || || ||ha60 || 197 || 2.99s ||38,234,712 ||yes || Intel(R) Core(TM) i5-8265U CPU @ 1.60GHz, 15.3 GiB RAM || || ||gf52 || 229 || 248.83s ||38,234,712 ||yes || Intel(R) Core(TM) i5-7300HQ CPU @ 2.50GHz|| || ||mb791 || 197 || 12.64s ||38,234,712 ||no || AMD Ryzen 5 5600G @ 3.90GHz x 6 || || |
Results for Exercise Sheet 12 (SPARQL)
Click "Edit" 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.
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 digits 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 |
np1042 |
241 |
0.14s |
38,234,712 |
yes |
Intel(R) Core(TM) i5-7300U CPU @ 2.60GHz |
Analyze on table |
jm700 |
241 |
0.03s |
38,234,712 |
yes |
Intel(R) Core(TM) i7-11700 CPU @ 4.80GHz |
|
jm700 |
241 |
7.26s |
38,234,712 |
no |
Intel(R) Core(TM) i7-11700 CPU @ 4.80GHz |
|
cd100 |
229 |
22.93s |
38,234,712 |
no |
Intel(R) Core(TM) i7-10700F CPU @ 2.90GHz |
|
ak913 |
229 |
17.65s |
38,234,712 |
no |
Intel® Core™ i5-10300H CPU @ 2.50GHz × 8 |
|
hm132 |
229 |
136.34 |
38,234,712 |
yes |
Intel(R) Core(TM) i5-6200U CPU @ 2.30GHz |
|
ap367 |
229 |
1197.3s |
38,234,712 |
no |
Intel Core i7-8650U, 8 Core Processor, 16 GB RAM |
|
kn115 |
241 |
86s |
38,234,712 |
yes |
AMD Ryzen 5 3550H with Radeon Vega Mobile Gfx 2.10GHz |
|
kd130 |
229 |
24.97s |
38,234,712 |
no |
Intel® Core™ i5-7200U CPU @ 2.50GHz × 4, 8 GB RAM |
|
tk309 |
229 |
26.53s |
38,234,712 |
yes |
Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz |
|
ha60 |
197 |
2.99s |
38,234,712 |
yes |
Intel(R) Core(TM) i5-8265U CPU @ 1.60GHz, 15.3 GiB RAM |
|
gf52 |
229 |
248.83s |
38,234,712 |
yes |
Intel(R) Core(TM) i5-7300HQ CPU @ 2.50GHz |
|
mb791 |
197 |
12.64s |
38,234,712 |
no |
AMD Ryzen 5 5600G @ 3.90GHz x 6 |
|