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 |
2 |
1.10s |
493 |
0.05s |
VM@i5 @ 1.7GHz / 2 GB, Male professional porn actors |