Table 2.
Numbers measured while importing radiology exports into the data warehouse.
| Details | Hospital A | Hospital B | Hospital C | Hospital D | |
| RIS data import | |||||
|
|
Imported files, n | 1 | 4 | 8 | 3 |
|
|
Import time (hours:minutes:seconds) | 0:02:22 | 0:18:11 | 0:21:06 | 0:07:07 |
|
|
Imported attributes, n | 45 | 26 | 11 | 18 |
| Additional calculations | |||||
|
|
Calculations, n | 10 | 14 | 9 | 8 |
|
|
Time for each calculated attribute (seconds), mean (SD) | 4.7 (2.9) | 23.0 (30.2) | 9.3 (2.3) | 11.7 (8.0) |
|
|
Total time (hours:minutes:seconds) | 0:00:47 | 0:21:31 | 0:11:11 | 0:04:40 |
| Index and database | |||||
|
|
Solr index creation time (hours:minutes:seconds) | 0:04:02 | 0:31:28 | 0:16:49 | 0:12:06 |
|
|
Time of the total processa (hours:minutes:seconds) | 0:07:12 | 1:11:15 | 0:49:13 | 0:23:57 |
|
|
Database size (GB) | 1.3 | 15.8 | 11.4 | 3.7 |
|
|
Solr index size (GB) | 1.4 | 15.1 | 2.2 | 3.8 |
| Incremental updates | |||||
|
|
Examinations per day, mean (SD) | 144 (61.8) | 763 (288.5) | 469 (200.3) | 271 (222.3) |
|
|
Time for adding these examinationsb (hours:minutes:seconds) | 0:00:18 | 0:01:29 | 0:01:00 | 0:00:28 |
aTotal time for importing all attributes, calculating additional ones, and creating the Solr index.
bTime for incrementally adding just this average number of examinations per day.