Neo4j

nahmed · 07-22-2022

I am trying to convert this long SQL query to cypher. I have two types of node: patient and apachepatientresult. Both having a common relation using node property as patientunitstayid. How can I achieve this?. Please help drop materialized view if ex...

nahmed · 07-24-2022

Thank you so much. the first query you posted works fine. And after creating an index of the node attributes, it is also much faster.

nahmed · 07-23-2022

'patientHealthSystemStayID' is connected to the apacheApsVar table. I will recreate the model having patient node with the uniquepid, and seperate node for the PatientVisit. Thank you so much. But what would be the query then?

nahmed · 07-23-2022

The 'patient' table in sql does not represent a patient per record, but rather multiple stays of every patient in a hospital. Here is the link of the actual schema which I am following. https://eicu-crd.mit.edu/eicutables/patient/ . 'patientUnitStayI...

nahmed · 07-23-2022

Hello Ninja, Thank you for your response. I have attached the database schema.

Neo4j

User Statistics

User Activity

SQL to Cypher having multiple nested inner join

Re: SQL to Cypher having multiple nested inner join

Re: SQL to Cypher having multiple nested inner join

Re: SQL to Cypher having multiple nested inner join

Re: SQL to Cypher having multiple nested inner join