How much memory is consumed by history- and quality-data?
How much memory is consumed by history- and quality-data?
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