Where can I find a database model backing a FHIR server?

[MSK Data Products]

Dear all SMART folks,

I'm looking for a database model backing a FHIR server to get an idea of what it looks like. At the end of the day, FHIR is an API spec, but I presume some implementations will have their own database model that the API is built atop of.

I think SMART's implementation is api-server. I see that there's a postgres-tables.sql file in the git repo. I don't quite think it's what I want, but is close. (I'm hoping I find something similar to the OMOP CDM.)

Thanks!

Sean McIntyre

[Nikolai Schwertner]

The SMART API server does not have a relational model of the FHIR resource specs. It stores the resource objects as is (FHIR JSON format) in a text field inside the DB. The tables in the database deal with indexing search terms, permissions, and versions, but that's about it. It's probably worthwhile posting your question on the FHIR developers chat.

-Nikolai

--
You received this message because you are subscribed to the Google Groups "SMART on FHIR" group.
To unsubscribe from this group and stop receiving emails from it, send an email to smart-on-fhi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Kevin Mayfield]

Have a look at HAPI JPA FHIR Server

http://jamesagnew.github.io/hapi-fhir/doc_jpa.html

[MSK Data Products]

Okay thanks for the quick replies.

I think my next step in understanding the api-server is to deep-dive into how the data is stored and interacted with. I learned today about the validation coupled with the FHIR schema. It seems like that the client libraries do a lot of the validation, so maybe the servers can forego a lot of the structure they traditionally provide?

Is this the FHIR developers chat you're referring to? http://community.fhir.org

Thanks!

Sean McIntyre

On Tue, Mar 22, 2016 at 3:28 AM, Kevin Mayfield <mayfiel...@gmail.com> wrote:

Have a look at HAPI JPA FHIR Server

http://jamesagnew.github.io/hapi-fhir/doc_jpa.html

[Kevin Mayfield]

I've been using this one https://groups.google.com/forum/#!forum/hapi-fhir

I believe you can customize how you store the data. I've stuck with the default for now with MySQL but it's something I want to investigate.