|
Size: 1437
Comment:
|
Size: 1437
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 6: | Line 6: |
| 1. The number of results for the respective query. 2. The query time in seconds, with exactly two digits after the dot. 3. Processor / RAM = the specs of the machine you used. Specify the processor frequency with exactly one digit after the dot, the amount of RAM as an integer, and don't provide secondary details about the processor. |
1. The number of results for the respective query (without LIMIT). 2. The query time in seconds, with exactly two digits after the dot (for query 2: with 'LIMIT 10'). 3. Processor / RAM = the specs of the machine you used. Also give a short description of your own query. |
| Line 10: | Line 10: |
| ||<style="text-align:center"|2>'''Name''' ||||<style="text-align:center">'''Query 1 (given)'''||||<style="text-align:center">'''Query 2 (your choice)'''||<style="text-align:center"|2>'''Processor / RAM'''|| ||#results||query time||#results||query time|| ||Björn ||2|| 679.4|| 12 || 0.77 ||Intel X5560 @ 2.8GHz / 36GB || ||Jens || 1 || 0.5 || 217 || 0.17 || Intel i3-2310M @ 2.10GHz / 2GB || ||José || 0 || 0.02 || 13 || 0.01 || Intel i5 @ 2.4GHz / 8GB || ||Janosch ||1 ||1.30 || 8 || 2.99 || Intel i7-3520M @ 2.9GHz / 8GB || ||Manuel ||1 ||356.21 || 23 || 4.53 || Intel E3-1230v3 @ 3.7GHz / 4GB (VM) || ||Melih&Gökçe ||2 ||2.01 ||9 ||1.35 ||Intel Core i7-2670QM CPU @ 2.20 GHz / 6GB|| ||Nico ||2 ||57.41 ||3 ||0.94 ||Intel Core i7-3770k CPU @ 3.5 GHz / 16GB (VM)|| ||Rafael ||1 ||162.33 || 3||93.40 ||Intel Core i5-3470 CPU @ 3.2 GHz / 2 GiB (VM)|| ||Jerome ||1 || 28.16 || 4||25.93 ||Intel Core2 T7400 @ 2.16GHz || |
||<style="text-align:center"|2>'''Name''' ||||<style="text-align:center">'''Query 1 (given)'''||||<style="text-align:center">'''Query 2 (your choice)'''||<style="text-align:center"|2>'''Processor / RAM + Description of Query 2'''|| ||#results||query time||#results||query time (with LIMIT)|| ||Elmar ||2|| 0.67s || 142 || 0.08s ||Intel i5-2520M @ 2.5GHz / 8GB, thrillers directed by someone who was/is married to a celebrity || ||Robin ||2|| 0.17s || 222 || 0.12s ||Intel i7-4510U @ 2.0GHz / 16GB, people who lived both in locations in Europe and Africa || ||Frank ||2|| 0.72s || 355 || 0.03s ||Intel i5-4690 @ 3.5GHz / 8GB, directors married to actors, who played in the same film|| ||Philip / Johannes ||2|| 0.43s || 6841 || 0.00s ||Intel i5-4590 @ 3.3GHz / 32GB, Films that are Directed by and Produced by the same instance|| ||Elias + Maxi ||2|| 0.22s || 274 || 0.02s ||Intel i7-6700 @ 2.6GHz / 8GB, directors and films which performed in the film, won an award and are celebrities|| |
Results for Exercise Sheet 13 (two SPARQL/SQL queries)
Please add your row to the table below, following the examples already there:
1. The number of results for the respective query (without LIMIT). 2. The query time in seconds, with exactly two digits after the dot (for query 2: with 'LIMIT 10'). 3. Processor / RAM = the specs of the machine you used. Also give a short description of your own query.
Name |
Query 1 (given) |
Query 2 (your choice) |
Processor / RAM + Description of Query 2 |
||
#results |
query time |
#results |
query time (with LIMIT) |
||
Elmar |
2 |
0.67s |
142 |
0.08s |
Intel i5-2520M @ 2.5GHz / 8GB, thrillers directed by someone who was/is married to a celebrity |
Robin |
2 |
0.17s |
222 |
0.12s |
Intel i7-4510U @ 2.0GHz / 16GB, people who lived both in locations in Europe and Africa |
Frank |
2 |
0.72s |
355 |
0.03s |
Intel i5-4690 @ 3.5GHz / 8GB, directors married to actors, who played in the same film |
Philip / Johannes |
2 |
0.43s |
6841 |
0.00s |
Intel i5-4590 @ 3.3GHz / 32GB, Films that are Directed by and Produced by the same instance |
Elias + Maxi |
2 |
0.22s |
274 |
0.02s |
Intel i7-6700 @ 2.6GHz / 8GB, directors and films which performed in the film, won an award and are celebrities |