|
Size: 1131
Comment:
|
Size: 1567
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 14: | Line 14: |
| ||Frank ||2|| 0.78s || 355 || 0.05s ||Intel i5-4690 @ 3.5GHz / 8GB, directors married to actors, who played in the same film|| | ||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 || |
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 |