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 }
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_codesrecords 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}