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”) |