Virtuoso Feb 1st Testing outline

[malajvan]

Documentation for whole lab testing:

• faceted browser: http://virtuoso.staging.simssa.ca/fct/
• SPARQL endpoint: https://virtuoso.staging.simssa.ca/sparql/
  (will need McGill VPN connections)

SPARQL queries

1. Select musical work and file with sibelius format

SELECT DISTINCT ?entity ?file
WHERE {
  ?entity ?fileField ?file.
  FILTER(STRSTARTS(STR(?fileField), "https://db.simssa.ca/files/"))
  ?file <http://www.wikidata.org/prop/direct/P2701> <http://www.wikidata.org/entity/Q27967347>.
}

2. Simssadb: Find musical works with titles containing "Ave Maria" and by composers who were born before the year 1500

SELECT DISTINCT ?contributor_name ?subjectEntity ?work
WHERE {
  {
    SELECT ?work ?contributor_name ?birthDate ?subjectEntity
    WHERE {
      ?work <http://www.wikidata.org/prop/direct/P1476> ?subjectEntity.
      ?subjectEntity bif:contains  '(AVE AND MARIA)'.
      ?work <http://www.wikidata.org/prop/direct/P767> ?contributor.
      ?contributor <http://www.wikidata.org/prop/direct/P2561> ?contributor_name.
      
SERVICE <https://query.wikidata.org/sparql> {
    ?contributor_name <http://www.wikidata.org/prop/direct/P569> ?birthDate.}
FILTER(YEAR(?birthDate) < 1600)

  
    }
  }
}

3. Wikidata language agnostic searches:

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?musicalWork  ?composer ?composer_name
WHERE {
  SERVICE <https://query.wikidata.org/sparql> {
    ?composer rdfs:label "若斯坎·德普雷"@zh.  
    ?composer rdfs:label ?composer_name.
   FILTER(LANG(?composer_name) = "en")
  }
  OPTIONAL {
    ?contributor <http://www.wikidata.org/prop/direct/P2561> ?composer.
    ?musicalWork <http://www.wikidata.org/prop/direct/P767> ?contributor.
  }
}

(without language tag)

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?musicalWork ?composer
WHERE {
SERVICE <https://query.wikidata.org/sparql> {
  ?composer wdt:P31 wd:Q5.
  ?composer wdt:P106 wd:Q36834.
  ?composer rdfs:label ?label.
  FILTER(STR(?label) = "若斯坎·德普雷").
}
  OPTIONAL {
    
    ?contributor <http://www.wikidata.org/prop/direct/P2561> ?composer.
    ?musicalWork <http://www.wikidata.org/prop/direct/P767> ?contributor.
  }
}

4. Test dbpedia: text search

SELECT * WHERE{
SERVICE <http://dbpedia.org/sparql> {
SELECT *
WHERE
  {
    ?s ?p ?o . 
?o bif:contains  '(MARTIN  AND LUTHER AND PRAISED AND COMPOSER)'
  }
}}

Exploring data on the browser

You can start with searching for a composer's name (ie. Josquin) with text search and traverse through the different triples.
Alternatively, you can search with a specific URL (http://www.wikidata.org/entity/Q143100 for Josquin des Prez) with "Entity URI Lookup)

Other suggestions:

• Text searching on text fields like Cantus' source description
• SPARQL endpoints: changing the params