Stream: storage for FHIR
Topic: graph databases
Anthony Master (Jul 20 2021 at 21:35):
new here and looking for others who might be storing data in a native graph database. (Dgraph, Neo4j, Neptune, etc.) It seems like a good use for a graph database from my perspective because data is highly connective. Thoughts or Experiences?
nicola (RIO/SS) (Aug 02 2021 at 11:23):
There were few experiments - @Alexander Zautke ? I personally do not think this is "a good match", because other scenarios like searches and aggregates does not work well in graph databases.
Alexander Zautke (Aug 02 2021 at 13:47):
I've never got far with the experiments, I personally also have never heard from anyone using it in production. I agree with @nicola (RIO/SS) that for most purposes a document or relational database is already a good match. All FHIR search related queries can be expressed in a sufficiently optimised way.
Georg Fette (Aug 04 2021 at 07:03):
Are there any performance evaluation concerning query times for FHIR engines ? FHIR search is very limited concerning the modeling capabilities of queries representing complex graph like queries. CQL would be a better candidate for that. Although there exist almost no CQL engines. I would be interested to see query time measurements of the Blaze server which can handle CQL.
Sajad Asadi (Dec 12 2021 at 09:28):
I'm analyzing this Asymmetrik source to decide if It's a good idea to base my project on:
https://github.com/Asymmetrik/node-fhir-server-mongo
The thing is they used mongo.
Which is faster than SQL options but it has it's own limitations when it comes to querying. Things like Join query and so on ...
So I may want to change its data source Postgres.
The question is:
Should I design a SQL schema based on FHIR and then use it in the project?
Or the Asymmetrik library has something to make it easier?
Sajad Asadi (Dec 12 2021 at 09:29):
Are there any FHIR db design examples out there?
Sajad Asadi (Dec 12 2021 at 09:33):
Or any guide about how to create a FHIR db especially something that works with Asymmetrik library?
Last updated: Apr 12 2022 at 19:14 UTC
