Search

Your search keyword '"ISO/EN 13606 standard"' showing total 4 results
Start Over Descriptor "ISO/EN 13606 standard" Topic algorithmic complexity
4 results on '"ISO/EN 13606 standard"'

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

Author

Ricardo Sánchez-de-Madariaga, Adolfo Muñoz, Raimundo Lozano-Rubí, Pablo Serrano-Balazote, Antonio L. Castro, Oscar Moreno, and Mario Pascual

Subjects
Relational database, NoSQL database, Normalized medical information, ISO/EN 13606 standard, Electronic health record extract, Algorithmic complexity, Computer applications to medicine. Medical informatics, R858-859.7
Abstract

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

Published
2017
Full Text
View/download PDF

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

Author

Sánchez-de-Madariaga, Ricardo, Muñoz, Adolfo, Lozano-Rubí, Raimundo, Serrano-Balazote, Pablo, Castro, Antonio, Moreno, Oscar, Pascual, Mario, Sánchez-de-Madariaga, Ricardo, Muñoz, Adolfo, Lozano-Rubí, Raimundo, and Castro, Antonio L

Subjects
*MANAGEMENT of electronic health records, *COMPUTERS in the health care industry, *ELECTRONIC records, *MEDICAL databases, *INFORMATION storage & retrieval systems, *NONRELATIONAL databases, *INFORMATION retrieval standards, *MANAGEMENT information system standards, *ALGORITHMS, *DATABASES, *WEIGHTS & measures, *EVALUATION research
Abstract

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. [ABSTRACT FROM AUTHOR]

Published
2017
Full Text
View/download PDF

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

Author

Adolfo Muñoz, Antonio L Castro, Ricardo Sánchez-de-Madariaga, Oscar Moreno, Mario Pascual, and Instituto de Salud Carlos III

Subjects
0301 basic medicine, SQL, Relational database, computer.internet_protocol, Computer science, General Chemical Engineering, Relational Database, Research Use, Information Storage and Retrieval, Algorithmic Complexity, NoSQL, computer.software_genre, Standardized Medical Information, Dual Model, General Biochemistry, Genetics and Molecular Biology, Field (computer science), Set (abstract data type), Clinical Practice, Issue 133, 03 medical and health sciences, Consistency (database systems), Humans, Electronic Health Records, Reference Model, ElectronicHealth Record Extract, Electronic Health Record Extract, Protocol (object-oriented programming), computer.programming_language, Archetype, General Immunology and Microbiology, Database, General Neuroscience, ISO/EN 13606 Standard, Response Time, 030104 developmental biology, Medicine, Database Management Systems, computer, XML, NoSQL Database
Abstract

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í

Published
2018

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

Author

Pablo Serrano-Balazote, Mario Pascual, Ricardo Sánchez-de-Madariaga, Raimundo Lozano-Rubí, Oscar Moreno, Adolfo Muñoz, Antonio L Castro, Universitat de Barcelona, Instituto de Salud Carlos III, and Plan Nacional de I+D+i (España)

Subjects
SQL, Non-relational databases, Databases, Factual, Computer science, Relational database, computer.internet_protocol, Concurrency, Secondary research use, Information Storage and Retrieval, Algorismes, Health Informatics, 02 engineering and technology, Clinical practice, lcsh:Computer applications to medicine. Medical informatics, Bases de dades no relacionals, NoSQL, computer.software_genre, Database design, 03 medical and health sciences, 0302 clinical medicine, 020204 information systems, 0202 electrical engineering, electronic engineering, information engineering, Electronic Health Records, 030212 general & internal medicine, Isolation (database systems), Relational databases, Electronic health record extract, computer.programming_language, Information retrieval, Database, Health Policy, Normalized medical information, Reference Standards, Computer Science Applications, Bases de dades relacionals, Primary use, XML database, Document-based task, ISO/EN 13606 standard, lcsh:R858-859.7, NoSQL database, Database Management Systems, Algorithmic complexity, computer, Algorithms, XML, Research Article
Abstract

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. This research has been partially supported by projects PI12/00508 “Plataforma de innovación en nuevos servicios de Telemedicina y e-Salud: Definición, diseño y desarrollo de herramientas para interoperabilidad, seguridad del paciente y ayuda a la decisión (Innovation platform in new services based on Telemedicine and e-Health: definition, design and development of tools for interoperability, patient security and support to decision) – PITES-ISA”, PI15CIII/00003 “Plataforma de innovación en Telemedicina y e-Salud: TIC para los retos de I+i en servicios de salud (Platform for Innovation in Telemedicine and e-Health: ICT for the challenges of I + i in health services) – PITES-TIiSS”, PI12/01476, PI12/01558, PI12/01399 “Continuidad de la asistencia basada en estándares de tecnología y conocimiento: arquitectura tecnológica para usos primario y secundario de la información (Continuity of care based on technology and knowledge standards: technological architecture for primary and secondary information uses.) – CAMAMA2” and PI15CIII/00010 - PI15/00321 - PI15/00831 “Modelo normalizado de historia clínica electrónica compartida para la asistencia sanitaria y social integrada. Factibilidad y utilidad de un repositorio de uso secundario en cáncer de mama (Standard model of shared electronic health record for integrated helath and social care. Feasibility and usefulness of a repository for secundary use for breast cancer patients.) – CAMAMA 3” from Fondo de Investigación Sanitaria (FIS) Plan Nacional de I + D + i. Sí

Published
2017
Full Text
View/download PDF

Catalog

Books, media, physical & digital resources
See catalog results