Skip to content

Musical Data on the Web. Script to generate the RDF dataset from the managed CSV.

Notifications You must be signed in to change notification settings

lpugin/registry-data

 
 

Repository files navigation

The Polifonia Registry

The Polifonia registry of musical resources on the Web is https://w3id.org/musow

The previous version of musoW 1.0 is available at https://musow.kmi.open.ac.uk/.

This repository hosts the initial dataset of the registry (a fork of musoW 1.0). New data and final application are available at https://github.com/polifonia-project/registry_app.

==== From musoW 1.0

musoW: Musical Data on the web

musoW is a survey on musical data available on the web and a RDF dataset including results of the survey. Here you can find the script to generate the RDF dataset from the managed CSV and several SPARQL queries.

The musoW RDF dataset can be queried at https://data.open.ac.uk/sparql. Here an example resource for starting browsing the dataset: MIDI Linked Dataset. We also published a RESTful API to reproduce results.

A guide for querying musoW with SPARQL

The following selection of SPARQL queries is meant to be a useful guide to the user who wants to discover musical data available on the web and how to reuse it!

Table of contents

General queries

The following examples show an overview of resources gathered and described in musoW survey.

GQ1. How many resources have been included in the survey?

SELECT (COUNT(?s) as ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?s <http://xmlns.com/foaf/0.1/homepage> ?o .
}

GQ2. Which types of resource have been included in the survey?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?label (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   	?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?type .
   	?type rdfs:label ?label .
}

GROUP BY ?label ?count
ORDER BY desc(?count)

GQ3. Which criteria have been used to gather such resources? How many resources have been gathered by means of a criterion?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?searchCriterion ?label (count(?s) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?s <http://purl.org/spar/fabio/hasSubjectTerm> ?searchCriterion .
   ?searchCriterion rdfs:label ?label .
}
GROUP BY ?searchCriterion ?label
ORDER BY desc(?count)

GQ4. What is the extent of gathered resources?

Results refer to the number of musical items collected by the described resources. When a Linked Dataset is described, the extent refers to the number of RDF triples.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?label (COUNT(?project) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?project <http://purl.org/dc/terms/extent> ?size .
  ?size rdfs:label ?label .
}
GROUP BY ?label
ORDER BY ?label

GQ5. What is the main data source of gathered resources?

Results refer to the original musical object described in the resource i.e. audio files, metadata or symbolic notations.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?resource <http://dbpedia.org/ontology/category> ?category .
  ?category rdfs:label ?categoryLabel .
}
GROUP BY ?categoryLabel
ORDER BY ?categoryLabel

GQ6. What is the target audience of gathered resources?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count) ?audience
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?resource <http://purl.org/dc/terms/audience> ?typeaudience .
  ?typeaudience rdfs:label ?audience .
}
GROUP BY ?audience
ORDER BY ?count

GQ7. In which kind of sources are researchers interested?

Results refer to resources that provide audio files, metadata or symbolic notation, as described in GQ5.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?resource <http://purl.org/dc/terms/audience> ?typeaudience ;
  			<http://dbpedia.org/ontology/category> ?category .
  ?category rdfs:label ?categoryLabel .
  ?typeaudience rdfs:label ?audience .
  filter(?audience="researchers") .
}
GROUP BY ?categoryLabel ?count
ORDER BY ?count

GQ8. How many resources are useful to both researchers and performers?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  	?resource <http://purl.org/dc/terms/audience> ?typeaudience .
  	?resource <http://purl.org/dc/terms/audience> ?typeaudience2 .
   	?typeaudience rdfs:label ?audience .
  	?typeaudience2 rdfs:label ?audience2 .
    filter(?audience="researchers" ) . filter(?audience2="performers").
}
GROUP BY ?audience
ORDER BY ?count

GQ9. How many resources are not targeted on researchers?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
    ?resource <http://purl.org/dc/terms/audience> ?typeaudience .
    ?typeaudience rdfs:label ?audience .
    FILTER(?audience NOT IN ('researchers')).
}

Catalogs

