881
Comment:
|
2332
|
Deletions are marked like this. | Additions are marked like this. |
Line 6: | Line 6: |
1. The number of results for the respective query (without the LIMIT). 2. The query time in seconds, with exactly two digits after the dot (for Query 2: with the LIMIT). 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|| ||Elmar ||2|| 0.6s || 142 || 0.1s ||Intel i5-2520M @ 2.5GHz / 8GB || |
||<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|| ||ES ||2|| 0.74s || 737 || 0.00s ||Intel i5-5200U @ 2.2GHz / 8GB, musicians who died of natural causes but were also murdered || ||Frank2 ||2|| 0.22s || 109 || 0.00s ||Intel i5-3337U @ 1.8GHz / 4GB, male people from neighbour-countries of Germany || ||Alex ||2|| 0.08s || 467 || 0.06s ||Intel i5-3210M @ 1.8GHz / 8GB, German male actors || ||Janosch ||2|| 0.40s || 198 || 0.01s ||Intel M-5Y71 @ 1.3GHz / 8GB, Countries (that exist now or have existed) that are (or have been) members of the United Nations || ||David ||2|| 0.09s || 139 || 0.00s ||Intel i5-4670K @ 3.40GHz / 8 GB, Female scientists || ||ID ||2|| 0.16s || 102 || 0.06s ||Intel Core i5-2435M CPU @ 2.40GHz / 8 GB, Actors who are also athletes || ||Daniel ||2|| 2.09s || 115 || 0.02s || Intel Pentium T4500 @ 2.3GHz / 4 GB, Celebrities who have been assassinated || ||Daniel ||2|| 1.10s || || || VM@i5 @ 1.7GHz / 2 GB, || |
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 |
ES |
2 |
0.74s |
737 |
0.00s |
Intel i5-5200U @ 2.2GHz / 8GB, musicians who died of natural causes but were also murdered |
Frank2 |
2 |
0.22s |
109 |
0.00s |
Intel i5-3337U @ 1.8GHz / 4GB, male people from neighbour-countries of Germany |
Alex |
2 |
0.08s |
467 |
0.06s |
Intel i5-3210M @ 1.8GHz / 8GB, German male actors |
Janosch |
2 |
0.40s |
198 |
0.01s |
Intel M-5Y71 @ 1.3GHz / 8GB, Countries (that exist now or have existed) that are (or have been) members of the United Nations |
David |
2 |
0.09s |
139 |
0.00s |
Intel i5-4670K @ 3.40GHz / 8 GB, Female scientists |
ID |
2 |
0.16s |
102 |
0.06s |
Intel Core i5-2435M CPU @ 2.40GHz / 8 GB, Actors who are also athletes |
Daniel |
2 |
2.09s |
115 |
0.02s |
Intel Pentium T4500 @ 2.3GHz / 4 GB, Celebrities who have been assassinated |
Daniel |
2 |
1.10s |
|
|
VM@i5 @ 1.7GHz / 2 GB, |