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

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 isolatio...

Descripción completa

Detalles Bibliográficos
Autores: Sánchez de Madariaga, Ricardo, Muñoz Carrero, Adolfo, Lozano Rubí, Raimundo, Serrano Balazote, Pablo, Castro, Antonio L., Moreno, Oscar, Pascual, Mario
Tipo de recurso: artículo
Estado:Versión publicada
Fecha de publicación:2017
País:España
Institución:Universidad de Barcelona
Repositorio:Dipòsit Digital de la UB
OAI Identifier:oai:diposit.ub.edu:2445/122014
Acceso en línea:https://hdl.handle.net/2445/122014
Access Level:acceso abierto
Palabra clave:Bases de dades relacionals
Algorismes
Bases de dades no relacionals
Relational databases
Algorithms
Non-relational databases
id ES_e1d6320d63f7859af6be38ea01d99dfa
oai_identifier_str oai:diposit.ub.edu:2445/122014
network_acronym_str ES
network_name_str España
repository_id_str
spelling Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approachesSánchez de Madariaga, RicardoMuñoz Carrero, AdolfoLozano Rubí, RaimundoSerrano Balazote, PabloCastro, Antonio L.Moreno, OscarPascual, MarioBases de dades relacionalsAlgorismesBases de dades no relacionalsRelational databasesAlgorithmsNon-relational databasesBackground: 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.BioMed Central2017info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdfhttps://hdl.handle.net/2445/122014Articles publicats en revistes (Fonaments Clínics)reponame:Dipòsit Digital de la UBinstname:Universidad de BarcelonaInglésReproducció del document publicat a: https://doi.org/10.1186/s12911-017-0515-4BMC Medical Informatics and Decision Making, 2017, vol. 17, num. 123https://doi.org/10.1186/s12911-017-0515-4cc-by (c) Sánchez de Madariaga, Ricardo et al., 2017http://creativecommons.org/licenses/by/3.0/esinfo:eu-repo/semantics/openAccessoai:diposit.ub.edu:2445/1220142026-05-27T06:46:51Z
dc.title.none.fl_str_mv Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
title Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
spellingShingle Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
Sánchez de Madariaga, Ricardo
Bases de dades relacionals
Algorismes
Bases de dades no relacionals
Relational databases
Algorithms
Non-relational databases
title_short Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
title_full Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
title_fullStr Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
title_full_unstemmed Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
title_sort Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches
dc.creator.none.fl_str_mv Sánchez de Madariaga, Ricardo
Muñoz Carrero, Adolfo
Lozano Rubí, Raimundo
Serrano Balazote, Pablo
Castro, Antonio L.
Moreno, Oscar
Pascual, Mario
author Sánchez de Madariaga, Ricardo
author_facet Sánchez de Madariaga, Ricardo
Muñoz Carrero, Adolfo
Lozano Rubí, Raimundo
Serrano Balazote, Pablo
Castro, Antonio L.
Moreno, Oscar
Pascual, Mario
author_role author
author2 Muñoz Carrero, Adolfo
Lozano Rubí, Raimundo
Serrano Balazote, Pablo
Castro, Antonio L.
Moreno, Oscar
Pascual, Mario
author2_role author
author
author
author
author
author
dc.subject.none.fl_str_mv Bases de dades relacionals
Algorismes
Bases de dades no relacionals
Relational databases
Algorithms
Non-relational databases
topic Bases de dades relacionals
Algorismes
Bases de dades no relacionals
Relational databases
Algorithms
Non-relational databases
description 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.
publishDate 2017
dc.date.none.fl_str_mv 2017
dc.type.none.fl_str_mv info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
format article
status_str publishedVersion
dc.identifier.none.fl_str_mv https://hdl.handle.net/2445/122014
url https://hdl.handle.net/2445/122014
dc.language.none.fl_str_mv Inglés
language_invalid_str_mv Inglés
dc.relation.none.fl_str_mv Reproducció del document publicat a: https://doi.org/10.1186/s12911-017-0515-4
BMC Medical Informatics and Decision Making, 2017, vol. 17, num. 123
https://doi.org/10.1186/s12911-017-0515-4
dc.rights.none.fl_str_mv cc-by (c) Sánchez de Madariaga, Ricardo et al., 2017
http://creativecommons.org/licenses/by/3.0/es
info:eu-repo/semantics/openAccess
rights_invalid_str_mv cc-by (c) Sánchez de Madariaga, Ricardo et al., 2017
http://creativecommons.org/licenses/by/3.0/es
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv BioMed Central
publisher.none.fl_str_mv BioMed Central
dc.source.none.fl_str_mv Articles publicats en revistes (Fonaments Clínics)
reponame:Dipòsit Digital de la UB
instname:Universidad de Barcelona
instname_str Universidad de Barcelona
reponame_str Dipòsit Digital de la UB
collection Dipòsit Digital de la UB
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869422330195738624
score 15,301603

Similares en LA Referencia