Version 1 by Antony Wilson
on Jan 13, 2014 08:35.

compared with
Version 2 by Antony Wilson
on Jan 13, 2014 08:51.

Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (45)

View Page History
h5. Assessment of measurable points

The mean query time is the mean of 100 queries 10000 iterations
|| Metric || Description || FUSEKI || 4Store || _evaluation date_ ||
| MeanQueryTimeInSeconds | cycles query \\ | 0.012 0.006 | 0.0093 | January 7, 10, 2014 \\ |
| MeanQueryTimeInSeconds | investigations query | 1.957 | {color:#ff0000} 6.173{color} | January 7, 2014 |
| MeanQueryTimeInSeconds | investigation data query | 0.006 | 0.038 | January 7, 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.0061 | 0.003 | January 7, 10, 2014 |
| MeanQueryTimeInSeconds | next date query | 0.593 | 0.468 | January 7, 2014 |
| MeanQueryTimeInSeconds | previous date query | {color:#ff0000}1.119{color} | 0.668 | January 7, 2014 |
| MeanQueryTimeInSeconds | uri query | 0.003 | 0.002 | January 7, 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

h4. *Cycles{*}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)

h4. *Investigations{*}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  < "2011-03-01T00:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>
&& ?endDate  > "2011-05-15T23:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>)
(?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]>)
}
}

h4. *Investigation Data{*}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> <[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> <[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> <[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> <[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> <[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 { ?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> <[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
}
}

h4. PublicationsSELECT ?publication_fullReference ?publication_url

WHERE {
<https://icatisis.esc.rl.ac.uk/investigation/24086033> <http://www.purl.org/net/CSMD/4.0/investigation_publication> <[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 }
}

h4. *Next Date{*}SELECT (Min(?startDate) as ?date)

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

h4. Previous DateSELECT (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]>)
}

h4. UriSELECT ?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> <[http://www.purl.org/net/CSMD/4.0/investigation_startDate]> "2011-05-05T16:09:45Z"^^<[http://www.w3.org/2001/XMLSchema#dateTime]>
}