marklogic-samplestack | sample implementation of the MarkLogic Reference | Application Framework library

Background

I'm using NoSql database supporting graphs for the first time. It is a huge medical application handling thousands of patients. It is a greenfield project and we as a team are struggling with our persistence layer. We don't know how relationships should be represented and if we should use Triples to handle queries involving huge amount of data. We are using Java API.

Data structure

Imagine that there are 3 types of JSON documents in our Marklogic database: Patient, Event, File Evidence.

• There are thousands of patients in the application
• One patient can have multiple events associated with this patient (admitted, discharged, transferred, prescribed medications, added note, changed internal status etc.)
• each event can have multiple files attached to it as an evidence

Assume there are hundreds of thousands of patients, events and files.

Question

Is it possible to query patients with events and files at once? Is using semantics (possible triples: 'patient has event', 'event has file') recommended in our case?

Our approach

We try to use triples to provide relationships between our documents, add them to one graph, use combination query to fetch IRI first and then in the second call fetch documents by IRI. We tried self-paced trainings and exploring https://github.com/marklogic/marklogic-samplestack but with no luck. Help of someone who has done that in the past and would like to share his experience would be great.