Documenting and preserving programming languages and software in Wikidata
John Samuel, Katherine Thornton, Kenneth Seals-Nutt
CPE Lyon, EaaSI
SWIB 2018, Bonn, 27th November, 2018
 
       - Wikipedia.png) 
           - Wikipedia.png) 
           - Wikipedia.png) 
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
          
          
           
           
           
           
           
           
          http://histropedia.com/timeline/d98rtpg9bg0t/Programming-languages
 
              
             
           
           
         
         
          
SELECT ?paradigmLabel (count(?prog) as ?count)
{
  ?prog wdt:P31 wd:Q9143;
        wdt:P3966 ?paradigm.
  SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP by ?paradigmLabel
HAVING (?count>1)
          
        
SELECT ?progLabel (count(?paradigm) as ?count)
{
  ?prog wdt:P31 wd:Q9143;
        wdt:P3966 ?paradigm.
  SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP by ?progLabel
HAVING (?count>2)
          
        
SELECT ?languageLabel (count(?label) as ?count) {
  {
    SELECT DISTINCT ?languageLabel ?label (lang(?label) as ?langLabel) {
      ?language wdt:P31/wdt:P279* wd:Q9143;
                rdfs:label ?label.
      SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
      }
  }
}
GROUP by ?languageLabel
HAVING (?count > 50)
ORDER by DESC(?count)
          
        
SELECT ?softwareLabel (count(?label) as ?count) {
  {
    SELECT DISTINCT ?softwareLabel ?label (lang(?label) as ?langLabel) {
      ?software wdt:P31/wdt:P279 wd:Q7397;
                rdfs:label ?label.
      SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
      }
  }
}
GROUP by ?softwareLabel
HAVING (?count > 40)
ORDER by DESC(?count)
          
        
SELECT ?langLabel (count(?language) as ?count) {
  {
    SELECT DISTINCT (lang(?label) as ?langLabel) ?language {
      ?language wdt:P31/wdt:P279* wd:Q9143;
                rdfs:label ?label.
      }
  }
}
GROUP by ?langLabel
ORDER by DESC(?count)
          
        
SELECT ?langLabel (count(?software) as ?count) {
  {
    SELECT DISTINCT (lang(?label) as ?langLabel) ?software {
      ?software wdt:P31/wdt:P279* wd:Q7397;
                rdfs:label ?label.
      }
  }
}
GROUP by ?langLabel
ORDER by DESC(?count)
          
        
SELECT DISTINCT ?languageLabel ?sitelinks {
      ?language wdt:P31/wdt:P279* wd:Q9143;
                wikibase:sitelinks ?sitelinks.
       FILTER(?sitelinks > 20)
       SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER by DESC(?sitelinks)
          
        
SELECT DISTINCT ?softwareLabel ?sitelinks {
      ?software wdt:P31/wdt:P279* wd:Q7397;
                wikibase:sitelinks ?sitelinks.
       FILTER(?sitelinks > 100)
       SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER by DESC(?sitelinks)
          
        
SELECT ?lang (count(?progLanguage) as ?count) {
  {
    SELECT DISTINCT ?progLanguage ?lang {
      ?progLanguage wdt:P31/wdt:P279* wd:Q9143.
      [] schema:about ?progLanguage;
         schema:inLanguage ?lang.
     }
  }
}
GROUP BY ?lang
ORDER BY DESC(?count)
          
        
SELECT ?lang (count(?software) as ?count) {
  {
    SELECT DISTINCT ?software ?lang {
      ?software wdt:P31/wdt:P279* wd:Q7397.
      [] schema:about ?software;
         schema:inLanguage ?lang.
     }
  }
}
GROUP BY ?lang
ORDER BY DESC(?count)
          
        
SELECT ?item ?itemLabel (COUNT(DISTINCT ?software) AS ?count) WHERE {
  ?software (wdt:P31/wdt:P279*) wd:Q7397.
  ?software wdt:P275 ?item.
  ?item wdt:P790 wd:Q48413.
  SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?count)
          
        
SELECT ?item ?itemLabel ?LCNAF ?GND
WHERE
{
  ?item wdt:P31 wd:Q18343316.
  OPTIONAL {?item wdt:P244 ?LCNAF}.
  OPTIONAL {?item wdt:P227 ?GND}.
  SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}
          
        
SELECT ?member ?memberLabel ?software ?softwareLabel WHERE {
  ?member wdt:P463 wd:Q2514863.
  ?software wdt:P178 ?member.
  SERVICE wikibase:label { bd:serviceParam
          wikibase:language "[AUTO_LANGUAGE],en". }
}