Skip to main content
. 2011 Mar 30;2(1):116–127. doi: 10.4338/ACI-2010-09-CR-0051

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