2026-06-16T14:05:23Zhttps://repisalud.isciii.es/rest/oai/requestoai:repisalud.isciii.es:20.500.12105/71622025-05-27T08:17:01Zcom_20.500.12105_2052com_20.500.12105_2051col_20.500.12105_19619
Repisalud
author
Sánchez-de-Madariaga, Ricardo
author
Muñoz Carrero, Adolfo
author
Castro, Antonio L
author
Moreno, Oscar
author
Pascual-Carrasco, Mario
funder
Instituto de Salud Carlos III
2019-02-11T12:04:22Z
2019-02-11T12:04:22Z
2018-03-19
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
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.
eng
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
research article
TElDRU5DSUEgREUgRElTVFJJQlVDScOTTiBOTyBFWENMVVNJVkEKCkFjZXB0YW5kbyBlc3RhIGxpY2VuY2lhLCBVc3RlZCAoZWwgYXV0b3IvZXMgbyBlbCBwcm9waWV0YXJpby9zIGRlIGxvcyBkZXJlY2hvcyBkZSAKYXV0b3IpIGNvbmNlZGUgYSBSRVBJU0FMVUQgZWwgZGVyZWNobyBubyBleGNsdXNpdm8gZGUgcmVwcm9kdWNpciwgY29udmVydGlyLCB5L28gCmRpc3RyaWJ1aXIgc3UgZG9jdW1lbnRvIChpbmNsdXllbmRvIHN1IHJlc3VtZW4pIGEgbml2ZWwgbXVuZGlhbCBlbiBmb3JtYXRvIGRpZ2l0YWwsIAppbmNsdXllbmRvLCBhdWRpbyB5IHbDrWRlbywgYSB0cmF2w6lzIGRlIHN1IHJlcG9zaXRvcmlvIGluc3RpdHVjaW9uYWwuCgpVc3RlZCBhY2VwdGEgcXVlIFJFUElTQUxVRCBwdWVkZSwgc2luIGFsdGVyYXIgc3UgY29udGVuaWRvLCBjb252ZXJ0aXIgc3UgZG9jdW1lbnRvIAphIGN1YWxxdWllciBvdHJvIGZvcm1hdG8gZGlnaXRhbCBkZSBkYXRvcywgYXVkaW8geSB2aWRlbywgY29uIGVsIHByb3DDs3NpdG8gZGUgcXVlIApwdWVkYSBzZXIgYWxvamFkbyBlbiBlbCByZXBvc2l0b3Jpby4gCgpVc3RlZCBlc3TDoSBkZSBhY3VlcmRvIGNvbiBxdWUgUkVQSVNBTFVEIHB1ZWRhIGNvbnNlcnZhciBtw6FzIGRlIHVuYSBjb3BpYSBkZSBlc3RlIApkb2N1bWVudG8gcGFyYSBhc2VndXJhciBzdSBzZWd1cmlkYWQsIHByZXNlcnZhY2nDs24geSBhY2Nlc28uCgpVc3RlZCBkZWNsYXJhIHF1ZSBlbCBkb2N1bWVudG8gZXMgdW4gdHJhYmFqbyBvcmlnaW5hbCwgeSBxdWUgdGllbmUgZWwgZGVyZWNobyBkZSAKb3RvcmdhciBsb3MgZGVyZWNob3MgY29udGVuaWRvcyBlbiBlc3RhIGxpY2VuY2lhLiBUYW1iacOpbiBkZWNsYXJhIHF1ZSBzdSBwZXRpY2nDs24gCm5vIGluZnJpbmdlIGxvcyBkZXJlY2hvcyBkZSBhdXRvciBkZSBuYWRpZS4gCgpTaSBlbCBkb2N1bWVudG8gY29udGllbmUgbWF0ZXJpYWxlcyBwYXJhIGxvcyBxdWUgbm8gc2UgdGllbmVuIGxvcyBkZXJlY2hvcyBkZSBhdXRvciwgClVzdGVkIGRlY2xhcmEgcXVlIGhhIG9idGVuaWRvIGVsIHBlcm1pc28gc2luIHJlc3RyaWNjacOzbiBkZWwgcHJvcGlldGFyaW8gZGUgbG9zIApkZXJlY2hvcyB5IHF1ZSBlbiBkaWNobyBtYXRlcmlhbCwgZXN0w6EgY2xhcmFtZW50ZSBpZGVudGlmaWNhZGEgeSByZWNvbm9jaWRhIHN1IAphdXRvcsOtYSBkZW50cm8gZWwgdGV4dG8gbyBkZWwgY29udGVuaWRvIGRlIGRpY2hvIGRvY3VtZW50by4gCgpTaSBlbCBlbnbDrW8gc2UgYmFzYSBlbiB1biB0cmFiYWpvIHF1ZSBoYSBzaWRvIHBhdHJvY2luYWRvIG8gYXBveWFkbyBwb3IgdW5hIGFnZW5jaWEgCnUgb3JnYW5pemFjacOzbiBkaXN0aW50YSBhIFJFUElTQUxVRCwgdXN0ZWQgYWNlcHRhIHF1ZSBoYSBjdW1wbGlkbyBjb24gZWwgZGVyZWNobyBkZSAKcmV2aXNpw7NuIHkgb3RyYXMgb2JsaWdhY2lvbmVzIHJlcXVlcmlkYXMgcG9yIGNvbnRyYXRvIG8gYWN1ZXJkby4gCgpSRVBJU0FMVUQgaWRlbnRpZmljYXLDoSBjbGFyYW1lbnRlIHN1KHMpIG5vbWJyZShzKSBjb21vIGF1dG9yKHMpIG8gcHJvcGlldGFyaW8ocykgCmRlbCBkb2N1bWVudG8sIHkgbm8gaGFyw6EgbmluZ3VuYSBhbHRlcmFjacOzbiwgZXhjZXB0byBzZWfDum4gbG8gcGVybWl0aWRvIHBvciBlc3RhIApsaWNlbmNpYS4gCg==
URL
https://repisalud.isciii.es/bitstreams/8de16c01-efe5-47f5-bb5c-96a680582814/download
File
MD5
0fa8260a1a51cb8daa7fad43b8d2c357
461210
application/pdf
ExecutingComplexityIncreasingQueries_2018 .pdf
URL
https://repisalud.isciii.es/bitstreams/328782f2-1eef-4d03-a563-dae0a193f45d/download
File
MD5
dde1aea1e8c908649808358de7dfd7e7
34789
text/plain
ExecutingComplexityIncreasingQueries_2018 .pdf.txt