AD Teaching Wiki:

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

WuTangClan

2

1.10s

493

0.05s

VM@i5 @ 1.7GHz / 2 GB, Male professional porn actors

AD Teaching Wiki: InformationRetrievalWS1516/ResultsES13 (last edited 2016-02-09 11:37:57 by HSI-KBW-46-223-1-97)