|
Size: 4997
Comment:
|
← Revision 69 as of 2018-01-30 13:26:12 ⇥
Size: 5161
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 13: | Line 13: |
| ||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 || |
||nf55 ||10 ||0.10s ||7.2 MB ||48613696 ||yes ||Intel i7-7500U @ 2.70GHz; 16GB RAM; SSD ||None || ||nf55 ||10 ||0.02s ||6133.8 MB ||48613696 ||yes ||Intel i7-7500U @ 2.70GHz; 16GB RAM; SSD ||Database fully cached in RAM || |
| Line 30: | Line 30: |
| || 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 || |
||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 || |
| Line 34: | Line 34: |
| ||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 || |
||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 || ||pj46 ||10 ||9.93s ||10.22MB ||48613696 ||yes ||Intel core i7 5500U; 8GB RAM ||None || ||sa194+lf189 ||10 ||7.30s ||17.35MB ||48613696 ||no ||VM, Intel Core i5-4260U CPU @ 1.40GHz, 2GB RAM, SSD ||None || ||fe73 ||10 ||28.40s ||10.45MB ||48613696 ||no ||- ||None || ||br106-ms1512 ||10 ||1.1 sec ||- ||5004677 ||yes ||VM, Intel Core i3-6006U CPU @ 2.00GHz, 8GB RAM ||None || ||gt42 ||10 ||22.83 s ||- ||48613741 ||no ||Ubuntu, i7-4710MQ CPU @ 2.50GHz, 8GB RAM, HDD ||None || |
| Line 38: | Line 45: |
| ---- /!\ '''Edit conflict - other version:''' ---- || ss844 || 10 || 3.89s || 13.18 MB || 48613696 || yes || Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz; 16GB RAM; SSD || None || |
|
| Line 41: | Line 46: |
| ---- /!\ '''Edit conflict - your version:''' ---- || 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 || ---- /!\ '''End of edit conflict''' ---- |
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.10s |
7.2 MB |
48613696 |
yes |
Intel i7-7500U @ 2.70GHz; 16GB RAM; SSD |
None |
nf55 |
10 |
0.02s |
6133.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 |
pj46 |
10 |
9.93s |
10.22MB |
48613696 |
yes |
Intel core i7 5500U; 8GB RAM |
None |
sa194+lf189 |
10 |
7.30s |
17.35MB |
48613696 |
no |
VM, Intel Core i5-4260U CPU @ 1.40GHz, 2GB RAM, SSD |
None |
fe73 |
10 |
28.40s |
10.45MB |
48613696 |
no |
- |
None |
br106-ms1512 |
10 |
1.1 sec |
- |
5004677 |
yes |
VM, Intel Core i3-6006U CPU @ 2.00GHz, 8GB RAM |
None |
gt42 |
10 |
22.83 s |
- |
48613741 |
no |
Ubuntu, i7-4710MQ CPU @ 2.50GHz, 8GB RAM, HDD |
None |