Table 9.
Execution time (in seconds) for classical query “Find patients with [query event].”
| ID | Baseline | ELII | Saved | X-faster |
|---|---|---|---|---|
| D1 | 0.001 | 0.0004 | 0.0006 | 2.5 |
| D2 | 0.0016 | 0.0003 | 0.0013 | 5.3 |
| D3 | 0.0078 | 0.0005 | 0.0073 | 15.6 |
| D4 | 0.2574 | 0.0009 | 0.2565 | 286.0 |
| D5 | 1.3608 | 0.0056 | 1.3552 | 243.0 |
| D6 | 8.0205 | 0.015 | 8.0055 | 534.7 |
| D7 | 4.3322 | 0.0611 | 4.2711 | 70.9 |
| D8 | 14.5332 | 0.0499 | 14.4833 | 291.2 |
| D9 | 36.1807 | 0.0607 | 36.12 | 596.1 |
| L1 | 0.0007 | 0.0003 | 0.0004 | 2.3 |
| L2 | 0.0013 | 0.0004 | 0.0009 | 3.3 |
| L3 | 0.0077 | 0.0005 | 0.0072 | 15.4 |
| L4 | 0.0883 | 0.0009 | 0.0874 | 98.1 |
| L5 | 1.8039 | 0.0057 | 1.7982 | 316.5 |
| L6 | 3.2602 | 0.0135 | 3.2467 | 241.5 |
| L7 | 5.4892 | 0.0215 | 5.4677 | 255.3 |
| L8 | 17.2616 | 0.0545 | 17.2071 | 316.7 |
| L9 | 16.8289 | 0.0481 | 16.7808 | 349.9 |
| L10 | 345.8775 | 0.099 | 345.7785 | 3493.7 |
| Avg | 23.9639 | 0.0231 | 23.9408 | 1037.6356 |
Notes: Baseline: baseline model using row-oriented data store, ELII: our method using document-oriented data store with ELII, Saved: ELII Time - Baseline Time, X-faster: Baseline Time ELII Time.