FHIR Chat · FHIR resources storage

Hi Everyone,
We want to store various FHIR resources ()like Patient, encounter etc) in either NoSQL DB (such as HBase/Cassandra etc) or regular SQL DB like MySQL.
Is there any standard way of creating schema for storing these FHIR resources? Are such SQL table scripts available somewhere?
Please advice.

Regards,
Aditya

James Agnew (Jun 24 2016 at 17:24):

FWIW you could use HAPI's JPA module to store to MySQL. It does not support any NoSQL backends though.

Abbie Watson (Jun 24 2016 at 17:26):

If Mongo is on your list of NoSQL solutions you're willing to consider, you could check out Clinical Meteor. We're using Mongo and minimongo to store FHIR compliant resources on the browser, server, database, and mobile. We have a package called SimpleSchema which is isomorphic and can be used at all levels of the stack, and have created SimpleSchemas for 24 of the FHIR resources (and counting). Meteor/Node.js only.

http://clinical.meteorapp.com/
https://github.com/clinical-meteor/hl7-argonaut-fhir
https://github.com/clinical-meteor/?utf8=%E2%9C%93&query=hl7-resource

Grahame Grieve (Jun 25 2016 at 09:12):

There is no standard way. Just some ways people have done it, as here

Aditya Joshi (Jun 25 2016 at 12:55):

any more feasible and better approach for doing this? Should one has to fetch out all search parameters from each resource and store in db or somewhere so that when someone query, we can create FHIR resource based on that. Generally, how people have done it, I am going through two approaches as suggested by two of the members previously.