We're wondering if there is any benefit to using a denormalized, Big Table style schema for GDM. Perhaps this would speed up some common queries?
We'd need to avoid duplicating clinical_codes records because that would throw off counts of procedures and diagnoses and such. However, it should be possible to join the following tables together like so:
We're wondering if there is any benefit to using a denormalized, Big Table style schema for GDM. Perhaps this would speed up some common queries?
We'd need to avoid duplicating
clinical_codes
records because that would throw off counts of procedures and diagnoses and such. However, it should be possible to join the following tables together like so:collections
<->contexts
<->clinical_codes
<-> {drug_exposure_details
,measurement_details
,admission_details
}