Search Mailing List Archives


Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[bioontology-support] Federated Sparql Question

tomd tom.dwyer at patientfirst.com
Mon Feb 17 15:03:45 PST 2014


Hi,
I am an experienced developer but new to SPARQL, like what I see so far.  I
am trying to create a mapping lookup table from ICD-10 to SNOMEDCT, along
with descriptions.  I can get the mappings running fine but to get the
descriptions I need to do a federated query.  The performance is not very
good.  Can you offer any suggestions.  I am running the following query over
a local Jena ARQ client:

PREFIX map: <http://protege.stanford.edu/ontologies/mappings/mappings.rdfs#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT DISTINCT ?icdNum ?snoNum ?icdLabel ?snoLabel 
FROM <http://bioportal.bioontology.org/ontologies/SNOMEDCT>
FROM <http://bioportal.bioontology.org/ontologies/ICD10>
FROM <http://bioportal.bioontology.org/ontologies/globals>
FROM <http://purl.bioontology.org/mapping/loom>
FROM <http://purl.bioontology.org/mapping/umls_cui> 
WHERE {
    SERVICE
<http://sparql.bioontology.org/mappings/sparql/?apikey=24e242d6-54e0-11e0-9d7b-005056aa3316>
{
      ?m map:source_ontology
<http://bioportal.bioontology.org/ontologies/1553> .
      ?m map:target_ontology
<http://bioportal.bioontology.org/ontologies/1353> .
      ?m map:source ?source .
      ?m map:target ?target .
    }
    SERVICE
<http://sparql.bioontology.org/ontologies/sparql/?apikey=24e242d6-54e0-11e0-9d7b-005056aa3316>
{
      ?source skos:prefLabel ?icdLabel  .
      ?source skos:notation ?icdNum.
      ?target skos:prefLabel ?snoLabel  .
      ?target skos:notation ?snoNum.
    }
}
ORDER BY asc (?icdNum)
LIMIT 10000

Thanks in advance,
Tom





--
View this message in context: http://ncbo-support.2288202.n4.nabble.com/Federated-Sparql-Question-tp4652567.html
Sent from the NCBO Support mailing list archive at Nabble.com.


More information about the bioontology-support mailing list