Skip to main content

Table 9 Competency questions from ontology network requirements

From: An ontology network for Diabetes Mellitus in Mexico

Competency Question SPARQL Query Pseudo-code
I) What is the weight of a patient? PREFIX dato: <http://www.modelo.org/datos# > List all triplets (?patient, ?weight, ?date)
  PREFIX red: <http://www.diabetes-mexico.org/red# > Where for the ?patient has a clinical record
  SELECT ?patient ?weight ?date ?x ?record (via dato:tieneExpedienteClinico),
  WHERE { ?patient red:tieneExpedienteClinico ?record. ?record has a medical note ?note (via
  ?record dato:tieneNotaMedica ?note. dato:tieneNotaMedica), ?note contains the
  ?note dato:tienePeso ?weight. wieght ?weight (via dato:tienePeso) and a
  ?note dato:tieneFecha ?date} registration date ?date (via dato:tieneFecha)
II) What is the ICD-10 code for T2DM? PREFIX enf: <http://www.padecimientos-mexico.org/enfermedad# > List the ICD-10 code ?icd10 of the T2DM individual linked via an annotation property
  PREFIX red: <http://www.diabetes-mexico.org/red# > (red:ICD10).
  SELECT ?icd10  
  WHERE { enf:DiabetesMellitusTipo2 red:ICD10 ?icd10}  
III) What are the presentations of Insulin Lispro? PREFIX medi: <http://www.medicamentos-mexico.org/medicamento# > List the different pharmaceutical forms ?form of the drugs ?x (via
  SELECT distinct ?form medi:tieneFormaFarmaceutica) that
  WHERE { ?x medi:tienePrincipioActivo medi:Insulina_Lispro. have the Insulin Lispro drug individual
  ?y medi:tienePrincipioActivoPorPorcion ?x. (medi:Insulina_Lispro) as API (via
  ?y medi:tieneFormaFarmaceutica ?form} medi:tienePrincipioActivo)
IV) Where the patient X is living? PREFIX red: <http://www.diabetes-mexico.org/red# > List all pairs (?patient, ?place) Where for the
  SELECT ?patient ?place ?patient the ?place is linked to the ?patient
  WHERE { ?patient red:resideEn ?place} (via “red:resideEn”)