Table 11.
Execution time (in seconds) for relative temporal query “Find patients had any [Query Event A] before first Covid-19 diagnosis.”
| ID | Baseline | ELII | Saved | X-faster |
|---|---|---|---|---|
| D1 | 2.652 | 0.1338 | 2.5182 | 19.8 |
| D2 | 2.6504 | 0.1325 | 2.5179 | 20.0 |
| D3 | 2.6716 | 0.1382 | 2.5334 | 19.3 |
| D4 | 2.9773 | 0.2031 | 2.7742 | 14.7 |
| D5 | 4.4099 | 0.7081 | 3.7018 | 6.2 |
| D6 | 11.9138 | 1.3572 | 10.5566 | 8.8 |
| D7 | 7.8546 | 1.2973 | 6.5573 | 6.1 |
| D8 | 17.8092 | 2.5436 | 15.2656 | 7.0 |
| D9 | 39.6454 | 3.2416 | 36.4038 | 12.2 |
| L1 | 2.4523 | 0.1175 | 2.3348 | 20.9 |
| L2 | 2.4235 | 0.0865 | 2.337 | 28.0 |
| L3 | 2.4848 | 0.0888 | 2.396 | 28.0 |
| L4 | 2.5785 | 0.1044 | 2.4741 | 24.7 |
| L5 | 4.5704 | 0.7681 | 3.8023 | 6.0 |
| L6 | 7.144 | 1.3152 | 5.8288 | 5.4 |
| L7 | 10.5915 | 1.6565 | 8.935 | 6.4 |
| L8 | 41.8886 | 2.4278 | 39.4608 | 17.3 |
| L9 | 38.694 | 3.2004 | 35.4936 | 12.1 |
| L10 | 493.3144 | 6.5753 | 486.7391 | 75.0 |
| Avg | 36.7751 | 1.3735 | 35.4016 | 26.7747 |
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.