Among the resources gathered in the survey there are catalogs of online resources for musicologists, musicians and researchers in general. These ones have been used as sources for retrieving most of of the resources described in musoW.

CT1. How many resources have been gathered by means of catalogs?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?catalogueLabel (count(?resource) AS ?count)  
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?catalogue rdfs:label ?catalogueLabel ; <http://purl.org/spar/datacite/hasGeneralResourceType> ?catalogueType .
  ?catalogueType rdfs:label ?typeLabel .
  filter(?typeLabel="Catalogue") .
  ?resource <http://purl.org/spar/fabio/hasSubjectTerm> ?catalogue
}
GROUP BY ?catalogueLabel  

CT2. What's the focus of resources gathered by means of catalogs?

Results refer to the original sources analysed by the collected resources, i.e. audio files, notated music or simply cataloguing metadata.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?catalogue rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?catalogueType .
  ?catalogueType rdfs:label ?typeLabel . filter(?typeLabel="Catalogue") .
  ?resource <http://purl.org/spar/fabio/hasSubjectTerm> ?catalogue ;
            <http://dbpedia.org/ontology/category> ?category .
  ?category rdfs:label ?categoryLabel .
}
GROUP BY ?categoryLabel ?count
ORDER BY ?count

CT3. What type of resources gathered by means of catalogs?

e.g. datasets, repositories, digital editions.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceTypeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?catalogue rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?catalogueType .
   ?catalogueType rdfs:label ?typeLabel . filter(?typeLabel="Catalogue") .
   ?resource <http://purl.org/spar/fabio/hasSubjectTerm> ?catalogue ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?type .
   ?type rdfs:label ?resourceTypeLabel .
}
GROUP BY ?resourceTypeLabel ?count
ORDER BY ?count

CT4. What is the target audience of resources gathered by means of catalogs?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count) ?audience
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?catalogue rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?catalogueType .
   ?catalogueType rdfs:label ?typeLabel . filter(?typeLabel="Catalogue") .
   ?resource <http://purl.org/spar/fabio/hasSubjectTerm> ?catalogue ;
             <http://purl.org/dc/terms/audience> ?typeaudience .
   ?typeaudience rdfs:label ?audience .
}
GROUP BY ?audience
ORDER BY ?count

CT5. Considering resources gathered by catalogs targeted on researchers, performers and scholars, what is their extent?

Results refer to the estimated number of items collected by each resource.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count) ?extent
FROM <http://data.open.ac.uk/context/musow>
WHERE {
    ?resource <http://purl.org/dc/terms/audience> ?typeaudience ;
              <http://purl.org/dc/terms/audience> ?typeaudience2 ;
              <http://purl.org/dc/terms/audience> ?typeaudience3 ;
              <http://purl.org/dc/terms/extent> ?extenttype .
    ?extenttype rdfs:label ?extent .
    ?typeaudience rdfs:label ?audience .
    ?typeaudience2 rdfs:label ?audience2 .
    ?typeaudience3 rdfs:label ?audience3 .
    filter(?audience="researchers" ) . filter(?audience2="performers"). filter(?audience3="scholars").
}
GROUP BY ?extent
ORDER BY ?extent

CT6. Which catalogs, and how many times, are reused in other projects?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Catalogue') .
}
GROUP BY ?resourceLabel ?count
ORDER BY DESC(?count)

Digital libraries and repositories

We considere digital libraries as repositories of heterogeneous materials, meaning that different cultural objects are described - e.g. books, photographs, artworks, music scores. While repositories gather materials about one type of object, also providing different media (e.g. digitized scores, audio files, trascriptions of melody).

DR1. How may repositories and digital libraries are found?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .

}

DR2. What is the scale of repositories and digital libraries?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?extentLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?extent rdfs:label ?extentLabel .
}
GROUP BY ?extentLabel ?count
ORDER BY ?count

DR3. Which are the most/least used data formats?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?formatLabel ?count
ORDER BY DESC(?count)

DR4. What are the most/least used formats compared to scale?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?extentLabel ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?extent rdfs:label ?extentLabel . ?format rdfs:label ?formatLabel .
}
GROUP BY ?extentLabel ?formatLabel ?count
ORDER BY ?extentLabel DESC(?count)

