Treffer: Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases

Title:
Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases
Authors:
Sánchez-de-Madariaga, Ricardo, Muñoz Carrero, Adolfo, Castro, Antonio L, Moreno, Oscar, Pascual-Carrasco, Mario
Contributors:
Instituto de Salud Carlos III
Publisher Information:
JoVE
Publication Year:
2018
Collection:
REPISALUD (REPositorio Institucional en SALUD del Instituto de Salud Carlos III - ISCIII)
Subject Terms:
Medicine, Relational Database, NoSQL Database, Standardized Medical Information, ISO/EN 13606 Standard, ElectronicHealth Record Extract, Algorithmic Complexity, Response Time, Reference Model, Dual Model, Archetype, Clinical Practice, Research Use, Humans, Information Storage and Retrieval, Database Management Systems, Electronic Health Records
Document Type:
Fachzeitschrift article in journal/newspaper
Language:
English
Relation:
https://doi.org/10.3791/57439; info:fis/Instituto de Salud Carlos III/null/null/Subprograma de proyectos de investigacion en salud (AES 2015). Modalidad proyectos en salud. (2015)/PI15/00321; info:eu-repo/grantAgreement/ESPI15/00003; info:fis/Instituto de Salud Carlos III/null/null/Subprograma de proyectos de investigacion en salud (AES 2015). Modalidad proyectos en salud. (2015)/PI15/00831; info:eu-repo/grantAgreement/ESPI15CIII/00010; info:eu-repo/grantAgreement/ESRD16CIII; J Vis Exp. 2018 Mar 19;(133):57439.; http://hdl.handle.net/20.500.12105/7162; Journal of visualized experiments : JoVE
DOI:
10.3791/57439
Availability:
https://hdl.handle.net/20.500.12105/7162
https://doi.org/10.3791/57439
Rights:
http://creativecommons.org/licenses/by-nc-nd/4.0/ ; Attribution-NonCommercial-NoDerivatives 4.0 Internacional ; open access
Accession Number:
edsbas.B40F7990
Database:
BASE

Weitere Informationen

This research shows a protocol to assess the computational complexity of querying relational and non-relational (NoSQL (not only Structured Query Language)) standardized electronic health record (EHR) medical information database systems (DBMS). It uses a set of three doubling-sized databases, i.e. databases storing 5000, 10,000 and 20,000 realistic standardized EHR extracts, in three different database management systems (DBMS): relational MySQL object-relational mapping (ORM), document-based NoSQL MongoDB, and native extensible markup language (XML) NoSQL eXist. The average response times to six complexity-increasing queries were computed, and the results showed a linear behavior in the NoSQL cases. In the NoSQL field, MongoDB presents a much flatter linear slope than eXist. NoSQL systems may also be more appropriate to maintain standardized medical information systems due to the special nature of the updating policies of medical information, which should not affect the consistency and efficiency of the data stored in NoSQL databases. One limitation of this protocol is the lack of direct results of improved relational systems such as archetype relational mapping (ARM) with the same data. However, the interpolation of doubling-size database results to those presented in the literature and other published results suggests that NoSQL systems might be more appropriate in many specific scenarios and problems to be solved. For example, NoSQL may be appropriate for document-based tasks such as EHR extracts used in clinical practice, or edition and visualization, or situations where the aim is not only to query medical information, but also to restore the EHR in exactly its original form. ; This work was supported by Instituto de Salud Carlos III [grant numbers PI15/00321, PI15/00003, PI1500831, PI15CIII/00010 and RD16CIII]. ; Sí