openEHR with SQL and graph traversal
· 2 min read
I made some progress with SQL queries using graph traversal over openEHR data:
COMPOSITION.encounter.v1 has OBSERVATION.blood_pressure.v2
Since ArcEHR maps openEHR Reference Model (RM) to the graph database, we can use graph traversal to query the openEHR data. The data stored in the graph database is much more efficient than the relational database. No joins are needed to retrieve the data. We use out('has_openEHR-EHR-OBSERVATION.blood_pressure.v2') to get all the blood pressure records for a given COMPOSITION or EHR.