Share
Embed
SPARQL入門 / SPARQL primer
https://doi.org/10.6084/m9.figshare.5947678
2016-12-19 JSTリンクト・データ(大規模文献情報・シソーラス)を使い倒そう!-LODC2016×J-GLOBAL knowledge連携イベント- の講演スライド http://lodc2016-jst.peatix.com
fumi
December 19, 2016
Transcript
62 slides
-
ΫΤϦݴޠ • ༻్ओʹσʔλૢ࡞ • σʔλϞσϧ%#γ εςϜʹ߹Θͤͯઃ ܭ 3%# ΫΤϦ
%# Ϟσϧ 3%' Ϟσϧ 42- 3FMBUJPOBM Ϟσϧ 3%' 41"32- -
άϥϑͷΫΤϦ • άϥϑͷ࠷খ୯Ґͭ τϦϓϧ • άϥϑύλʔϯ 1. શҰக ECS౦ژECPDPVOUSZECSຊ
2. มʹΑΔύλʔϯϚον ECS౦ژECPDPVOUSZ DPVOUSZ 3. ͱͷΈ߹Θͤ dbr:東京都 dbr:日本 dbo:country -
:Amy :Bob :Cathy :Dan :Jim :Ed :Kate :Gil :Flo :Hal
:Ian :Lee :May :like :like :like :like :like :like :like :dislike :dislike :dislike :dislike :dislike :dislike :dislike :dislike ͖ݏ͍άϥϑ -
:Amy :Bob :Cathy :Dan :Jim :Ed :Kate :Gil :Flo :Hal
:Ian :Lee :May :like :like :like :like :like :like :like :dislike :dislike :dislike :dislike :dislike :dislike :dislike :dislike "NZ͕͖ͳਓ άϥϑύλʔϯ "NZMJLF QFSTPO -
:Amy :Bob :Cathy :Dan :Jim :Ed :Kate :Gil :Flo :Hal
:Ian :Lee :May :like :like :like :like :like :like :like :dislike :dislike :dislike :dislike :dislike :dislike :dislike :dislike l"NZ͕͖ͳਓz͕͖ͳਓ άϥϑύλʔϯ "NZMJLF QFSTPO QFSTPOMJLF QFSTPO -
41"32-ΤϯυϙΠϯτ w 41"32-ΫΤϦΛड͚͚Δॴ w ϓϩάϥϜ͔Β41"32-Λ͏ͱ ͖ʹࢦఆ w ϒϥβͰΞΫηεͨ͠ͱ͖༻ʹ ϑΥʔϜ͕͋Δ߹ w
ྫIUUQKBECQFEJBPSHTQBSRM -
dbr:AdministraDveRegion dbr:サイボーグ009 dbo: ComicsCreator dbr:宮城県 dbr:石ノ森章太郎 rdfs:label rdf:type rdfs:label dbo:notableWork
dbo:award dbo:birthPlace rdf:type サイボーグ009 ٶݝ foaf:Person 石ノ森章太郎 rdf:type rdfs:label dbr:村井嘉浩 dbo:leaderName %#QFEJB+BQBOFTFͷάϥϑྫ dbr:手塚治虫 文化賞 dbo:Cartoon rdf:type 13&'*9ECSIUUQKBECQFEJBPSHSFTPVSDF 13&'*9ECPIUUQECQFEJBPSHPOUPMPHZ -
dbo:AdministraDveRegion dbr:サイボーグ009 dbo: ComicsCreator dbr:宮城県 dbr:石ノ森章太郎 rdfs:label rdf:type rdfs:label dbo:notableWork
dbo:award dbo:birthPlace rdf:type サイボーグ009 宮城県 foaf:Person 石ノ森章太郎 rdf:type rdfs:label dbr:村井嘉浩 dbo:leaderName dbr:手塚治虫 文化賞 dbo:Cartoon rdf:type ΫΤϦੴϊষଠͷग़ 13&'*9ECSIUUQKBECQFEJBPSHSFTPVSDF 13&'*9ECPIUUQECQFEJBPSHPOUPMPHZ 4&-&$5 CJSUI1MBDF 8)&3&\ ECSੴϊষଠECPCJSUI1MBDF CJSUI1MBDF ^ -
• SELECT: औಘ͍ͨ͠มΛࢦఆ • SELECT * શͯͷมࢦఆͱಉ • ݁Ռܗࣜ:
XML, JSON, CSV, TSV, ... • WHERE: {}ʹάϥϑύλʔϯͷΈ߹ΘͤΛهड़ • LIMIT: ݅ͷ੍ݶ • 100ͩͱ1-100·Ͱऔಘ • LIMIT͕ͳ͍߹શ݅औಘ • ྔ͕ଟ͍߹αʔόʹෛՙΛ͔͚ΔͷͰҙ • PREFIX: URIΛॖͯ͠هड़͢ΔͨΊͷΈ • dbr:౦ژ = <h^p://ja.dbpedia.org/resource/౦ژ> 13&'*9ECSIUUQKBECQFEJBPSHSFTPVSDF 13&'*9ECPIUUQECQFEJBPSHPOUPMPHZ 4&-&$5 CJSUI1MBDF 8)&3&\ ECSੴϊষଠECPCJSUI1MBDF CJSUI1MBDF ^ -
dbo:AdministraDveRegion dbr:サイボーグ009 dbo: ComicsCreator dbr:宮城県 dbr:石ノ森章太郎 rdfs:label rdf:type rdfs:label dbo:notableWork
dbo:award dbo:birthPlace rdf:type サイボーグ009 宮城県 foaf:Person 石ノ森章太郎 rdf:type rdfs:label dbr:村井嘉浩 dbo:leaderName dbr:手塚治虫 文化賞 dbo:Cartoon rdf:type ΫΤϦख௩࣏จԽΛडͨ͠ອըՈ 13&'*9ECSIUUQKBECQFEJBPSHSFTPVSDF 13&'*9ECPIUUQECQFEJBPSHPOUPMPHZ 4&-&$5 DSFBUPS 8)&3&\ DSFBUPSSEGUZQFECP$PNJDT$SFBUPS ECPBXBSEECSख௩࣏จԽ ^ -
dbo:AdministraDveRegion dbr:サイボーグ009 dbo: ComicsCreator dbr:宮城県 dbr:石ノ森章太郎 rdfs:label rdf:type rdfs:label dbo:notableWork
dbo:award dbo:birthPlace rdf:type サイボーグ009 宮城県 foaf:Person rdf:type rdfs:label dbr:村井嘉浩 dbo:leaderName dbp:手塚治虫 文化賞 dbo:Cartoon rdf:type ΫΤϦख௩࣏จԽΛडͨ͠ອըՈͷදతͳອը 13&'*9ECSIUUQKBECQFEJBPSHSFTPVSDF 13&'*9ECPIUUQECQFEJBPSHPOUPMPHZ 4&-&$5 DSFBUPS/BNF DPNJD/BNF 8)&3&\ DSFBUPSBECP$PNJDT$SFBUPSECPBXBSEECSख௩࣏จԽ ECPOPUBCMF8PSL DPNJDSEGTMBCFM DSFBUPS/BNF DPNJDBECP$BSUPPOSEGTMBCFM DPNJD/BNF ^ 石ノ森章太郎 -
41"32- w σʔλऔಘ w 4&-&$5 w "4, w %&4$3*#& w
$0/4536$5 w ΄΅Ͳ͜Ͱ͑Δ -
4&-&$5 ྫ ҙͷͭΛ݅औಘ 4&-&$5 T Q P 8)&3&\ T
Q P ^ -*.*5 -
"4, • "4,άϥϑύλʔϯʹϚον͢Δͷ͕͋Δ͔ • ݁ՌZFT͔OP ྫ ੴϊষଠͷग़ؚ͕·Ε͍ͯΔ͔Ͳ͏͔ 13&'*9ECSIUUQKBECQFEJBPSHSFTPVSDF 13&'*9ECPIUUQECQFEJBPSHPOUPMPHZ
"4, 8)&3&\ ECSੴϊষଠECPCJSUI1MBDF CJSUI1MBDF ^ -
%&4$3*#& • %&4$3*#&Ϧιʔεʹؔ͢ΔάϥϑΛऔಘ • άϥϑͱͯ͠Կ͕ฦͬͯ͘Δ͔࣮ґଘ • ରϦιʔεΛTVCKFDU͔PCKFDUʹؚΉͭͷू߹ • ݁Ռܗࣜ5VSUMF
3%'9.- +40/-% ྫ Պֶٕज़ৼڵػߏʹؔ͢ΔάϥϑΛऔಘ DESCRIBE <h^p://ja.dbpedia.org/resource/Պֶٕज़ৼڵػߏ> -
$0/4536$5 • $0/4536$5৽͍͠άϥϑΛ࡞ͯ͠औಘ • ݁Ռܗࣜ5VSUMF 3%'9.- +40/-% GPBGOBNFϓϩύςΟͷͭΛSEGTMBCFMʹͯ͠औಘ 13&'*9SEGTIUUQXXXXPSHSEGTDIFNB
13&'*9GPBGIUUQYNMOTDPNGPBG $0/4536$5\ TSEGTMBCFM P^ 8)&3&\ TGPBGOBNF P^ -
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX orth: <http://purl.jp/bio/11/orth#> PREFIX protid: <http://identifiers.org/ncbiprotein/>
SELECT DISTINCT ?protein_id FROM <http://mbgd.genome.ad.jp/rdf/resource/default> FROM <http://mbgd.genome.ad.jp/rdf/resource/gene> WHERE { ?group a orth:OrthologGroup ; orth:member+/orth:gene?/orth:protein?/rdfs:seeAlso protid:NP_563687.1 ; orth:member+/orth:gene?/orth:protein?/rdfs:seeAlso ?protein_id . FILTER regex(?protein_id, "identifiers.org/ncbiprotein") } -
41"32- w σʔλཧ w ࡞ɾߋ৽ɾআ༻۟*/4&35 61%"5& %&-&5& -0"% %301
w αʔϏεهड़ w (SBQI4UPSF)5511SPUPDPM -
ϓϩύςΟύε w ௨ৗͷͭύλʔϯ T Q P w Pͷলུ Qͷ܁Γฦ͠ɼ Qͷٯ͖
Λهड़Մೳ PREFIX dbr: <h^p://ja.dbpedia.org/resource/> PREFIX dbo: <h^p://dbpedia.org/ontology/> PREFIX rdfs: <h^p://www.w3.org/2000/01/rdf-schema#> SELECT ?creator ?comicName WHERE { ?creator dbo:notableWork/rdfs:label ?comicName . } -
ϓϩύςΟύεͷྫ w TGPBGLOPXTGPBGLOPXT P w TGPBGLOPXT P w T?GPBGLOPXT
P w TGPBGOBNFcSEGTMBCFM P -
ू w $06/5ݸ w 46.߹ܭ w "7(ฏۉ w .*/࠷খ w
."9࠷େ w (3061#:ू͢Δมͷࢦఆ -
$06/5 # ܆ϦιʔεͷτϦϓϧ SELECT (COUNT(?o) AS ?count) WHERE {
<h^p://ja.dbpedia.org/resource/܆> ?p ?o . } -
(3061#: ྫ) ΫϥεຖͷΠϯελϯεͷ্Ґ100݅Λ߱ॱ SELECT ?class (COUNT(?instance) AS ?noOfInstances) WHERE
{ ?instance a ?class . } GROUP BY ?class ORDER BY DESC(?noOfInstances) LIMIT 100 -
αϒΫΤϦ ྫ) ΫϥεຖͷΠϯελϯεͷͷฏۉ SELECT (AVG(?noOfInstances) AS ?avg) WHERE {
{ SELECT ?class (COUNT(?instance) AS ?noOfInstances) WHERE { ?instance a ?class . } GROUP BY ?class } } -
'FEFSBUFEΫΤϦ w 4&37*$&۟αϒΫΤϦͷԆ w ΫΤϦΛ͛ͨΤϯυϙΠϯτҎ֎Λࢦఆͯ͠ ΫΤϦΛ͛ΒΕΔ w ϲॴҎ্ͷ41"32-ΤϯυϙΠϯτʹରͯ͠ΫΤϦ Λൃߦͯࣗ͠ಈతʹ݁ՌΛ݁߹ w
·ͩ͑ΔΤϯυϙΠϯτ͕ݶΒΕΔ͕41"32-ͷύ ϫϑϧ͞ͷͷҰͭ -
41"32-ͷՄࢹԽ ࣗલ w 41"32-݁Ռܾ·ͬͨߏͷ+40/9.-ͳͷͰɺ )551Ͱ͍߹Θͤͯ͑ྑ͍ w ଟ͘ͷݴޠͰ41"32-ॲཧ༻ͷϥΠϒϥϦ͋Δ w දࣔ෦ࣗલͰ࡞Δඞཁ͕͋Δ
function query(endpoint, sparql, callback) { var url = endpoint + "?query=" + encodeURIComponent(sparql); $.getJSON(url, function(json){ callback(json) } } -
ETQBSRMKT w +BWB4DSJQUϥΠϒϥϦ w 41"32-݁ՌΛEKTͰՄࢹԽ w WFSTJPOͷҰ෦ʹରԠ w IUUQCJPIBDLBUIPOPSHETQBSRM w
IUUQTHJUIVCDPNLUZNETQBSRM -
ରԠܗࣜ w $IBSU w #BSDIBSU w 4DBUUFSQMPU w 1JFDIBSU w
(SBQI w 'PSDFHSBQ I w 4BOLFZ w 5SFF w %FOESPHSB N w 5SFFNBQ w 5SFFNBQ;P PN w 3PVOE5SFF w $JSDMFQBDL w 4VOCVSTU w .BQ w $PPSENBQ w /BNFE NBQ w 5BCMF w )5.- 5BCMF w )5.- )BTI -
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX yago: <http://dbpedia.org/class/yago/> PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT ?label ?size WHERE { ?s a yago:WikicatPrefecturesOfJapan ; rdfs:label ?label; dbo:areaTotal ?area_total . FILTER (lang(?label) = 'ja') BIND ((?area_total / 1000000) AS ?size) FILTER (str(?s) != 'http://dbpedia.org/resource/Onjuku') } ORDER BY DESC(?size) -
OBNFENBQΫΤϦ function exec() { var endpoint = d3.select("#endpoint").property("value") var
sparql = d3.select("#sparql").property("value") d3sparql.query(endpoint, sparql, render) } function render(json) { var config = { "label_x": "ಓݝ", "label_y": "໘ੵ", "var_x": "label", "var_y": "size", "width": 800, "height": 400, "margin": 100, "selector": "#result" } d3sparql.barchart(json, config) } ରͷม໊ΛDPOpHͰࢦఆ #BSDIBSUͷݺͼग़͠ -
OBNFENBQΫΤϦ function render(json) { var config = { "label":
"label", "size": "size", "width": 600, "height": 600, "margin": 10, "hole": 200, "selector": "#result" } d3sparql.piechart(json, config) } -
w ਓޱີΛܭࢉͯ͠ਤͰՄࢹԽ w 5PQPKTPO w λεΫ w OBNFENBQIUNMΛ࣮ߦ w %#QFEJBͰ41"32-ΫΤϦ࣮ߦ
w OBNFENBQIUNMͷιʔεಡΈ /BNFENBQ -
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX yago: <http://dbpedia.org/class/yago/> PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT DISTINCT ?s ?label ?population ?area ?density WHERE { ?s a yago:WikicatPrefecturesOfJapan ; rdfs:label ?label ; dbo:populationTotal ?population ; dbo:areaTotal ?area . BIND (xsd:float(?population)/xsd:float(?area/1000000) AS ?density) FILTER (lang(?label) = 'ja' ) FILTER (str(?s) != 'http://dbpedia.org/resource/Onjuku') } ORDER BY DESC(?density) ಛఆͷม໊ΛOBNFENBQͷDPOpHͰࢦఆ -
OBNFENBQΫΤϦ function exec() { var endpoint = d3.select("#endpoint").property("value") var
sparql = d3.select("#sparql").property("value") d3sparql.query(endpoint, sparql, render) } function render(json) { var config = { "label": "label", "value": "density", "topojson": "https://gist.githubusercontent.com/fumi/ 521c759efe0648b3c1296c5a869b3406/raw/ 39e94dae1c46ed71d88529038f3ff45e681b257c/japan.topojson", "mapname": "japan", "color_max": "red", "color_min": "white", "center_lat": 34, "center_lng": 137, "scale": 1500, "selector": "#result" } d3sparql.namedmap(json, config) } -
OBNFENBQΫΤϦ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbpedia-owl:
<http://dbpedia.org/ontology/> PREFIX prop-ja: <http://ja.dbpedia.org/property/> SELECT ?root_name ?parent_name ?child_name WHERE { VALUES ?root_name { "౦ژӺ"@ja } ?root rdfs:label ?root_name . ?root prop-ja:࣍ͷӺ{1,5} ?child . ?parent prop-ja:࣍ͷӺ ?child . MINUS { ?child prop-ja:࣍ͷӺ ?parent . } ?parent rdfs:label ?parent_name . ?child rdfs:label ?child_name . FILTER (LANG(?parent_name) = 'ja') FILTER (LANG(?child_name) = 'ja') } GROUP BY ?root_name ?parent_name ?child_name ҙ͜ͷ෦ ඪ४༷Ͱͳ͍