Queries — Task 2

Q2.1

SELECT ?resource_iri  ?affiliation_fullname  ?author_iri  ?author_fullname WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-1215/#paper-01>
        <http://ceur-ws.org/Vol-1302/#invited>
        <http://ceur-ws.org/Vol-1302/#paper2>
    }

    ?author_iri foaf:made ?paper .
    ?author_iri foaf:name ?author_fullname .
    ?author_iri swrc:affiliation ?resource_iri .
    ?resource_iri bibo:name ?affiliation_fullname
}

Q2.2

SELECT DISTINCT ?paper_iri ?title {
    VALUES ?workshop {
        <http://ceur-ws.org/Vol-315/>
    }

    ?paper_iri dcterms:partOf ?workshop .
    ?author_iri foaf:made ?paper_iri .
    ?paper_iri dc:title ?title .
    ?author_iri swrc:affiliation ?org_iri .
    ?org_iri dbpedia-owl:country ?country_iri .
    ?country_iri foaf:name ?country_name .
    FILTER (?country_name='Germany')

    }

Q2.3

SELECT DISTINCT ?resource_iri ?title ?doi WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-1302/#paper7>
    } .
    ?paper bibo:cites ?resource_iri .
    ?resource_iri bibo:title ?title
    OPTIONAL { ?resource_iri bibo:doi ?doi }
}

Q2.4

SELECT DISTINCT ?resource_iri ?title ?publication_year WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-1302/#paper7>
    } .
    ?paper bibo:cites ?resource_iri .
    ?resource_iri bibo:title ?title .
    ?resource_iri bibo:created ?publication_year
    OPTIONAL { ?resource_iri bibo:doi ?doi }
    FILTER (?publication_year > '2012')
}

Q2.5

SELECT ?resource_iri ?doi ?paper_title ?journal_title { VALUES ?paper_iri { http://ceur-ws.org/Vol-1302/#paper7 } ?paper_iri bibo:cites ?resource_iri . ?resource_iri bibo:isPartOf ?journal_iri . ?resource_iri bibo:title ?paper_title . ?journal_iri bibo:title ?journal_title OPTIONAL {?resource_iri bibo:doi ?doi} }

Q2.6

PREFIX ns1: <http://vocab.ox.ac.uk/projectfunding#>
SELECT DISTINCT ?resource_iri ?grant_identifier ?grant_name WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-315/#paper1>
        <http://ceur-ws.org/Vol-1302/#paper5>
    } .
  ?resource_iri ns1:funds ?paper .
  ?resource_iri rdf:type ns1:Grant
  OPTIONAL { ?resource_iri bibo:name ?grant_name }
  OPTIONAL { ?resource_iri ns1:grantNumber ?grant_identifier }
}

Q2.7

PREFIX ns1: <http://vocab.ox.ac.uk/projectfunding#>
SELECT DISTINCT ?funding_agency_iri ?funding_agency_name  WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-1123/#paper5>
        <http://ceur-ws.org/Vol-1155/#paper-04>
    } .
    ?funding_agency_iri ns1:funds ?paper .
    ?funding_agency_iri rdf:type foaf:Organization .
    ?funding_agency_iri bibo:name ?funding_agency_name .
}

Q2.8

PREFIX ns1: <http://vocab.ox.ac.uk/projectfunding#>
SELECT DISTINCT ?project_iri ?project_name  WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-1123/#paper4>
        <http://ceur-ws.org/Vol-1123/#paper5>
    } .
    ?project_iri ns1:funds ?paper .
    ?project_iri rdf:type ns1:Project .
    ?project_iri bibo:name ?project_name .
}

Q2.9

PREFIX owl: http://www.w3.org/2002/07/owl# SELECT DISTINCT ?ontology_iri ?ontology_name WHERE { VALUES ?paper { http://ceur-ws.org/Vol-571/#paper4 http://ceur-ws.org/Vol-315/#paper6 } . ?paper bibo:reviewOf ?ontology_iri . ?ontology_iri rdf:type owl:Ontology . ?ontology_iri rdfs:label ?ontology_name . }

Q2.10

PREFIX owl: <http://www.w3.org/2002/07/owl#>
SELECT DISTINCT ?resource_iri ?ontology_name  WHERE {
    VALUES ?paper {
        <http://ceur-ws.org/Vol-1302/#paper1>
        <http://ceur-ws.org/Vol-315/#paper6>
    } .
    ?paper bibo:presents ?resource_iri .
    ?resource_iri rdf:type owl:Ontology .
    ?resource_iri rdfs:label ?ontology_name .
}