第2回尝颈苍办别诲顿补迟补勉强会蔼测补测补尘补尘辞
?Download as KEY, PDF?
1 like?4,764 views
第2回LinkedData勉強会で山本が発表した際に利用したプレゼン資料です。 http://allie.dbcls.jp/ および、 http://data.allie.dbcls.jp/sparql/ よろしくお願いします。
![PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
PREFIX allie:<http://purl.org/allie/ontology/201102#>
select distinct ?F ?lfr ?L ?lf where {
[] a allie:PairCluster;
allie:contains [
allie:hasMemberOf [
allie:hasLongFormOf [
rdfs:label ?lf;
allie:frequency ?lfr ];
]];
allie:frequency ?F;
allie:hasShortFormRepresentationOf [ rdfs:label "SPF"@EN ];
allie:hasLongFormRepresentationOf [ rdfs:label ?L ].
FILTER ( lang(?L) = "en" && lang(?lf) = "en" )
}
ORDER BY DESC(xsd:integer(?F)) DESC(xsd:integer(?lfr))](https://image.slidesharecdn.com/linkeddatayayamamo-110725003245-phpapp02/85/2-LinkedData-yayamamo-22-320.jpg)
![PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
PREFIX allie: <http://purl.org/allie/ontology/201102#>
select ?SF ?LF ?freq where {
[] a allie:PairCluster;
allie:frequency ?freq;
allie:contains [
allie:hasMemberOf [
allie:hasShortFormOf [
rdfs:label ?SF ];
allie:hasLongFormOf [
rdfs:label ?LF ];
]].
FILTER (xsd:integer(?freq) > 10
&& !regex(?SF,"^s","i")
&& regex(?LF, "^specific", "i"))
}
ORDER BY DESC (xsd:integer(?freq))](https://image.slidesharecdn.com/linkeddatayayamamo-110725003245-phpapp02/85/2-LinkedData-yayamamo-23-320.jpg)
第2回尝颈苍办别诲顿补迟补勉强会蔼测补测补尘补尘辞
- 1. DB→RDF →SPARQL (@yayamamo) 2011.7.23
- 3. Allie ( ) Allie
- 4. danmachold
- 5. ? (PubMed 2000 / ) ? ? PC: personal computer, primary care, prostate cancer, ... Alcoholic chronic pancreatitis: ACP, alcoholic CP, ... Year
- 6. ? (PubMed 2000 / ) ? ? PC: personal computer, primary care, prostate cancer, ... Alcoholic chronic pancreatitis: ACP, alcoholic CP, ... Year
- 7. complementary DNA - cDNA
- 8. 2000 polymerase chain reaction PCR Fourier transform infrared FTIR scanning electron microscopy SEM MEDLINE 1000
- 9. Allie ? mammalian target of rapamycin / ? Neoplasms / , ? mTOR - (1995) Mechanism of action of rapamycin: new insights into the regulation of G1-phase progression in eukaryotic cells. ? ( ) mTOR - PI3K, AMPK, S6K1, ...
- 11. ? ftp ? ? API ? SOAP / REST
- 13. Allie ?
- 15. SPARQL
- 16. — PairCluster ShortForm LongForm SPF specific pathogen-free appearsIn PubMedIDList contains CoocurringShort cooccursWith PairList FormList Pair ShortForm LongForm SPF specific pathogen-free inResearch AreaOf ResearchArea Pair ShortForm LongForm spf specified pathogen free frequency
- 19. Domain Object property Range Pair appearsIn PubMedList PairCluster contains PairList Pair cooccursWith CooccurringShortFormList Pair hasLongFormOf LongForm PairCluster hasLongFormRepresentationOf LongForm hasMemberOf Pair hasShortFormOf ShortForm PairCluster hasShortFormRepresentationOf ShortForm Pair inResearchAreaOf ResearchArea
- 20. 9000 11G ( ) 443M (gziped) 134 ( ) — 1400 ( )
- 21. Virtuoso vs. OWLIM-SE OpenLink Virtuoso version 06.01.3127, Standard Edition OWLIM-SE 4.0 / OpenRDF Workbench 2.4.0 Virtuoso OWLIM-SE 50 3 SPARQL SPARQL ○ ?
- 22. PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX xsd:<http://www.w3.org/2001/XMLSchema#> PREFIX allie:<http://purl.org/allie/ontology/201102#> select distinct ?F ?lfr ?L ?lf where { [] a allie:PairCluster; allie:contains [ allie:hasMemberOf [ allie:hasLongFormOf [ rdfs:label ?lf; allie:frequency ?lfr ]; ]]; allie:frequency ?F; allie:hasShortFormRepresentationOf [ rdfs:label "SPF"@EN ]; allie:hasLongFormRepresentationOf [ rdfs:label ?L ]. FILTER ( lang(?L) = "en" && lang(?lf) = "en" ) } ORDER BY DESC(xsd:integer(?F)) DESC(xsd:integer(?lfr))
- 23. PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX xsd:<http://www.w3.org/2001/XMLSchema#> PREFIX allie: <http://purl.org/allie/ontology/201102#> select ?SF ?LF ?freq where { [] a allie:PairCluster; allie:frequency ?freq; allie:contains [ allie:hasMemberOf [ allie:hasShortFormOf [ rdfs:label ?SF ]; allie:hasLongFormOf [ rdfs:label ?LF ]; ]]. FILTER (xsd:integer(?freq) > 10 && !regex(?SF,"^s","i") && regex(?LF, "^specific", "i")) } ORDER BY DESC (xsd:integer(?freq))
- 24. SPARQL? ? ? Virtuoso ?
- 25. ? DBCLS ? ?