Skip to main content
. 2022 Jun 3;124:109093. doi: 10.1016/j.asoc.2022.109093

Table 2.

Information stored in QDS cubes.

Dataset Objects Memory Time Pivots Schema
Records 42.9M 3.1GB 8 min 17 s 72.8M health professional (2), sex (2), condition count (3), symptom count (5), test result (4),
test status (5), test type (7), final classification (7), evolution (8), age (19), IBGE state (27),
IBGE municipality (5603), start date of symptoms (temporal), notification date (temporal)
Symptoms 94.3M 6.8GB 17 min 28 s 159.8M health professional (2), sex (2), symptom (11), test result (4), test status (5), test type (7),
final classification (7), evolution (8), age (19), IBGE state (27), IBGE municipality (5603),
start date of symptoms (temporal), notification date (temporal)
Conditions 5M 432MB 1 min 16 s 11M health professional (2), sex (2), condition (10), test result (4), test status (5), test type (7),
final classification (7), evolution (8), age (19), IBGE state (27), IBGE municipality (5603),
start date of symptoms (temporal),
notification date (temporal)