SPARQL Examples: Difference between revisions

From info216
(Blanked the page)
Tag: Blanking
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Lecture 3:SPARQL==


The KG4News knowledge graph can be accessed [http://bg.newsangler.uib.no here (namespace ''kb'')] (read-only). To test updates, you can run your own Blazegraph server or try the [http://sandbox.i2s.uib.no I2S sandbox].
===Limit===
<syntaxhighlight lang="SPARQL">
SELECT ?p WHERE {
    ?s ?p ?o .
}
LIMIT 10</syntaxhighlight>
===List distinct properties only (with limit)===
<syntaxhighlight>
SELECT DISTINCT ?p WHERE {
?s ?p ?o .
}
LIMIT 10
</syntaxhighlight>
===Limit with offset===
<syntaxhighlight>
SELECT DISTINCT ?p WHERE {
?s ?p ?o .
}
LIMIT 10 OFFSET 9
</syntaxhighlight>
===List rdf:types===
<syntaxhighlight>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
SELECT DISTINCT ?t WHERE {
?s rdf:type ?t .
}
LIMIT 50
</syntaxhighlight>
===URI for Tim Berners-Lee===
<syntaxhighlight>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT ?person WHERE {
    ?person foaf:name ?name . 
    FILTER(CONTAINS(?name, "Berners-Lee"))
}
LIMIT 10  # best to use limit if something goes wrong
</syntaxhighlight>
===Describe Tim Berners-Lee===
<syntaxhighlight>
DESCRIBE <http://i2s.uib.no/kg4news/author/1432678629>
</syntaxhighlight>
DESCRIBE returns a new RDF graph, whereas SELECT returns a table of rows.
===Papers that mention "Semantic Web" in the title===
<syntaxhighlight>
PREFIX ss: <http://semanticscholar.org/>
SELECT DISTINCT ?paper ?title WHERE {
    ?paper ss:title ?title . 
    FILTER(CONTAINS(STR(?title), "Semantic Web"))
}
LIMIT 50
</syntaxhighlight>
===Similar filter that ignores capitalisation (lower/upper case)===
<syntaxhighlight>
    FILTER(REGEX(STR(?title), "Semantic Web", "i"))
</syntaxhighlight>
===Authors sorted by name===
<syntaxhighlight>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT * WHERE {
    ?author foaf:name ?name . 
}
ORDER BY ?name
LIMIT 10
</syntaxhighlight>
===Limit===
<syntaxhighlight>
</syntaxhighlight>

Latest revision as of 11:17, 10 January 2024