Triplestores "popularity"

1

Please login or register to vote for this query.

(click on this box to dismiss)

Linguistics Meta

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

WITH Joined AS 
 (
 SELECT Posts.Id AS PostId, Posts.CreationDate, Tags.Id AS TagId, Tags.TagName
 FROM Posts
 JOIN PostTags ON Posts.Id = PostTags.PostId
 JOIN Tags ON PostTags.TagId = Tags.Id
 ) 

SELECT PostYear, Triplestore,  Count(DISTINCT PostId) AS Posts
FROM
 (
 SELECT Year(CreationDate) AS PostYear, PostId, Triplestore =
  CASE
   WHEN TagName IN ('jena', 'apache-jena', 'fuseki', 'tdb') THEN 'Apache Jena'
   WHEN TagName IN ('virtuoso', 'openlink-virtuoso') THEN 'Virtuoso'
   WHEN TagName IN ('blazegraph', 'amazon-neptune') THEN 'Blazegraph'
   WHEN TagName IN ('graphdb', 'owlim') THEN 'GraphDB'
   WHEN TagName IN ('stardog') THEN 'Stardog'
   WHEN TagName IN ('marklogic', 'marklogic-7', 'marklogic-8', 'marklogic-9') THEN 'MarkLogic'
   WHEN TagName IN ('rdf4j', 'sesame', 'openrdf')  THEN 'RDF4J'
   WHEN TagName IN ('allegrograph')  THEN 'AllegroGraph'
   WHEN TagName IN ('4store')  THEN '4store'
   -- Just curious
   WHEN TagName IN ('protege', 'protege4') THEN 'Protege' 
   WHEN TagName IN ('neo4j') THEN 'Neo4j'
   WHEN TagName IN ('rdflib') THEN 'RDFLib'
   WHEN TagName IN ('dotnetrdf') THEN 'DotNetRDF'
   WHEN TagName IN ('redland', 'raptor2') THEN 'Redland'
   WHEN TagName IN ('oracle', 'oracle11g', 'oracle12c', 'oracle-spatial') THEN 'Oracle'
  ELSE NULL
  END
 FROM Joined
 WHERE PostId IN (
                  SELECT PostId
                  FROM Joined
                  WHERE TagName IN ('sparql', 'rdfstore', 'triplestore')
                 )
) t WHERE Triplestore IS NOT NULL GROUP BY Triplestore, PostYear ORDER BY PostYear DESC, Posts DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results