Query Samples

Query SPARQL query Why-not Question
To find American actors who have won the Academy Award for Best Actor. PREFIX dbpprop:<http://dbpedia.org/property/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX category: <http://dbpedia.org/resource/Category:>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
SELECT ?actorname{
?actor dcterms:subject category:Best_Actor_Academy_Award_winners.
?actor dbpprop:name ?actorname.
?actor dc:description ?country.
FILTER regex(str(?country), "American")}
var:actorname
value:Leonardo DiCaprio
var:actorname
value:Colin Firth
To find romantic disaster films released after 2000. PREFIX dbpprop:<http://dbpedia.org/property/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX category: <http://dbpedia.org/resource/Category:>
SELECT ?filmname{
?film dcterms:subject category:Romantic_epic_films.
?film dcterms:subject category:American_disaster_films.
?film dbpprop:name ?filmname.
MINUS{?film dbpprop:released ?date.
FILTER (?date < 2000 )}
}
var:filmname
value:The English Patient
var:filmname
value:Titanic
To find Best Actress Academy Award winners who directed, writed and acted in the same film, and the film won the Academy Award for Best Picture. PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX category: <http://dbpedia.org/resource/Category:>
SELECT ?person{
?film dcterms:subject category:Best_Picture_Academy_Award_winners.
?film dbpedia-owl:director ?person.
?film dbpedia-owl:starring ?person.
?film dbpedia-owl:writer ?person.
?person dcterms:subject category:Best_Actress_Academy_Award_winners.
}
var:person
value:∅

To demo: ANNA.    To experiment results: APPENDIX A.    To more queries: queryset.xls