DR5. How many use an interoperable/standard format?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://schema.org/featureList>
                  <http://data.open.ac.uk/musow/ontology/feature/interoperable> .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
}

DR6. How many of them provide digitizations of scores or songs?

Results refere to a combination of image formats that are generally used to publish music contents.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   filter( str(?format) IN ("http://data.open.ac.uk/musow/pdf" , "http://data.open.ac.uk/musow/jpg",
    "http://data.open.ac.uk/musow/tiff", "http://data.open.ac.uk/musow/iiif", "http://data.open.ac.uk/musow/gif", "http://data.open.ac.uk/musow/png", "http://data.open.ac.uk/musow/djvu"))
}

DR7. How many of them provide audio files?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   filter( str(?format) IN ("http://data.open.ac.uk/musow/midi" , "http://data.open.ac.uk/musow/mp3",
    "http://data.open.ac.uk/musow/audio", "http://data.open.ac.uk/musow/video", "http://data.open.ac.uk/musow/finale", "http://data.open.ac.uk/musow/sibelius", "http://data.open.ac.uk/musow/flac"))
}

DR8. How many of them provide structured data about notated music?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   filter( str(?format) IN ("http://data.open.ac.uk/musow/musicxml" , "http://data.open.ac.uk/musow/xml",
    "http://data.open.ac.uk/musow/rdf", "http://data.open.ac.uk/musow/mei/xml", "http://data.open.ac.uk/musow/cap/xml", "http://data.open.ac.uk/musow/humdrum", "http://data.open.ac.uk/musow/kern", "http://data.open.ac.uk/musow/lilypond", "http://data.open.ac.uk/musow/musedata", "http://data.open.ac.uk/musow/musescore", "http://data.open.ac.uk/musow/myr", "http://data.open.ac.uk/musow/noteworthy", "http://data.open.ac.uk/musow/py", "http://data.open.ac.uk/musow/ram", "http://data.open.ac.uk/musow/mu2"))
}

DR9. What is the scope of musical data in repositories and digital libraries?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?scopeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasScope> ?scope .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?scope rdfs:label ?scopeLabel .
}
GROUP BY ?scopeLabel ?count
ORDER BY DESC(?count)

DR10. What is the relation between scope and scale?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?extentLabel ?scopeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent ;
             <http://www.w3.org/ns/oa#hasScope> ?scope .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?scope rdfs:label ?scopeLabel . ?extent rdfs:label ?extentLabel .
}
GROUP BY ?scopeLabel ?extentLabel ?count
ORDER BY ?extentLabel DESC(?count)

DR11. What is the relation between scope and formats?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?scopeLabel ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasScope> ?scope ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?format rdfs:label ?formatLabel .
   ?scope rdfs:label ?scopeLabel .
}
GROUP BY ?scopeLabel ?formatLabel ?count
ORDER BY ?scopeLabel DESC(?count)

DR12. What is the relation between scope and machine readable data about symbolic notation?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?scopeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasScope> ?scope ;
             <http://schema.org/featureList>
                <http://data.open.ac.uk/musow/ontology/feature/symbolic-machine-readable> .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?scope rdfs:label ?scopeLabel .
}
GROUP BY ?scopeLabel ?count
ORDER BY ?scopeLabel DESC(?count)

DR13. What is the relation between the provision of structured data on symbolic notation and scale?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?extentLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent ;
             <http://schema.org/featureList>
                  <http://data.open.ac.uk/musow/ontology/feature/symbolic-machine-readable> .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?scope rdfs:label ?scopeLabel . ?extent rdfs:label ?extentLabel
}
GROUP BY ?extentLabel ?count
ORDER BY ?extentLabel DESC(?count)

DR14. Which features of symbolic notation are represented in repositories?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?featureLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?featureLabel ?count
ORDER BY DESC(?count)

DR15. Do the sources collected in digital libraries and repositories are audio tracks, symbolic notation or metadata?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://dbpedia.org/ontology/category> ?category .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?category rdfs:label ?categoryLabel .
}
GROUP BY ?categoryLabel ?count

