View Source

h2. Evaluator

_Antony Wilson - STFC_

h2. Evaluation points


h5. Assessment of measurable points

The mean query time is the mean of 10,000 iterations
|| Metric || Description || FUSEKI || 4Store || _evaluation date_ ||
| MeanQueryTimeInSeconds | cycles query \\ | 0.006 | 0.003 | January 10, 2014 \\ |
| MeanQueryTimeInSeconds | investigations query | 1.877 | {color:#ff0000} 6.324{color} | January 10, 2014 |
| MeanQueryTimeInSeconds | investigation data query | 0.003 | 0.021 | January 10, 2014 |
| MeanQueryTimeInSeconds | publications query | 0.001 | 0.003 | January 10, 2014 |
| MeanQueryTimeInSeconds | next date query | 0.586 | 0.486 | January 10, 2014 |
| MeanQueryTimeInSeconds | previous date query | {color:#ff0000}1.143{color} | 0.681 | January 10, 2014 |
| MeanQueryTimeInSeconds | uri query | 0.001 | 0.001 | January 10, 2014 |

h2. Technical details


h3. The SPARQL Queries


h4. Cycles

{code}
SELECT ?name ?startDate ?endDate
WHERE {
?s <[http://www.purl.org/net/CSMD/4.0/facilitycycle_name]> ?name .
?s <[http://www.purl.org/net/CSMD/4.0/facilitycycle_startDate]> ?startDate .
?s <[http://www.purl.org/net/CSMD/4.0/facilitycycle_endDate]> ?endDate
}
order by DESC (?startDate)
{code}

h4. Investigations

{code}
SELECT ?id ?name ?title ?endDate ?startDate ?user_fullName
WHERE { {
?id <[http://www.purl.org/net/CSMD/4.0/investigation_name]> ?name .
?id <[http://www.purl.org/net/CSMD/4.0/investigation_title]> ?title .
?id <[http://www.purl.org/net/CSMD/4.0/investigation_endDate]> ?endDate .
?id <[http://www.purl.org/net/CSMD/4.0/investigation_startDate]> ?startDate .
FILTER
(?startDate&nbsp; < "2011-03-01T00:00:00Z"^^<[http://www.w3.org/2001/XMLSchema#dateTime]>
&& ?endDate&nbsp; > "2011-05-15T23:00:00Z"^^<[http://www.w3.org/2001/XMLSchema#dateTime]>)
}
OPTIONAL {
?id <[http://www.purl.org/net/CSMD/4.0/investigation_investigationUser]> ?investigationUserUri .
?investigationUserUri <[http://www.purl.org/net/CSMD/4.0/investigationuser_user]> ?userUri .
?investigationUserUri <[http://www.purl.org/net/CSMD/4.0/investigationuser_role]> ?userRole .
?userUri <[http://www.purl.org/net/CSMD/4.0/user_fullName]> ?user_fullName .
FILTER (?userRole = 'principal_experimenter'^^<[http://www.w3.org/2001/XMLSchema#string]>)
}
}
order by DESC (?startDate)
{code}

h4. Investigation Data

{code}
SELECT ?name ?doi ?startDate ?releaseDate ?summary ?instrument_fullName ?instrument_url ?facility_fullName ?user_fullName ?userRole ?title
WHERE {
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_name]> ?name .
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_instrument]> ?instrumentUri .
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_facility]> ?facilityUri .
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_startDate]> ?startDate .
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_title]> ?title .
OPTIONAL { <https://icatisis.esc.rl.ac.uk/investigation/24086033> <http://www.purl.org/net/CSMD/4.0/investigation_doi> ?doi } .
OPTIONAL { <https://icatisis.esc.rl.ac.uk/investigation/24086033> <http://www.purl.org/net/CSMD/4.0/investigation_releaseDate> ?releaseDate } .
OPTIONAL { <https://icatisis.esc.rl.ac.uk/investigation/24086033> <http://www.purl.org/net/CSMD/4.0/investigation_summary> ?summary } .
OPTIONAL { ?instrumentUri <http://www.purl.org/net/CSMD/4.0/instrument_fullName> ?instrument_fullName } .
OPTIONAL { ?instrumentUri <http://www.purl.org/net/CSMD/4.0/instrument_url> ?instrument_url } .
OPTIONAL { ?facilityUri <http://www.purl.org/net/CSMD/4.0/facility_fullName> ?facility_fullName } .
OPTIONAL {
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_investigationUser]> ?investigationUserUri .
?investigationUserUri <[http://www.purl.org/net/CSMD/4.0/investigationuser_role]> ?userRole .
?investigationUserUri <[http://www.purl.org/net/CSMD/4.0/investigationuser_user]> ?userUri .
?userUri <[http://www.purl.org/net/CSMD/4.0/user_fullName]> ?user_fullName
}
}
{code}

h4. Publications

{code}
SELECT ?publication_fullReference ?publication_url
WHERE {
<[https://icatisis.esc.rl.ac.uk/investigation/24086033]> <[http://www.purl.org/net/CSMD/4.0/investigation_publication]> ?publicationUri .
?publicationUri <[http://www.purl.org/net/CSMD/4.0/publication_fullReference]> ?publication_fullReference .
OPTIONAL { ?publicationUri <http://www.purl.org/net/CSMD/4.0/publication_url> ?publication_url }
}
{code}

h4. Next Date

{code}
SELECT (Min(?startDate) as ?date)
WHERE {
?id <[http://www.purl.org/net/CSMD/4.0/investigation_startDate]> ?startDate
FILTER (?startDate >&nbsp; "2011-05-05T16:09:45Z"^^<[http://www.w3.org/2001/XMLSchema#dateTime]>)
}
{code}

h4. Previous Date

{code}
SELECT (Max(?startDate) as ?date)
WHERE {
?id <[http://www.purl.org/net/CSMD/4.0/investigation_startDate]> ?startDate
FILTER (?startDate <&nbsp; "2011-05-05T16:09:45Z"^^<[http://www.w3.org/2001/XMLSchema#dateTime]>)
}
{code}

h4. Uri

{code}
SELECT ?id
WHERE {
?id <[http://www.purl.org/net/CSMD/4.0/investigation_startDate]> "2011-05-05T16:09:45Z"^^<[http://www.w3.org/2001/XMLSchema#dateTime]>
}
{code}

h2. Evaluation notes

_Could be such things as identified issues, workarounds, data preparation, if not already included above_