To jest stara wersja strony!
| Last verification: | 20171014 |
|---|---|
| Tools required for this lab: | – |
Reading:
http://www.daml.org/2003/01/periodictable/PeriodicTable.owl into „Target graph URI (or use FROM in the query)” field, select Text in „Output” dropdown list.Get Results):PREFIX table: <http://www.daml.org/2003/01/periodictable/PeriodicTable#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?element ?name
WHERE {
?element table:group ?group .
?group table:name "Noble gas"^^xsd:string .
?element table:name ?name .
}
ORDER BY ASC(?name)
PREFIX table: <http://www.daml.org/2003/01/periodictable/PeriodicTable#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX rdfs: <http://w3.org/2000/01/rdf-schema#>
CONSTRUCT {
?element rdfs:label ?name .
}
WHERE {
?element table:group ?group .
?group table:name "Noble gas"^^xsd:string .
?element table:name ?name .
}
ORDER BY ASC(?name)
What do SELECT queries do? What do CONSTRUCT queries do? :JamesDean :playedIn :Giant .
:JamesDean :playedIn ?what . :Giant?who :playedIn :Giant . :JamesDean:JamesDean ?what :Giant . :playedIn
http://home.agh.edu.pl/~kkutt/foaf.rdf file) to retrieve: Put the constructed queries in the report.Target graph URI OR use FROM construct to define your data source, e.g. PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT ?name
FROM <http://home.agh.edu.pl/~kkutt/foaf.rdf>
WHERE {
?x rdf:type foaf:Person .
?x foaf:name ?name
}
LIMIT 10
Put the queries in the report.?country) that probably has a relation rdfs:label with object „Polska”@pl. This can be easily translated into SPARQL WHERE clause: ?country rdfs:label "Polska"@pl .
http://dbpedia.org/sparql Endpoint. We can't use FROM clause, because this one is designated for RDF graphs. We should use SERVICE instead. Final query:PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?country
WHERE {
SERVICE <http://dbpedia.org/sparql> {
?country rdfs:label "Polska"@pl .
}
}
Note 1: There must be something in Target graph URI field (this can be FOAF URI from previous section) – this URI will not be used in query but SPARQLer needs it to execute query…
Note 2: You can use more than one SERVICE clauses in SPARQL query – it gives you a possibility to combine results from different SPARQL Endpoints.
rdfs:label „Polska”@pl! Put the final query in the report.-------------- | population | ============== | 38483957 | --------------
Prepare a query that returns a list of 10 countries in Europe with the biggest population. Put the query in the report.------------------------------------------------ | voivodeship | counties | ================================================ | "Masovian Voivodeship"@en | 15 | | "Greater Poland Voivodeship"@en | 12 | | "Lesser Poland Voivodeship"@en | 11 | | "Podkarpackie Voivodeship"@en | 10 | | "Pomeranian Voivodeship"@en | 9 | | "Warmian-Masurian Voivodeship"@en | 9 | | "West Pomeranian Voivodeship"@en | 9 | | "Opole Voivodeship"@en | 8 | ------------------------------------------------
or in Polish:
-------------------------------------------------- | wojewodztwo | powiaty | ================================================== | "Województwo mazowieckie"@pl | 15 | | "Województwo wielkopolskie"@pl | 12 | | "Województwo małopolskie"@pl | 11 | | "Województwo podkarpackie"@pl | 10 | | "Województwo pomorskie"@pl | 9 | | "Województwo warmińsko-mazurskie"@pl | 9 | | "Województwo zachodniopomorskie"@pl | 9 | | "Województwo opolskie"@pl | 8 | --------------------------------------------------
http://dbpedia.org/resource/Powiathttp://dbpedia.org/resource/Voivodeship_(Poland) Put the query in the report.is_father_of or is_child_of or maybe both of them?is_father_of. Now, you can execute CONSTRUCT query that creates inverse relation: PREFIX bb: <http://yourname/b-and-b#>.
CONSTRUCT {
?child bb:is_child_of ?father .
}
WHERE {
?father bb:is_father_of ?child
}
is_uncle_of relation will be useful? No problem! PREFIX bb: <http://yourname/b-and-b#>.
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
CONSTRUCT {
?uncle bb:is_uncle_of ?child .
}
WHERE {
?uncle bb:is_sibling_of ?parent;
a bb:Man.
?child bb:is_child_of ?parent
}
is_sibling_of but instead you have is_sister_of and is_brother_of. Simply prepare query (or queries) that creates is_sibling_of for you. Put this query in the report. What 3 rules you will find useful in your model from previous lab. Put 3 CONSTRUCT queries in the report.SPARQL also provides two more query types: ASK and DESCRIBE.
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
ASK { ?x foaf:name "Krzysztof Kluza" }
If you run this query against http://home.agh.edu.pl/~kkutt/foaf.rdf file answer will be yes.
Prepare query that checks something interesting in your model :)MusicCD and was published by Warner Music Group (if you don't have such classes in your library, use analogous class that you have).DESCRIBE <http://home.agh.edu.pl/~kkutt/foaf.rdf#me>
(it should be executed against http://home.agh.edu.pl/~kkutt/foaf.rdf file)
Prepare query that describes all foaf:Person items from your model (if you don't have a foaf:Person class in your library, use analogous class that you have).SELECT ?actor
WHERE {?actor :playedIn :ReturnOfTheJedi .
NOT EXISTS {?actor :diedOn ?deathdate . }
}
SELECT actor_name
FROM movies
WHERE title = "Return of the Jedi"
AND NOT EXISTS (SELECT *
FROM deaths
WHERE movies.actor_name = deaths.name);
What are Open World Assumption (OWA) and Close World Assumption (CWA)? What is the difference between these two queries (refer to the knowledge of OWA and CWA)?SPARQL:
Exemplary queries in SPARQL:
Tools:
Open Data Sets:
DB2RDF (RDF and Relational Databases):
