2024-03-29T12:47:41Zhttp://repisalud.isciii.es/oai/requestoai:repisalud.isciii.es:20.500.12105/68712023-08-31T09:46:50Zcom_20.500.12105_2123com_20.500.12105_2052com_20.500.12105_2051col_20.500.12105_2124
Repisalud
author
Sánchez-de-Madariaga, Ricardo
author
Muñoz Carrero, Adolfo
author
Lozano-Rubí, Raimundo
author
Serrano-Balazote, Pablo
author
Castro, Antonio L
author
Moreno, Oscar
author
Pascual-Carrasco, Mario
funder
Instituto de Salud Carlos III
funder
Plan Nacional de I+D+i (España)
2018-12-17T13:31:00Z
2018-12-17T13:31:00Z
2017-08-18
BMC Med Inform Decis Mak. 2017 Aug 18;17(1):123.
1472-6947
http://hdl.handle.net/20.500.12105/6871
28821246
10.1186/s12911-017-0515-4
1472-6947
BMC medical informatics and decision making
Background: The objective of this research is to compare the relational and non-relational (NoSQL) database systems approaches in order to store, recover, query and persist standardized medical information in the form of ISO/EN 13606 normalized Electronic Health Record XML extracts, both in isolation and concurrently. NoSQL database systems have recently attracted much attention, but few studies in the literature address their direct comparison with relational databases when applied to build the persistence layer of a standardized medical information system. Methods: One relational and two NoSQL databases (one document-based and one native XML database) of three different sizes have been created in order to evaluate and compare the response times (algorithmic complexity) of six different complexity growing queries, which have been performed on them. Similar appropriate results available in the literature have also been considered. Results: Relational and non-relational NoSQL database systems show almost linear algorithmic complexity query execution. However, they show very different linear slopes, the former being much steeper than the two latter. Document-based NoSQL databases perform better in concurrency than in isolation, and also better than relational databases in concurrency. Conclusion: Non-relational NoSQL databases seem to be more appropriate than standard relational SQL databases when database size is extremely high (secondary use, research applications). Document-based NoSQL databases perform in general better than native XML NoSQL databases. EHR extracts visualization and edition are also document-based tasks more appropriate to NoSQL database systems. However, the appropriate database solution much depends on each particular situation and specific problem.
eng
Algorithmic complexity
Clinical practice
Document-based task
Electronic health record extract
ISO/EN 13606 standard
NoSQL database
Normalized medical information
Primary use
Relational database
Secondary research use
Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
journal article
TElDRU5DSUEgREUgRElTVFJJQlVDScOTTiBOTyBFWENMVVNJVkEKCkFjZXB0YW5kbyBlc3RhIGxpY2VuY2lhLCBVc3RlZCAoZWwgYXV0b3IvZXMgbyBlbCBwcm9waWV0YXJpby9zIGRlIGxvcyBkZXJlY2hvcyBkZSAKYXV0b3IpIGNvbmNlZGUgYSBSRVBJU0FMVUQgZWwgZGVyZWNobyBubyBleGNsdXNpdm8gZGUgcmVwcm9kdWNpciwgY29udmVydGlyLCB5L28gCmRpc3RyaWJ1aXIgc3UgZG9jdW1lbnRvIChpbmNsdXllbmRvIHN1IHJlc3VtZW4pIGEgbml2ZWwgbXVuZGlhbCBlbiBmb3JtYXRvIGRpZ2l0YWwsIAppbmNsdXllbmRvLCBhdWRpbyB5IHbDrWRlbywgYSB0cmF2w6lzIGRlIHN1IHJlcG9zaXRvcmlvIGluc3RpdHVjaW9uYWwuCgpVc3RlZCBhY2VwdGEgcXVlIFJFUElTQUxVRCBwdWVkZSwgc2luIGFsdGVyYXIgc3UgY29udGVuaWRvLCBjb252ZXJ0aXIgc3UgZG9jdW1lbnRvIAphIGN1YWxxdWllciBvdHJvIGZvcm1hdG8gZGlnaXRhbCBkZSBkYXRvcywgYXVkaW8geSB2aWRlbywgY29uIGVsIHByb3DDs3NpdG8gZGUgcXVlIApwdWVkYSBzZXIgYWxvamFkbyBlbiBlbCByZXBvc2l0b3Jpby4gCgpVc3RlZCBlc3TDoSBkZSBhY3VlcmRvIGNvbiBxdWUgUkVQSVNBTFVEIHB1ZWRhIGNvbnNlcnZhciBtw6FzIGRlIHVuYSBjb3BpYSBkZSBlc3RlIApkb2N1bWVudG8gcGFyYSBhc2VndXJhciBzdSBzZWd1cmlkYWQsIHByZXNlcnZhY2nDs24geSBhY2Nlc28uCgpVc3RlZCBkZWNsYXJhIHF1ZSBlbCBkb2N1bWVudG8gZXMgdW4gdHJhYmFqbyBvcmlnaW5hbCwgeSBxdWUgdGllbmUgZWwgZGVyZWNobyBkZSAKb3RvcmdhciBsb3MgZGVyZWNob3MgY29udGVuaWRvcyBlbiBlc3RhIGxpY2VuY2lhLiBUYW1iacOpbiBkZWNsYXJhIHF1ZSBzdSBwZXRpY2nDs24gCm5vIGluZnJpbmdlIGxvcyBkZXJlY2hvcyBkZSBhdXRvciBkZSBuYWRpZS4gCgpTaSBlbCBkb2N1bWVudG8gY29udGllbmUgbWF0ZXJpYWxlcyBwYXJhIGxvcyBxdWUgbm8gc2UgdGllbmVuIGxvcyBkZXJlY2hvcyBkZSBhdXRvciwgClVzdGVkIGRlY2xhcmEgcXVlIGhhIG9idGVuaWRvIGVsIHBlcm1pc28gc2luIHJlc3RyaWNjacOzbiBkZWwgcHJvcGlldGFyaW8gZGUgbG9zIApkZXJlY2hvcyB5IHF1ZSBlbiBkaWNobyBtYXRlcmlhbCwgZXN0w6EgY2xhcmFtZW50ZSBpZGVudGlmaWNhZGEgeSByZWNvbm9jaWRhIHN1IAphdXRvcsOtYSBkZW50cm8gZWwgdGV4dG8gbyBkZWwgY29udGVuaWRvIGRlIGRpY2hvIGRvY3VtZW50by4gCgpTaSBlbCBlbnbDrW8gc2UgYmFzYSBlbiB1biB0cmFiYWpvIHF1ZSBoYSBzaWRvIHBhdHJvY2luYWRvIG8gYXBveWFkbyBwb3IgdW5hIGFnZW5jaWEgCnUgb3JnYW5pemFjacOzbiBkaXN0aW50YSBhIFJFUElTQUxVRCwgdXN0ZWQgYWNlcHRhIHF1ZSBoYSBjdW1wbGlkbyBjb24gZWwgZGVyZWNobyBkZSAKcmV2aXNpw7NuIHkgb3RyYXMgb2JsaWdhY2lvbmVzIHJlcXVlcmlkYXMgcG9yIGNvbnRyYXRvIG8gYWN1ZXJkby4gCgpSRVBJU0FMVUQgaWRlbnRpZmljYXLDoSBjbGFyYW1lbnRlIHN1KHMpIG5vbWJyZShzKSBjb21vIGF1dG9yKHMpIG8gcHJvcGlldGFyaW8ocykgCmRlbCBkb2N1bWVudG8sIHkgbm8gaGFyw6EgbmluZ3VuYSBhbHRlcmFjacOzbiwgZXhjZXB0byBzZWfDum4gbG8gcGVybWl0aWRvIHBvciBlc3RhIApsaWNlbmNpYS4gCg==
URL
https://repisalud.isciii.es/bitstream/20.500.12105/6871/1/ExaminingDatabasePersistenceOf_2017.pdf
File
MD5
2b66d9ffdb780a3f8b1d06538e413dee
1007102
application/pdf
ExaminingDatabasePersistenceOf_2017.pdf
URL
https://repisalud.isciii.es/bitstream/20.500.12105/6871/3/ExaminingDatabasePersistenceOf_2017.pdf.txt
File
MD5
cd38867a9080bf5955afb431c1cfc3ee
66866
text/plain
ExaminingDatabasePersistenceOf_2017.pdf.txt