Table 3.
Query performance and capabilities for scenario A
| Query Stage | Native SQL | i2b2 | ||
|---|---|---|---|---|
| Patients retrieved |
Runtime (sec) |
Patients retrieved |
Runtime (sec) |
|
| Female, Breast Cancer (ICD C50) in 2009 | 1081 | 9 | 1081 | 47 |
| + Radiation therapy (OPS 8-52) | 384 | 5 | 384 | 57 |
| + Surgical Breast excision/resection (OPS 5-87) | 194 | 8 | 194 | 39 |
| + Chemotherapy (OPS 8-54) | 55 | 5 | 55 | 49 |
| + age group 30-49 at diagnosis | 18 | 4 | 21 | 53 |
| + Chemotherapy pre & radiation post surgery | 10 | 4 | - | - |