DR16. How many repositories are free of charge?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/access/type> "Free" .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
}

DR17. Is this content properly licensed? What are the licences used?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?licenseLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/license> ?license .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?license rdfs:label ?licenseLabel .
}
GROUP BY ?licenseLabel ?count
ORDER BY DESC(?count)

DR18. What Is the audience of such resources?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?audience (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/audience> ?typeaudience .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?typeaudience rdfs:label ?audience .
}
GROUP BY ?audience ?count
ORDER BY DESC(?count)

DR19. What is the purpose of such resources? Learning or research?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?purposeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasPurpose> ?purpose .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?purpose rdfs:label ?purposeLabel .
}
GROUP BY ?purposeLabel ?count
ORDER BY DESC(?count)

DR20. What is the purpose of such resources? Entertainment?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/audience> ?typeaudience .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?typeaudience rdfs:label ?audience . filter(?audience IN ("amateurs", "listeners")) .
}

DR21. Is data published in repositories or digital libraries reused in other projects?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Repository")}
      UNION
   {?resourceType rdfs:label ?typeLabel . filter(?typeLabel="Digital Library")} .
   ?resource ^<http://www.w3.org/2004/02/skos/core#related> ?otherResource .
}
GROUP BY ?resourceLabel ?count
ORDER BY DESC(?count)

Datasets

DS1. How many datasets on musical data are available on the web?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
}

DS2. In which formats are datasets released?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?formatLabel ?count
ORDER BY DESC(?count)

DS3. What are the most/least used data formats compared to the scale?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?extentLabel ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?extent rdfs:label ?extentLabel . ?format rdfs:label ?formatLabel .
}
GROUP BY ?extentLabel ?formatLabel ?count
ORDER BY ?extentLabel DESC(?count)

DS4. What is the scope of datasets?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?scopeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasScope> ?scope .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?scope rdfs:label ?scopeLabel .
}
GROUP BY ?scopeLabel ?count
ORDER BY DESC(?count)

DS5. Which features of notated music are represented?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?featureLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?feature rdfs:label ?featureLabel .
}

GROUP BY ?featureLabel ?count
ORDER BY DESC(?count)

DS6. Does data represent features extracted from audio files, metadata or notated music?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://dbpedia.org/ontology/category> ?category .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?category rdfs:label ?categoryLabel .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?categoryLabel ?count
ORDER BY DESC(?count)

DS7. Which services are offered to access data?

e.g. API, SPARQL endpoint, queryable interfaces

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?feautureListLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://schema.org/featureList> ?feautureList .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?feautureList rdfs:label ?feautureListLabel .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?feautureListLabel ?count
ORDER BY DESC(?count)

DS8. What is the task or situation in which they claim to be useful?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?taskLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?task rdfs:label ?taskLabel .
}
GROUP BY ?taskLabel ?count
ORDER BY DESC(?count)

DS9. Is this content properly licensed? Which licences are used?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?licenseLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/license> ?license .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?license rdfs:label ?licenseLabel
}
GROUP BY ?licenseLabel ?count
ORDER BY DESC(?count)

DS10. What is the purpose? Learning or research?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?purposeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasPurpose> ?purpose .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?purpose rdfs:label ?purposeLabel .
}
GROUP BY ?purposeLabel ?count
ORDER BY DESC(?count)

DS11. What is the purpose? Entertainment?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/audience> ?typeaudience .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?typeaudience rdfs:label ?audience . filter(?audience IN ("amateurs", "listeners")) .
}

DS12. Is data reused in other projects?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             ^<http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
}

GROUP BY ?resourceLabel ?count
ORDER BY DESC(?count)

DS13. What’s the main source of LOD on music? Metadata, media or audio?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://dbpedia.org/ontology/category> ?category ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?format rdfs:label ?formatLabel . filter(?formatLabel='RDF')
   ?category rdfs:label ?categoryLabel .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?categoryLabel ?count
ORDER BY DESC(?count)

DS14. Which services they provide?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?feautureListLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://schema.org/featureList> ?feautureList ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?feautureList rdfs:label ?feautureListLabel .
   ?format rdfs:label ?formatLabel . filter(?formatLabel='RDF') .
}
GROUP BY ?feautureListLabel ?count
ORDER BY DESC(?count)

DS15. Which tasks or situations they address?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?taskLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?task rdfs:label ?taskLabel .
   ?format rdfs:label ?formatLabel . filter(?formatLabel='RDF').
}
GROUP BY ?taskLabel ?count
ORDER BY DESC(?count)

Linked Open Datasets

LD1. What’s the main source of LOD on music?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://dbpedia.org/ontology/category> ?category ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?format rdfs:label ?formatLabel . filter(?formatLabel='RDF')
   ?category rdfs:label ?categoryLabel .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?categoryLabel ?count
ORDER BY DESC(?count)

LD2. Which services they provide?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?feautureListLabel (count(DISTINCT ?resource) AS ?count)
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://schema.org/featureList> ?feautureList ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?feautureList rdfs:label ?feautureListLabel .
   ?format rdfs:label ?formatLabel . filter(?formatLabel='RDF') .
}
GROUP BY ?feautureListLabel ?count
ORDER BY DESC(?count)

LD3. In which tasks or situation are they used?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?taskLabel (count(DISTINCT ?resource) AS ?count)
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Dataset') .
   ?format rdfs:label ?formatLabel . filter(?formatLabel='RDF').
   ?task rdfs:label ?taskLabel .
}
GROUP BY ?taskLabel ?count
ORDER BY DESC(?count)

## Digital editions

DE1. How many digital editions on muscial contents are available?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
}

DE2. Which formats are mainly used?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?formatLabel ?count
ORDER BY DESC(?count)

DE3. What is their scope?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?scopeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/ns/oa#hasScope> ?scope .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?scope rdfs:label ?scopeLabel .
}
GROUP BY ?scopeLabel ?count
ORDER BY DESC(?count)

DE4. What is tehir scale?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT  ?extentLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent.
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?extent rdfs:label ?extentLabel .
}
GROUP BY ?extentLabel ?count
ORDER BY ?extentLabel DESC(?count)  

DE5. Do they offer playable objects?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://schema.org/featureList>
                <http://data.open.ac.uk/musow/ontology/feature/playable> .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
}

DE6. Which musical features are represented?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?featureLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?featureLabel ?count
ORDER BY DESC(?count) ?featureLabel

DE7. Do they represent features extracted from audio files, metadata or notated music?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://dbpedia.org/ontology/category> ?category .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?category rdfs:label ?categoryLabel .
}
GROUP BY ?categoryLabel ?count

DE8. Which services are offered to access data?

E.g. API, SPARQL endpoint

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?feautureListLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://schema.org/featureList> ?feautureList .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?feautureList rdfs:label ?feautureListLabel .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?feautureListLabel ?count
ORDER BY DESC(?count)

DE9. Which are the claimed tasks of digital editions?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?taskLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?task rdfs:label ?taskLabel .
}
GROUP BY ?taskLabel ?count
ORDER BY DESC(?count)

DE10. Are data reused in other projects?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             ^<http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
}
GROUP BY ?resourceLabel ?count
ORDER BY DESC(?count)

DE11. Which resources are mainly reused by these projects?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?otherLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?otherResource rdfs:label ?otherLabel
}
GROUP BY ?otherLabel ?count
ORDER BY DESC(?count)

DE12. In which situation/task are resources reused in digital editions?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?otherLabel ?taskLabel
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task ;
             <http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel='Digital edition') .
   ?task rdfs:label ?taskLabel .
   ?otherResource rdfs:label ?otherLabel
}
GROUP BY ?otherLabel ?taskLabel
ORDER BY ?otherLabel

Services and Sofwares

SS1. How many software and services are available on the web?

The focus of the survey is on data rather than SW, thus results might not be exhaustive. Moreover, results refer to resources that have been either reused or mentioned by projects included in the survey.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
  ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Software', 'Service')) .
}

SS2. Which standards/formats do they use?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Software', 'Service')) .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?formatLabel ?count
ORDER BY DESC(?count)

SS3. In which tasks or situations they are applied?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?taskLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Service', "Software")) .
   ?task rdfs:label ?taskLabel .
}
GROUP BY ?taskLabel ?count
ORDER BY DESC(?count)

SS4. Which features they deal with?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?featureLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Service', "Software")) .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?featureLabel ?count
ORDER BY DESC(?count) ?featureLabel

SS5. Which sources they use to extract features?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://dbpedia.org/ontology/category> ?category .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Service', "Software")) .
   ?category rdfs:label ?categoryLabel .
}
GROUP BY ?categoryLabel ?count
ORDER BY desc(?count)

SS6. Which resources they reuse?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?otherLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Service', "Software")) .
   ?otherResource rdfs:label ?otherLabel
}
GROUP BY ?otherLabel ?count
ORDER BY DESC(?count)

SS7. Which resources reuse them?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceLabel ?otherLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             ^<http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Service', "Software")) .
   ?otherResource rdfs:label ?otherLabel
}
GROUP BY ?resourceLabel ?otherLabel ?count
ORDER BY ?resourceLabel

Schemas and ontologies

SO1. How many ontologies and schemas are availabel for describing music domain?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
  ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Ontology', 'Schema')) .
}

SO2. Which sources they consider in describin musical features?

i.e. audio files, metadata or notated music .

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?categoryLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://dbpedia.org/ontology/category> ?category .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Ontology', "Schema")) .
   ?category rdfs:label ?categoryLabel .
}
GROUP BY ?categoryLabel ?count
ORDER BY desc(?count)

SO3. Which features are best described by means of them?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?featureLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Ontology', "Schema")) .
   ?feature rdfs:label ?featureLabel .
}
GROUP BY ?featureLabel ?count
ORDER BY DESC(?count) ?featureLabel

SO4. How many projects reuse them? Which one?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?resourceLabel ?otherLabel (count(DISTINCT ?otherResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?resourceLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             ^<http://www.w3.org/2004/02/skos/core#related> ?otherResource .
   ?resourceType rdfs:label ?typeLabel . filter(?typeLabel in ('Schema', "Ontology")) .
   ?otherResource rdfs:label ?otherLabel
}
GROUP BY ?resourceLabel ?otherLabel ?count
ORDER BY ?resourceLabel

Formats

FO1. Which formats are curently used in music domain? How many? And how many times have been used?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?formatLabel ?count
ORDER BY DESC(?count)

FO2. Are they interoperable or used in contexts where data are also provided in interoperable ways?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format ;
             <http://schema.org/featureList>
                  <http://data.open.ac.uk/musow/ontology/feature/interoperable> .
   ?resourceType rdfs:label ?typeLabel .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?formatLabel ?count
ORDER BY DESC(?count)

FO3. What is the realtion between the usage of formats and scale of resources?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?extentLabel ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource rdfs:label ?catalogueLabel ;
             <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://purl.org/dc/terms/extent> ?extent ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?resourceType rdfs:label ?typeLabel .
   ?extent rdfs:label ?extentLabel . ?format rdfs:label ?formatLabel .
}
GROUP BY ?extentLabel ?formatLabel ?count
ORDER BY ?extentLabel DESC(?count)

FO4. Which musical features do they mostly represent?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT  ?featureLabel ?formatLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://data.open.ac.uk/musow/ontology/scope/format> ?format .
   ?feature rdfs:label ?featureLabel . ?format rdfs:label ?formatLabel .
}
GROUP BY ?featureLabel ?formatLabel ?count
ORDER BY  DESC(?count)

FO5. In which situations/tasks are they used? How many times?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?formatLabel ?taskLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://data.open.ac.uk/musow/ontology/scope/format> ?format ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?task rdfs:label ?taskLabel .
   ?format rdfs:label ?formatLabel .
}
GROUP BY ?taskLabel ?formatLabel ?count
ORDER BY ?formatLabel desc(?count)

## About symbolic notation

SN1. How many resources on the web offer a symbolic representation of music?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://schema.org/featureList>
                <http://data.open.ac.uk/musow/ontology/feature/symbolic-machine-readable> .
}

