To get an overview of triples, consumed by history and quality data, please use the following query using SPARQL Endpoint of a Project or PoolParty's SPARQL Shell.
SELECT (STR(?nrTotal) AS ?total) (STR(?nrConcepts) AS ?concepts) (ROUND(((?nrConcepts / ?nrTotal) * 100)) AS ?percentConcepts) (STR(?nrHist) AS ?history) (ROUND(((?nrHist / ?nrTotal) * 100)) AS ?percentHistory)
WHERE
{
{
SELECT (COUNT(*) AS ?nrConcepts)
WHERE { graph <http://<baseUrl>/<projectId>/thesaurus> { ?s ?p ?o }}
}
{
SELECT (COUNT (*) AS ?nrHist)
WHERE { graph <http://<baseUrl>/<projectId>/thesaurus/history> { ?s ?p ?o }}
}
{
SELECT (COUNT (*) AS ?nrQuali)
WHERE { graph <http://<baseUrl>/<projectId>/thesaurus/qualityReport> { ?s ?p ?o }}
}
BIND ((?nrConcepts + ?nrHist + ?nrQuali ) AS ?nrTotal)
}
?total | Number of triples in the requested named graphs in total |
?concepts | Number of triples in the thesaurus graph |
?percentConcepts | Relative number of concept data of the total data set |
?history | Number of triples in the history graph |
?percentHistory | Relative number of history data of the total data set |
?quality | Number of triples in the quality graph |
?percentQuality | Relative number of quality data of the total data set |
Note
This analysis report has template character and can be adapted to your requirements.
Note
To remove e.g. history data you can execute a DELETE query described here: Reset history data from a PoolParty project