Difference between revisions of "SPARQL Examples"

From Info216
Line 47: Line 47:
 
  PREFIX sp: <http://i2s.uib.no/kg4news/science-parse/>
 
  PREFIX sp: <http://i2s.uib.no/kg4news/science-parse/>
 
  PREFIX th: <http://i2s.uib.no/kg4news/theme/>
 
  PREFIX th: <http://i2s.uib.no/kg4news/theme/>
 +
 +
PREFIX ex: <http://example.org/>
 +
PREFIX xml: <http://www.w3.org/XML/1998/namespace>
 +
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
 +
 +
 +
===select all triplets in graph===
 +
 +
SELECT ?s ?p ?o
 +
WHERE {
 +
    ?s ?p ?o .
 +
}
 +
===select the interestes of Cade===
 +
 +
SELECT ?cadeInterest
 +
WHERE {
 +
    ex:Cade ex:interest ?cadeInterest .
 +
}
 +
===select the country and city where Emma lives===
 +
 +
SELECT ?emmaCity ?emmaCountry
 +
WHERE {
 +
    ex:Emma ex:address ?address .
 +
  ?address ex:city ?emmaCity .
 +
  ?address ex:country ?emmaCountry .
 +
}
 +
===select the people who are over 26 years old===
 +
 +
SELECT ?person ?age
 +
WHERE {
 +
    ?person ex:age ?age .
 +
  FILTER(?age > 26) .   
 +
}
 +
===select people who graduated with Bachelor===
 +
 +
SELECT ?person ?degree
 +
WHERE {
 +
    ?person ex:degree ?degree .
 +
  ?degree ex:degreeLevel "Bachelor" .
 +
         
 +
}
 +
===delete cades photography interest===
 +
 +
DELETE DATA
 +
{
 +
    ex:Cade ex:interest ex:Photography .
 +
}
 +
===delete and insert university of valencia===
 +
 +
DELETE { ?s ?p ex:University_of_Valencia }
 +
INSERT { ?s ?p ex:Universidad_de_Valencia }
 +
WHERE  { ?s ?p ex:University_of_Valencia }
 +
 +
===check if the deletion worked===
 +
 +
SELECT ?s ?o2
 +
WHERE  {
 +
  ?s ex:degree ?o .
 +
  ?o ex:degreeSource ?o2 .
 +
      }
 +
 +
===insert Sergio===
 +
 +
INSERT DATA {
 +
  ex:Sergio a foaf:Person ;
 +
    ex:address [ a ex:Address ;
 +
            ex:city ex:Valenciay ;
 +
            ex:country ex:Spain ;
 +
            ex:postalCode "46021"^^xsd:string ;
 +
            ex:state ex:California ;
 +
            ex:street "4_Carrer_del_Serpis"^^xsd:string ] ;
 +
    ex:degree [ ex:degreeField ex:Computer_science ;
 +
            ex:degreeLevel "Master"^^xsd:string ;
 +
            ex:degreeSource ex:University_of_Valencia ;
 +
            ex:year "2008"^^xsd:gYear ] ;
 +
    ex:expertise ex:Big_data,
 +
        ex:Semantic_technologies,
 +
        ex:Machine_learning;
 +
    foaf:name "Sergio_Pastor"^^xsd:string .
 +
}
 +
     
 +
===describe Sergio===
 +
 +
DESCRIBE ex:Sergio ?o
 +
WHERE {
 +
  ex:Sergio ?p ?o .
 +
  ?o ?p2 ?o2 .
 +
  }
 +
 +
===construct that any city is in the country in an address===
 +
 +
CONSTRUCT {?city ex:locatedIn ?country}
 +
Where {
 +
  ?s rdf:type ex:Address .
 +
  ?s ex:city ?city .
 +
  ?s ex:country ?country.
 +
  }
 
   
 
   
 
  SELECT DISTINCT ?p WHERE {
 
  SELECT DISTINCT ?p WHERE {

Revision as of 16:03, 11 February 2022

This page will be updated with SPARQL examples as the course progresses.