Verifying Data

This page lists manual approaches for checking what data is in Virtuoso:

Check past events

Use the following query to get the newest 100 AlarmEvents:

prefix xsd:     <http://www.w3.org/2001/XMLSchema#>
prefix rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix ssn:     <http://purl.oclc.org/NET/ssnx/ssn#>
prefix rpm:     <http://events.event-processing.org/rpm/>
prefix :        <http://events.event-processing.org/types/>

SELECT ?s ?p ?o
WHERE {
GRAPH ?g {
?s a rpm:AlarmEvent .
?s ?p ?o .
?s :endTime ?endTime .
}
}
ORDER BY DESC (?endTime)
LIMIT 100

Use the following query to get the newest 100 Recommendation events (UcTelcoEsrRecom) :

prefix xsd:     <http://www.w3.org/2001/XMLSchema#>
prefix rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix ssn:     <http://purl.oclc.org/NET/ssnx/ssn#>
prefix rpm:     <http://events.event-processing.org/rpm/>
prefix :        <http://events.event-processing.org/types/>

SELECT ?s ?p ?o
WHERE { 
GRAPH ?g {
?s a :UcTelcoEsrRecom .
?s ?p ?o .
?s :endTime ?endTime .
}
}
ORDER BY DESC (?endTime)
LIMIT 100

Check uploaded data

For uploaded data use this query to get the newest 100 heartbeat rates:

prefix xsd:     <http://www.w3.org/2001/XMLSchema#>
prefix rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix ssn:     <http://purl.oclc.org/NET/ssnx/ssn#>
prefix rpm:     <http://events.event-processing.org/rpm/>
prefix :        <http://events.event-processing.org/types/>

SELECT
    ?s rpm:heartRate ?o2
FROM <mailto:[email protected]>
WHERE {
    ?s ssn:observationSamplingTime ?time .
    ?s ssn:observationResult [ ssn:hasValue [
      rpm:heartRate ?o2
    ]]
}
ORDER BY DESC (?time)
LIMIT 100