2026-06-14T03:29:06Zhttps://repisalud.isciii.es/rest/oai/request

oai:repisalud.isciii.es:20.500.12105/71622025-05-27T08:17:01Zcom_20.500.12105_2052com_20.500.12105_2051col_20.500.12105_19619

00925njm 22002777a 4500 dc Sánchez-de-Madariaga, Ricardo author Muñoz Carrero, Adolfo author Castro, Antonio L author Moreno, Oscar author Pascual-Carrasco, Mario author 2018-03-19 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. J Vis Exp. 2018 Mar 19;(133):57439. 10.3791/57439 1940-087X Journal of visualized experiments : JoVE 29608174 http://hdl.handle.net/20.500.12105/7162 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 Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases