Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: DBTune - Playcount data linking BBC /programmes and Musicbrainz Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0:

DBTune.org

 Chris@0: Chris@0:
Playcount data linking BBC /programmes and Musicbrainz
Chris@0: Chris@0:

1. Introduction

Chris@0: Chris@11:

Note: This service is down following changes to the upstream API. This page is retained for historical interest.

Chris@11: Chris@0:

Chris@0: The BBC has made available a dataset of playcounts of artists Chris@0: per episode and brands in their programmes catalogue, for the Mashed 2008 event. Chris@0:

Chris@0: Chris@0:

Chris@0: This service provides RDF links using these playcounts, to link the Chris@0: Musicbrainz linked data and the Chris@0: BBC programmes linked data. Chris@0: The earlier is designed with the Music Ontology, the latter is designed with the BBC Programmes ontology. Chris@0:

Chris@0: Chris@0:

Chris@0: This effort is part of the Linking Chris@0: Open Data on the Semantic Web community project, hosted by the Semantic Chris@0: Web Education and Outreach interest group. Chris@0:

Chris@0: Chris@0: Chris@0: Chris@0:

2. Using this service

Chris@0:

Chris@0: A playcount URI in this service looks like: Chris@0: 

Chris@0: http://dbtune.org/bbc/playcount/<id>_<k>
Chris@0:
Chris@0: Where <id> is the id of the episode or the brand, as in Chris@0: /programmes BBC catalogue, Chris@0: and <k> is a number between 0 and the number of playcounts Chris@0: for the episode or the brand. Chris@0:

Chris@0: Chris@0:

Chris@0: For example, the following URI corresponds to the playcount of Chris@0: Prince on Chris@0: the Fabio and Grooverider DJ show. Chris@0: 

Chris@0: http://dbtune.org/bbc/playcount/b006wk6f_1
Chris@0:
Chris@0:

Chris@0: Chris@0:

3. Querying the dataset

Chris@0:

Chris@0: We expose a SPARQL end-point Chris@0: for querying this data, and also a web interface for this end-point. Chris@0: The SPARQL end-point also holds aggregated information (around 2 million triples) from Chris@0: Musicbrainz and the BBC Programmes service. Chris@0: The end-point is available at: Chris@0: 

http://dbtune.org:3062/sparql
Chris@0:

Chris@0: Chris@0:

Chris@0: An example query is the following one: Chris@0: 

Chris@0: SELECT ?brand ?title ?count
Chris@0: WHERE {
Chris@0:    ?artist a mo:MusicArtist;
Chris@0:       foaf:name "The Beatles". 
Chris@0:    ?pc pc:object ?artist;
Chris@0:        pc:count ?count.
Chris@0:    ?brand a po:Brand;
Chris@0:        pc:playcount ?pc;
Chris@0:        dc:title ?title 
Chris@0:     FILTER (?count>10)}
Chris@0:
Chris@0: This will return every BBC brands in which The Beatles were featured at least ten times. Chris@0:

Chris@0: Chris@0:

4. Playcount ontology

Chris@0:

Chris@0: For the purpose of representing playcounts, we designed a really Chris@0: small playcount ontology. Chris@0: This ontology defines one playcount concept, and three properties Chris@0: to link it to the media in which we are counting something, the actual thing, Chris@0: and actual playcount. This ontology can be used as in the following Chris@0: example: Chris@0:

Chris@0: 
Chris@0: :radioepisode pc:playcount [a pc:Playcount; pc:count 12; pc:object :track].
Chris@0:
Chris@0: Chris@0:

5. Code

Chris@0:

Chris@0: As usual, all the code running this service Chris@0: is open source and based Chris@0: on SWI-Prolog Chris@0:

Chris@0: Chris@0:

6. Statistics

Chris@0:

Chris@0: Chris@0: Chris@0: Chris@0: Chris@0:
Triple count1,954,786
Distinct BBC Programmes Chris@0: resources6,863
Distinct Musicbrainz Chris@0: resources7,055
Chris@0:

Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: Chris@0: