Mercurial > hg > dbtune-rdf-services

annotate magnatune/sparql-archived/magnatune_mapping.n3 @ 27:d95e683fbd35 tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Enable CORS on urispace redirects as well
author Chris Cannam
date Tue, 20 Feb 2018 14:52:02 +0000
parents df9685986338
children
rev   line source
Chris@0 1 @prefix map: <file:/home/moustaki/work/workspace/opendata/d2r-server-0.3.1/mapping.n3#> .
Chris@0 2 @prefix db: <> .
Chris@0 3 @prefix dc: <http://purl.org/dc/elements/1.1/>.
Chris@0 4 @prefix vocab: <vocab/> .
Chris@0 5 @prefix tl: <http://purl.org/NET/c4dm/timeline.owl#>.
Chris@0 6 @prefix event: <http://purl.org/NET/c4dm/event.owl#>.
Chris@0 7 @prefix foaf: <http://xmlns.com/foaf/0.1/>.
Chris@0 8 @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
Chris@0 9 @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
Chris@0 10 @prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
Chris@0 11 @prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
Chris@0 12 @prefix time: <http://www.w3.org/TR/owl-time/>.
Chris@0 13 @prefix mo: <http://purl.org/ontology/mo/> .
Chris@0 14 @prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .
Chris@0 15 @prefix bio: <http://purl.org/vocab/bio/0.1/>.
Chris@0 16
Chris@0 17 <> a d2r:Server;
Chris@0 18 rdfs:label "DBTune Server, powered by D2R";
Chris@0 19 d2r:baseURI <http://dbtune.org/magnatune/>;
Chris@0 20 d2r:port 2020;
Chris@0 21 d2r:documentMetadata [
Chris@0 22 rdfs:comment "This D2R server deals with RDF dumps of some creative-commons music libraries";
Chris@0 23 ];
Chris@0 24 .
Chris@0 25
Chris@0 26 map:database a d2rq:Database;
Chris@0 27 d2rq:jdbcDriver "com.mysql.jdbc.Driver";
Chris@0 28 d2rq:jdbcDSN "jdbc:mysql://localhost/magnatune?autoReconnect=true";
Chris@0 29 d2rq:username "yves";
Chris@0 30 d2rq:password "$0Me4nT!c";
Chris@0 31 #d2rq:resultSizeLimit 500;
Chris@0 32 .
Chris@0 33
Chris@0 34
Chris@0 35
Chris@0 36 #Tuning the mapping to match the music ontology
Chris@0 37
Chris@0 38 # TRACK
Chris@0 39 map:magnatune_song a d2rq:ClassMap;
Chris@0 40 d2rq:dataStorage map:database;
Chris@0 41 d2rq:uriPattern "track/@@magnatune_song_info.songid@@";
Chris@0 42 d2rq:class mo:Track;
Chris@0 43 .
Chris@0 44 map:magnatune_song_trackname a d2rq:PropertyBridge;
Chris@0 45 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 46 d2rq:property dc:title;
Chris@0 47 d2rq:column "magnatune_song_info.trackname";
Chris@0 48 d2rq:datatype xsd:string;
Chris@0 49 .
Chris@0 50 map:magnatune_song_tracklabel a d2rq:PropertyBridge;
Chris@0 51 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 52 d2rq:property rdfs:label;
Chris@0 53 d2rq:column "magnatune_song_info.trackname";
Chris@0 54 d2rq:datatype xsd:string;
Chris@0 55 .
Chris@0 56 map:magnatune_song_tracknum a d2rq:PropertyBridge;
Chris@0 57 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 58 d2rq:property mo:track_number;
Chris@0 59 d2rq:column "magnatune_song_info.tracknum";
Chris@0 60 d2rq:datatype xsd:int;
Chris@0 61 .
Chris@0 62 map:magnatune_song_download a d2rq:PropertyBridge;
Chris@0 63 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 64 d2rq:property mo:available_as;
Chris@0 65 d2rq:uriColumn "magnatune_song_info.download_mp3";
Chris@0 66 .
Chris@0 67 map:magnatune_song_buy a d2rq:PropertyBridge;
Chris@0 68 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 69 d2rq:property mo:paid_download;
Chris@0 70 d2rq:uriColumn "magnatune_song_info.buy";
Chris@0 71 .
Chris@0 72 map:magnatune_song_creator a d2rq:PropertyBridge;
Chris@0 73 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 74 d2rq:property foaf:maker;
Chris@0 75 d2rq:uriPattern "artist/@@magnatune_song_info.page@@";
Chris@0 76 .
Chris@0 77 map:magnatune_song_date a d2rq:PropertyBridge;
Chris@0 78 d2rq:belongsToClassMap map:magnatune_song;
Chris@0 79 d2rq:property dc:created;
Chris@0 80 d2rq:column "magnatune_song_info.launchdate";
Chris@0 81 d2rq:datatype xsd:date;
Chris@0 82 .
Chris@0 83
Chris@0 84 # ALBUM
Chris@0 85 map:magnatune_album a d2rq:ClassMap;
Chris@0 86 d2rq:dataStorage map:database;
Chris@0 87 d2rq:uriPattern "album/@@magnatune_song_info.albumsku@@";
Chris@0 88 d2rq:class mo:Record;
Chris@0 89 .
Chris@0 90 map:magnatune_hastrack a d2rq:PropertyBridge;
Chris@0 91 d2rq:belongsToClassMap map:magnatune_album;
Chris@0 92 d2rq:property mo:track;
Chris@0 93 d2rq:uriPattern "track/@@magnatune_song_info.songid@@";
Chris@0 94 .
Chris@0 95 map:magnatune_albumname a d2rq:PropertyBridge;
Chris@0 96 d2rq:belongsToClassMap map:magnatune_album;
Chris@0 97 d2rq:property dc:title;
Chris@0 98 d2rq:column "magnatune_song_info.albumname";
Chris@0 99 d2rq:datatype xsd:string;
Chris@0 100 .
Chris@0 101 map:magnatune_publishinglocation a d2rq:PropertyBridge;
Chris@0 102 d2rq:belongsToClassMap map:magnatune_album;
Chris@0 103 d2rq:property mo:publishing_location;
Chris@0 104 d2rq:uriPattern "http://dbpedia.org/resource/@@magnatune_song_info.country@@";
Chris@0 105 .
Chris@0 106 map:magnatune_albumlabel a d2rq:PropertyBridge;
Chris@0 107 d2rq:belongsToClassMap map:magnatune_album;
Chris@0 108 d2rq:property rdfs:label;
Chris@0 109 d2rq:column "magnatune_song_info.albumname";
Chris@0 110 d2rq:datatype xsd:string;
Chris@0 111 .
Chris@0 112 map:magnatune_album_creator a d2rq:PropertyBridge;
Chris@0 113 d2rq:belongsToClassMap map:magnatune_album;
Chris@0 114 d2rq:property foaf:maker;
Chris@0 115 d2rq:uriPattern "artist/@@magnatune_song_info.page@@";
Chris@0 116 .
Chris@0 117
Chris@0 118 # ARTIST
Chris@0 119 map:magnatune_artist a d2rq:ClassMap;
Chris@0 120 d2rq:dataStorage map:database;
Chris@0 121 d2rq:uriPattern "artist/@@magnatune_song_info.page@@";
Chris@0 122 d2rq:class mo:MusicArtist;
Chris@0 123 .
Chris@0 124 map:magnatune_artistname a d2rq:PropertyBridge;
Chris@0 125 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 126 d2rq:property foaf:name;
Chris@0 127 d2rq:column "magnatune_song_info.artist";
Chris@0 128 d2rq:datatype xsd:string;
Chris@0 129 .
Chris@0 130 map:magnatune_artistlabel a d2rq:PropertyBridge;
Chris@0 131 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 132 d2rq:property rdfs:label;
Chris@0 133 d2rq:column "magnatune_song_info.artist";
Chris@0 134 d2rq:datatype xsd:string;
Chris@0 135 .
Chris@0 136 map:magnatune_artistdesc a d2rq:PropertyBridge;
Chris@0 137 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 138 d2rq:property dc:description;
Chris@0 139 d2rq:column "magnatune_song_info.artistdesc";
Chris@0 140 d2rq:datatype xsd:string;
Chris@0 141 .
Chris@0 142 map:magnatune_artistbio a d2rq:PropertyBridge;
Chris@0 143 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 144 d2rq:property bio:olb;
Chris@0 145 d2rq:column "magnatune_song_info.bio";
Chris@0 146 d2rq:datatype xsd:string;
Chris@0 147 .
Chris@0 148 map:magnatune_artistimg a d2rq:PropertyBridge;
Chris@0 149 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 150 d2rq:property foaf:img;
Chris@0 151 d2rq:uriColumn "magnatune_song_info.bandphoto";
Chris@0 152 .
Chris@0 153 map:magnatune_artisthp a d2rq:PropertyBridge;
Chris@0 154 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 155 d2rq:property foaf:homepage;
Chris@0 156 d2rq:uriColumn "magnatune_song_info.home";
Chris@0 157 .
Chris@0 158 map:magnatune_basednear a d2rq:PropertyBridge;
Chris@0 159 d2rq:belongsToClassMap map:magnatune_artist;
Chris@0 160 d2rq:property foaf:based_near;
Chris@0 161 d2rq:uriPattern "http://dbpedia.org/resource/@@magnatune_song_info.country@@";
Chris@0 162 .
Chris@0 163
Chris@0 164
Chris@0 165 # SIGNAL
Chris@0 166 map:magnatune_signal a d2rq:ClassMap;
Chris@0 167 d2rq:dataStorage map:database;
Chris@0 168 d2rq:uriPattern "signal/@@magnatune_song_info.songid@@";
Chris@0 169 d2rq:class mo:Signal;
Chris@0 170 .
Chris@0 171 map:magnatune_signallabel a d2rq:PropertyBridge;
Chris@0 172 d2rq:belongsToClassMap map:magnatune_signal;
Chris@0 173 d2rq:property rdfs:label;
Chris@0 174 d2rq:pattern "signal @@magnatune_song_info.songid@@";
Chris@0 175 d2rq:datatype xsd:string;
Chris@0 176 .
Chris@0 177 map:magnatune_publi a d2rq:PropertyBridge;
Chris@0 178 d2rq:belongsToClassMap map:magnatune_signal;
Chris@0 179 d2rq:property mo:published_as;
Chris@0 180 d2rq:uriPattern "track/@@magnatune_song_info.songid@@";
Chris@0 181 .
Chris@0 182 map:magnatune_signaltime a d2rq:PropertyBridge;
Chris@0 183 d2rq:belongsToClassMap map:magnatune_signal;
Chris@0 184 d2rq:property mo:time;
Chris@0 185 d2rq:uriPattern "timeinterval/@@magnatune_song_info.songid@@";
Chris@0 186 .
Chris@0 187
Chris@0 188 # TIME INTERVAL
Chris@0 189 map:magnatune_time_interval a d2rq:ClassMap;
Chris@0 190 d2rq:dataStorage map:database;
Chris@0 191 d2rq:uriPattern "timeinterval/@@magnatune_song_info.songid@@";
Chris@0 192 d2rq:class time:Interval;
Chris@0 193 .
Chris@0 194 map:magnatune_tilabel a d2rq:PropertyBridge;
Chris@0 195 d2rq:belongsToClassMap map:magnatune_time_interval;
Chris@0 196 d2rq:property rdfs:label;
Chris@0 197 d2rq:pattern "time interval @@magnatune_song_info.songid@@";
Chris@0 198 d2rq:datatype xsd:string;
Chris@0 199 .
Chris@0 200 map:magnatune_ti a d2rq:PropertyBridge;
Chris@0 201 d2rq:belongsToClassMap map:magnatune_time_interval;
Chris@0 202 d2rq:property tl:duration;
Chris@0 203 d2rq:pattern "PT@@magnatune_song_info.seconds@@S";
Chris@0 204 d2rq:datatype xsd:duration;
Chris@0 205 .
Chris@0 206 map:magnatune_tl a d2rq:PropertyBridge;
Chris@0 207 d2rq:belongsToClassMap map:magnatune_time_interval;
Chris@0 208 d2rq:property tl:onTimeLine;
Chris@0 209 d2rq:uriPattern "timeline/@@magnatune_song_info.songid@@";
Chris@0 210 .
Chris@0 211
Chris@0 212 # RELATIVE TIME LINE
Chris@0 213 map:magnatune_timeline a d2rq:ClassMap;
Chris@0 214 d2rq:dataStorage map:database;
Chris@0 215 d2rq:uriPattern "timeline/@@magnatune_song_info.songid@@";
Chris@0 216 d2rq:class tl:RelativeTimeLine;
Chris@0 217 .
Chris@0 218 map:magnatune_tllabel a d2rq:PropertyBridge;
Chris@0 219 d2rq:belongsToClassMap map:magnatune_timeline;
Chris@0 220 d2rq:property rdfs:label;
Chris@0 221 d2rq:pattern "timeline @@magnatune_song_info.songid@@";
Chris@0 222 d2rq:datatype xsd:string;
Chris@0 223 .
Chris@0 224
Chris@0 225
Chris@0 226 # PERFORMANCE
Chris@0 227 map:magnatune_performance a d2rq:ClassMap;
Chris@0 228 d2rq:dataStorage map:database;
Chris@0 229 d2rq:uriPattern "performance/@@magnatune_song_info.songid@@";
Chris@0 230 d2rq:class mo:Performance;
Chris@0 231 .
Chris@0 232 map:magnatune_perflabel a d2rq:PropertyBridge;
Chris@0 233 d2rq:belongsToClassMap map:magnatune_performance;
Chris@0 234 d2rq:property rdfs:label;
Chris@0 235 d2rq:pattern "performance @@magnatune_song_info.songid@@";
Chris@0 236 d2rq:datatype xsd:string;
Chris@0 237 .
Chris@0 238 map:magnatune_perfcomment a d2rq:PropertyBridge;
Chris@0 239 d2rq:belongsToClassMap map:magnatune_performance;
Chris@0 240 d2rq:property rdfs:comment;
Chris@0 241 d2rq:pattern "I wonder it it is really useful for now, but it can be an anchor point for further information";
Chris@0 242 d2rq:datatype xsd:string;
Chris@0 243 .
Chris@0 244 map:magnatune_recordedAs a d2rq:PropertyBridge;
Chris@0 245 d2rq:belongsToClassMap map:magnatune_performance;
Chris@0 246 d2rq:property mo:recorded_as;
Chris@0 247 d2rq:uriPattern "signal/@@magnatune_song_info.songid@@";
Chris@0 248 .
Chris@0 249 map:magnatune_place a d2rq:PropertyBridge;
Chris@0 250 d2rq:belongsToClassMap map:magnatune_performance;
Chris@0 251 d2rq:property event:place;
Chris@0 252 d2rq:uriPattern "http://dbpedia.org/resource/@@magnatune_song_info.country@@"; # there is also .citystate
Chris@0 253 .
Chris@0 254 map:magnatune_performer a d2rq:PropertyBridge;
Chris@0 255 d2rq:belongsToClassMap map:magnatune_performance;
Chris@0 256 d2rq:property mo:performer;
Chris@0 257 d2rq:uriPattern "artist/@@magnatune_song_info.page@@";
Chris@0 258 .