SN2. How much of the content on the Web representing symbolic notation is machine readable?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?extentLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://schema.org/featureList>
                <http://data.open.ac.uk/musow/ontology/feature/symbolic-machine-readable> ;
             <http://purl.org/dc/terms/extent> ?extent.
  ?extent rdfs:label ?extentLabel .
}
GROUP BY ?extentLabel ?count
ORDER BY desc(?count)

SN3. Which type of resource deals more with symbolic notation?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?typeLabel (count(DISTINCT ?resource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://schema.org/featureList>
                  <http://data.open.ac.uk/musow/ontology/feature/symbolic-machine-readable> .
  ?resourceType rdfs:label ?typeLabel .
  ?extent rdfs:label ?extentLabel .
}
GROUP BY ?typeLabel ?count
ORDER BY desc(?count)

SN4. Which type of resource deals more with symbolic notation when compared to the total number of those type of resources?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?typeLabel (count(DISTINCT ?resource) AS ?symbCount) (count(DISTINCT ?genResource) AS ?count)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?genResource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType .
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://schema.org/featureList>
                  <http://data.open.ac.uk/musow/ontology/feature/symbolic-machine-readable> .
  ?resourceType rdfs:label ?typeLabel .  
}
GROUP BY ?typeLabel ?symbCount ?count
ORDER BY desc(?count)

SN5. Which symbolic features are more/less represented?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?featureLabel (count(DISTINCT ?resource) AS ?symbCount)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature .
  ?resourceType rdfs:label ?typeLabel .
  ?feature rdfs:label ?featureLabel
}
GROUP BY ?featureLabel ?symbCount
ORDER BY desc(?symbCount)

SN6. Which symbolic features are more/less represented when compared to the scale of those type of resources?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?featureLabel ?extentLabel (count(DISTINCT ?resource) AS ?symbCount)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://purl.org/spar/datacite/hasGeneralResourceType> ?resourceType ;
             <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://purl.org/dc/terms/extent> ?extent.
  ?resourceType rdfs:label ?typeLabel .
  ?extent rdfs:label ?extentLabel .
  ?feature rdfs:label ?featureLabel
}
GROUP BY ?featureLabel ?extentLabel ?symbCount
ORDER BY desc(?symbCount)

SN7. How many projects extract features/metadata from audio files rather than scores?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?typeLabel (count(DISTINCT ?resource) AS ?symbCount)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
  ?resource <http://dbpedia.org/ontology/category> ?resourceType .
  ?resourceType rdfs:label ?typeLabel .
}
GROUP BY ?typeLabel ?symbCount
ORDER BY ?typeLabel desc(?symbCount)

SN8. Which one (audio/score) offers more information on features?

i.e. how many resources dealing with audio offer information on melody, harmony, rhythm… and how many resources focused on scores offer the same information?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?typeLabel ?featureLabel (count(DISTINCT ?resource) AS ?symbCount)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://dbpedia.org/ontology/category> ?resourceType .
  ?resourceType rdfs:label ?typeLabel .
  ?feature rdfs:label ?featureLabel .
}
GROUP BY ?typeLabel ?featureLabel ?symbCount
ORDER BY ?typeLabel desc(?symbCount) ?featureLabel

SN9. When features are represented, what are the main tasks?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?taskLabel ?featureLabel (count(DISTINCT ?resource) AS ?symbCount)
FROM <http://data.open.ac.uk/context/musow>
WHERE {
   ?resource <http://xmlns.com/foaf/0.1/primaryTopic> ?feature ;
             <http://data.open.ac.uk/musow/ontology/situation/task> ?task .
   ?task rdfs:label ?taskLabel .
  ?feature rdfs:label ?featureLabel .
}
GROUP BY ?taskLabel ?featureLabel ?symbCount
ORDER BY ?taskLabel  ?featureLabel desc(?symbCount)

About

Musical Data on the Web. Script to generate the RDF dataset from the managed CSV.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Jupyter Notebook 77.2%
  • PHP 21.9%
  • JavaScript 0.9%