|
Size: 2665
Comment:
|
Size: 4720
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 11: | Line 11: |
| ||mb930||10||4.25s||6.7 MB||48613696||yes||Virtual machine with Linux-Kernel 4.14.15 running on host configuration<<BR>>Intel i5-3570 CPU @ 3.40GHz; 8GB RAM; SSD; Linux-Kernel 4.14.15||None|| ||ht48||10||2.37s||1290 MB||48613696||yes|| I5-4258U @ 2.40GHz; 8GM RAM; SSD ||database file is loaded in memory|| |
||mb930 ||10 ||4.25s ||6.7 MB ||48613696 ||yes ||Virtual machine with Linux-Kernel 4.14.15 running on host configuration<<BR>>Intel i5-3570 CPU @ 3.40GHz; 8GB RAM; SSD; Linux-Kernel 4.14.15 ||None || ||ht48 ||10 ||2.37s ||1290 MB ||48613696 ||yes ||I5-4258U @ 2.40GHz; 8GM RAM; SSD ||database file is loaded in memory || |
| Line 16: | Line 16: |
| ||yb36 ||10 ||0.02s ||12.8 MB ||48613696 || yes ||Intel Xeon E3-1270v6 @ 3.8GHz; 64GB RAM; SSD || VM with program in a ramdisk (10.4GB) || ||ns202 ||10 ||3.64s ||154 MB ||48613696 || yes || AMD Ryzen 7 1800X @ 3.85 GHz; 8GB RAM; SSD || None || ||je113 ||10 ||0.09s ||15 MB ||48613696 || yes || Intel i7-8770K @ 3.2 GHz; 32GB RAM; NVMe SSD || None || ||ab717-my28 ||10 ||0.98s|| || 5000000 |||yes || Oracle VM 2 GB RAM|| None |
||yb36 ||10 ||0.02s ||12.8 MB ||48613696 ||yes ||Intel Xeon E3-1270v6 @ 3.8GHz; 64GB RAM; SSD ||VM with program in a ramdisk (10.4GB) || ||ns202 ||10 ||3.64s ||154 MB ||48613696 ||yes ||AMD Ryzen 7 1800X @ 3.85 GHz; 8GB RAM; SSD ||None || ||je113 ||10 ||0.09s ||15 MB ||48613696 ||yes ||Intel i7-8770K @ 3.2 GHz; 32GB RAM; NVMe SSD ||None || ||ab717-my28 ||10 ||0.32s ||3 MB ||48613696 ||yes ||Intel i7-565OU CPU @ 1.70 GHz 2.30 GHz; Oracle VM: 2 GB RAM ||None || ||vb128 ||10 ||21.06s ||11.9 MB ||48613696 ||no ||Intel i7-7700HQ @ 2.8 GHz; 8GB RAM; ||None || ||rb201 ||10 ||0.18s ||42.7 MB ||48613696 ||yes ||Intel i5-2520M @ 2.5 GHz; 4GB RAM; ||potato machine magic || ||fc54 ||10 ||6.03s ||31 MB ||48613696 ||yes ||Intel i5 @ 2.7 GHz; 8GB RAM; ||None || ||he41 ||10 ||0.17s ||11.1 MB ||48613696 ||yes ||Intel Core i5-6200U @ 2.30GHz; 4GB RAM; ||None || ||yl100 ||10 ||0.2s ||7.1 MB ||48613696 ||yes ||Intel Core i5 @ 2.6 GHz; 16GB RAM; SSD ||None || ||hn52 ||10 ||13.04s ||6 MB ||5000000 ||yes ||Intel Core 2 Quad Q9300 @ 2.50GHz, 3.9GiB RAM ||None || ||ah383 ||10 ||16.70s ||14.6 MB ||48613696 ||yes ||i7-5600U, @ 2,6 GHz, 12GB RAM, SSD ||None || ||jb729 & dr189 ||10 ||8.86s ||13 MB ||48613696 ||yes ||i7 @ 2,2 GHz, 16GB RAM, SSD ||None || ||js603 ||10 ||1.67s ||13.4 MB ||48613696 ||yes ||Intel i7-6900K @ 3.2 GHz; 32GB RAM; SSD ||None || ||ds467 ||10 ||3.2s ||40 MB ||48613696 ||yes ||Intel Core i5 @ 2.3 GHz; 8GB RAM; SSD ||None || || pd95 || 10|| 6.10s || 17 MB || 48613696 || no || Intel Core i7-4500U @1.80 GHz; 7GB RAM; SSD || None || || sn144 || 10 || 1.4s || - || 5000000 || yes || Intel Core i3-4030U @ 1.9 GHz;4 GB RAM || None || || cf147 || 10 || 26.1s || 6.5 MB || 48613696 || yes || Intel Core i5-6500 @3.2 GHz; 16GB RAM || None || ||uw18 ||10 ||5.38s ||6.7 MB ||48613696 ||yes ||Intel Core i5-2500K @ 3.3 GHz; 8GB RAM ||None || ||ds371 ||10 || 11.90s || 22.3 MB ||48613696 ||no || Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz; 16GB RAM ||None || ||df121-km109 ||10 ||16.94s ||2.22 MB ||5000000 ||yes || Intel Core i5-6200U @ 2.3 GHz; 8 GB RAM; SSD ||used DISTINCT, otherwise only 1.05s but 19 result rows|| ||ye14 ||10 ||63.38s || - ||- ||no ||Intel i5 @ 2.5 GHz; 8GB RAM; ||None || || ss844 || 10 || 3.89s || 13.18 MB || 48613696 || yes || Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz; 16GB RAM || None || || pc49 || 10 || 7.42s || 2.23 MB || 48613696 || yes || AMD FX(tm)-8120 Eight-Core Processor CPU @ 3.50GHz; 32GB RAM || None || |
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 memory usage of your program.
In the fifth column, write down the number of triples in your wikidata.tsv.
In the sixth column, write down whether you built an index for your database table or not.
In the seventh column, give a concise description about the specs of the machine you used.
In the eighth column, give a concise description about your further improvements in order to speed up the query time.
Name |
#Result Rows |
Runtime |
Memory Usage |
#Triples |
With DB Index? |
Machine Specifications |
Further Improvements |
ck1028 |
10 |
1.80s |
14 MB |
48613696 |
yes |
i5-4590 @ 3.30GHz; 8GB RAM; SSD |
None |
ak721-bf87 |
10 |
16.82s |
46 MB |
48613696 |
no |
Linux 4.14.12, x86_64, 16GB main mem, SSD, i7: 2.70GHz, 2 Cores, 4 Threads |
None |
dd74 |
10 |
35.34s |
9 MB |
48613696 |
no |
i5-4210U @ 1.70 GHz; 8GB RAM; SSD |
None |
bb245 |
10 |
6.16 s |
15 MB |
48613696 |
yes |
Intel® Core™ i7-6700HQ CPU @ 2.60GHz × 8, 16 GB RAM |
None |
mb930 |
10 |
4.25s |
6.7 MB |
48613696 |
yes |
Virtual machine with Linux-Kernel 4.14.15 running on host configuration |
None |
ht48 |
10 |
2.37s |
1290 MB |
48613696 |
yes |
I5-4258U @ 2.40GHz; 8GM RAM; SSD |
database file is loaded in memory |
nf55 |
10 |
0.23s |
4.9 MB |
48613696 |
yes |
Intel i7-7500U @ 2.70GHz; 16GB RAM; SSD |
None |
nf55 |
10 |
0.04s |
6574.8 MB |
48613696 |
yes |
Intel i7-7500U @ 2.70GHz; 16GB RAM; SSD |
Database fully cached in RAM |
fk234 |
10 |
10.77s |
6.6 MB |
48613696 |
yes |
Intel Core i3-3110M, 2.4GHz, 8GB RAM; SSD |
None |
yb36 |
10 |
0.02s |
12.8 MB |
48613696 |
yes |
Intel Xeon E3-1270v6 @ 3.8GHz; 64GB RAM; SSD |
VM with program in a ramdisk (10.4GB) |
ns202 |
10 |
3.64s |
154 MB |
48613696 |
yes |
AMD Ryzen 7 1800X @ 3.85 GHz; 8GB RAM; SSD |
None |
je113 |
10 |
0.09s |
15 MB |
48613696 |
yes |
Intel i7-8770K @ 3.2 GHz; 32GB RAM; NVMe SSD |
None |
ab717-my28 |
10 |
0.32s |
3 MB |
48613696 |
yes |
Intel i7-565OU CPU @ 1.70 GHz 2.30 GHz; Oracle VM: 2 GB RAM |
None |
vb128 |
10 |
21.06s |
11.9 MB |
48613696 |
no |
Intel i7-7700HQ @ 2.8 GHz; 8GB RAM; |
None |
rb201 |
10 |
0.18s |
42.7 MB |
48613696 |
yes |
Intel i5-2520M @ 2.5 GHz; 4GB RAM; |
potato machine magic |
fc54 |
10 |
6.03s |
31 MB |
48613696 |
yes |
Intel i5 @ 2.7 GHz; 8GB RAM; |
None |
he41 |
10 |
0.17s |
11.1 MB |
48613696 |
yes |
Intel Core i5-6200U @ 2.30GHz; 4GB RAM; |
None |
yl100 |
10 |
0.2s |
7.1 MB |
48613696 |
yes |
Intel Core i5 @ 2.6 GHz; 16GB RAM; SSD |
None |
hn52 |
10 |
13.04s |
6 MB |
5000000 |
yes |
Intel Core 2 Quad Q9300 @ 2.50GHz, 3.9GiB RAM |
None |
ah383 |
10 |
16.70s |
14.6 MB |
48613696 |
yes |
i7-5600U, @ 2,6 GHz, 12GB RAM, SSD |
None |
jb729 & dr189 |
10 |
8.86s |
13 MB |
48613696 |
yes |
i7 @ 2,2 GHz, 16GB RAM, SSD |
None |
js603 |
10 |
1.67s |
13.4 MB |
48613696 |
yes |
Intel i7-6900K @ 3.2 GHz; 32GB RAM; SSD |
None |
ds467 |
10 |
3.2s |
40 MB |
48613696 |
yes |
Intel Core i5 @ 2.3 GHz; 8GB RAM; SSD |
None |
pd95 |
10 |
6.10s |
17 MB |
48613696 |
no |
Intel Core i7-4500U @1.80 GHz; 7GB RAM; SSD |
None |
sn144 |
10 |
1.4s |
- |
5000000 |
yes |
Intel Core i3-4030U @ 1.9 GHz;4 GB RAM |
None |
cf147 |
10 |
26.1s |
6.5 MB |
48613696 |
yes |
Intel Core i5-6500 @3.2 GHz; 16GB RAM |
None |
uw18 |
10 |
5.38s |
6.7 MB |
48613696 |
yes |
Intel Core i5-2500K @ 3.3 GHz; 8GB RAM |
None |
ds371 |
10 |
11.90s |
22.3 MB |
48613696 |
no |
Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz; 16GB RAM |
None |
df121-km109 |
10 |
16.94s |
2.22 MB |
5000000 |
yes |
Intel Core i5-6200U @ 2.3 GHz; 8 GB RAM; SSD |
used DISTINCT, otherwise only 1.05s but 19 result rows |
ye14 |
10 |
63.38s |
- |
- |
no |
Intel i5 @ 2.5 GHz; 8GB RAM; |
None |
ss844 |
10 |
3.89s |
13.18 MB |
48613696 |
yes |
Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz; 16GB RAM |
None |
pc49 |
10 |
7.42s |
2.23 MB |
48613696 |
yes |
AMD FX(tm)-8120 Eight-Core Processor CPU @ 3.50GHz; 32GB RAM |
None |