Stream: implementers
Topic: relational database FHIR model
Matthew Tiller (Jan 31 2019 at 15:37):
I have looked for, but cannot find, a relational database representation of the FHIR model. Barring its impracticality for real world FHIR servers, it seems to me like something that might exist. Does anyone know of a published relational database schema that models FHIR directly?
Michel Rutten (Jan 31 2019 at 15:43):
https://github.com/FHIR/sql-on-fhir/blob/master/sql-on-fhir.md
Lloyd McKenzie (Jan 31 2019 at 15:43):
There are a variety of approaches that people have taken with different tradeoffs. You might look at #storage for FHIR
Matthew Tiller (Jan 31 2019 at 16:01):
Thank you Michel and Lloyd.
nicola (RIO/SS) (Feb 01 2019 at 16:54):
2 years ago for first version of fhirbase we generated relational database - it was about 2K tables and joins were terribly slow - so we switched to jsonb approach (see https://www.health-samurai.io/fhirbase)
Matthew Tiller (Feb 07 2019 at 15:18):
Very interesting to know that it was tried, Nicola. Thanks for the insight
Last updated: Apr 12 2022 at 19:14 UTC
