Skip to main content

Table 1 Six queries performed on relational and NoSQL databases

From: Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches

  Query
Q1 Find all problems of a single patient
Q2 Find all problems of all patients
Q3 Find initial date, resolution date and severity of a single problem of a single patient
Q4 Find initial date, resolution date and severity of all problems of a single patient
Q5 Find initial date, resolution date and severity of all problems of all patients
Q6 Find all patients with problem ‘pharyngitis’, initial date > = ‘16/10/2007’, resolution date <= ‘06/05/2008’ and severity ‘high’