|
Size: 760
Comment:
|
Size: 1787
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 7: | Line 7: |
| As a reminder: Query 1 = actor couples where both have won the same prize; Query 2 = pairs of couples who have also been married cross-wise, Query 3 = actors with two or more Oscars. |
|
| Line 8: | Line 10: |
| ||Florian B. ||#185 / 1.64s ||#8 / 0.89s ||#175 / 0.09s ||Intel X5560 @ 2.8GHz / 36GB || ||Ragavan N. ||#266 / 0.31s ||#53 / 0.78s || #?? / ?.??s ||Core i7-3720 @ 2.6GHz / 16GB || |
||Florian B. ||#185 / 1.64s ||#53 / 0.45s ||#175 / 0.09s ||Intel X5560 @ 2.8GHz / 36GB || ||Ragavan N. ||#185 / 0.31s ||#53 / 0.78s || #175 / 0.14s ||Core i7-3720QM @ 2.6GHz / 16GB || ||Dennis P, Marcel G || #185 / 0.56s || #16 / 0.66s || #175 / 0.24s ||i5 - 520M @ 2.4GHz / 6GB || ||Jan M. ||#185 / 0.066s ||#53 / 0.66s || #175 / 0.0096s ||VM on i5-450M @ 2.4GHz / 1GB || ||Antony N. ||#185 / 0.196s ||#53 / 2.01s || #175 / 0.0766s ||i5 560M @ 2.67 GHz / 8GB || ||Christoph S ||#185 / 0.374s ||#16 / 1.04s || #175 / 0.093s ||Intel !Core2Duo @ 2.53 GHz / 4GB || ||Markus F ||#185 / 0.42s ||#16 / 1.21s || #200 / 0.03s || Intel Core i5-2500K @ 3.30GHz / 8GB || ||Ane R ||#185 / 0.79s || #53 / 2.6s || #175 / 0.03s || Intel i5-2450M @ 2.5GHz / 8GB || ||Aritz B ||#185 / 0.99s || || #175 / 0.04s || Intel Core 2 Duo @ 2.4GHz / 6GB || ||Ander B ||#185 / 0.61s || #53 / 2.47s || #175 / 0.02s || Intel Core i5 @ 2.3GHz / 8GB || ||Anthony A ||#266 / 0.78s || # / 2.49s || # / s || Intel Core i7 @ 2.1GHz / 8GB || |
Results for Exercise Sheet 12 (SPARQL via SQL)
Please read the instructions below, before adding something to the table!
Add your row to the table below, following the examples already there. Column 1 = name. Column 2, 3, 4 = number of results / time of SQL query for Query 1, 2, 3. Column 5 = machine specification as usual (processor frequency with exactly one digit after the dot, amount of RAM as an integer, no secondary details about processor).
As a reminder: Query 1 = actor couples where both have won the same prize; Query 2 = pairs of couples who have also been married cross-wise, Query 3 = actors with two or more Oscars.
Name |
Query 1 |
Query 2 |
Query 3 |
Processor / RAM |
Florian B. |
#185 / 1.64s |
#53 / 0.45s |
#175 / 0.09s |
Intel X5560 @ 2.8GHz / 36GB |
Ragavan N. |
#185 / 0.31s |
#53 / 0.78s |
#175 / 0.14s |
Core i7-3720QM @ 2.6GHz / 16GB |
Dennis P, Marcel G |
#185 / 0.56s |
#16 / 0.66s |
#175 / 0.24s |
i5 - 520M @ 2.4GHz / 6GB |
Jan M. |
#185 / 0.066s |
#53 / 0.66s |
#175 / 0.0096s |
VM on i5-450M @ 2.4GHz / 1GB |
Antony N. |
#185 / 0.196s |
#53 / 2.01s |
#175 / 0.0766s |
i5 560M @ 2.67 GHz / 8GB |
Christoph S |
#185 / 0.374s |
#16 / 1.04s |
#175 / 0.093s |
Intel Core2Duo @ 2.53 GHz / 4GB |
Markus F |
#185 / 0.42s |
#16 / 1.21s |
#200 / 0.03s |
Intel Core i5-2500K @ 3.30GHz / 8GB |
Ane R |
#185 / 0.79s |
#53 / 2.6s |
#175 / 0.03s |
Intel i5-2450M @ 2.5GHz / 8GB |
Aritz B |
#185 / 0.99s |
|
#175 / 0.04s |
Intel Core 2 Duo @ 2.4GHz / 6GB |
Ander B |
#185 / 0.61s |
#53 / 2.47s |
#175 / 0.02s |
Intel Core i5 @ 2.3GHz / 8GB |
Anthony A |
#266 / 0.78s |
# / 2.49s |
# / s |
Intel Core i7 @ 2.1GHz / 8GB |