Skip to main content

How much memory is consumed by history- and quality-data?

Abstract

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