Skip to main content

Table 3 SPARQL query generated by ODS for a dashboard

From: Analysis and visualization of disease courses in a semantically-enabled cancer registry

PREFIX ods: 〈http://www.imib.es/ontologies/disease-times 〉
SELECT count(DISTINCT ?s), ?t WHERE
{{?s rdf:type ?t FILTER (?t IN (ods:DrugTherapy, ods:Anti-hormoneTherapy,
ods:Anti-hormonal_anti-androgens, ods:Anti-hormonal_anti-estrogens,
ods:Anti-hormone_therapy_aromatase, ods:Other_Anti-hormoneTherapy,
ods:Chemotherapy, ods:Immunotherapy, ods:OtherdrugTherapy,
ods:Bisphosphonates, ods:Other_med_therapy,
ods:NuclearMedicineTherapy, ods:OpenRadionuclides,
ods:Other_nuclear_medicine_therapy, ods:RadioiodineTherapy,
ods:OtherTherapy, ods:Hyperthermia, ods:Locoregional_hyperthermia,
ods:Part-body_hyperthermia, ods:LightTherapy, ods:OtherLightTherapy,
ods:Selective_ultraviolet_phototherapy, ods:Wait_and_see,
ods:Radiotherapy, ods:Brachytherapy, ods:Interstitial_brachytherapy,
ods:Other_brachytherapy, ods:OtherHigh-voltageRadiotherapy,
ods:High-voltage_radiotherapy_n.n.bez.,
ods:Other_high-voltage_radiotherapy, ods:Whole-body_irradiation,
ods:Teletherapy, ods:OtherTeletherapy, ods:Teletherapy_n.n.bez.,
ods:Teletherapy_with_linear_accelerator, ods:StemCellTransplantation,
ods:AllogeneicSCT, ods:AutologousSCT, ods:SurgicalTreatment,
ods:Therapy))}.
{{?s ods:hasDiagnosis ?a0.
{?a0 rdf:type ?ta0 FILTER (?ta0 IN (ods:Diagnosis))} }.
{?a0 ods:hasPathologicalStructure ?a01.
{?a01 rdf:type ?ta01 FILTER (?ta01 IN (ods:Colorectal_cancer))} }.
{?s ods:hasPatient ?a1. {?a1 rdf:type ?ta1 FILTER (?ta1 IN (ods:Patient))} }.
{?a1 ods:age ?a12. FILTER (?a12 〉= 60)} }} group by ?t}