executing-complexity-increasing-queries-relational-mysql-nosql

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

This research shows a protocol to assess the computational complexity of querying relational and non-relational (NoSQL (not only Structured Query ...

Health Institute "Carlos III"

The authors present an Electronic Healthcare Record (EHR) server, designed and developed as a proof of concept of the revised prEN13606:2005 European standard concerning EHR communications.

Proof-of-concept design and development of an EN13606-based electronic health care record service.

The growing availability of continuous data from medical devices in diabetes management makes it crucial to define novel information technology architectures for efficient data storage, data transmission, and data visualization. The new paradigm of care demands the sharing of information in interoperable systems as the only way to support patient care in a continuum of care scenario. The technological platforms should support all the services required by the actors involved in the care process, located in different scenarios and managing diverse information for different purposes. This article presents basic criteria for defining flexible and adaptive architectures that are capable of interoperating with external systems, and integrating medical devices and decision support tools to extract all the relevant knowledge to support diabetes care.

Definition of information technology architectures for continuous data management and medical device integration in diabetes.

Healthcare management is oriented toward single diseases, yet multimorbidity is nevertheless the rule and there is a tendency for certain diseases to occur in clusters. This study sought to identify comorbidity patterns in patients with chronic diseases, by reference to number of comorbidities, age and sex, in a population receiving medical care from 129 general practitioners in Spain, in 2007.

Comorbidity patterns in patients with chronic diseases in general practice.

Chronic obstructive pulmonary disease (COPD) is frequent and often coexists with other diseases. The aim of this study was to quantify the prevalence of COPD and related chronic comorbidity among patients aged over 40 years visiting family practices in an area of Madrid.

Comorbidity in patients with chronic obstructive pulmonary disease in family practice: a cross sectional study.

In order to ensure proper management of primary care (PC) services, the efficiency of the health professionals tasked with such services must be known. Patients with heart failure (HF) are characterized by advanced age, high co-morbidity and high resource utilization.

Heart failure in primary care: co-morbidity and utilization of health care resources.

A new mark-up programming language is introduced in order to facilitate and improve the visualization of ISO/EN 13606 dual model-based normalized medical information. This is the first time that visualization of normalized medical information is addressed and the programming language is intended to be used by medical non-IT professionals.

Normalized medical information visualization.

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.

Article	Year
Proof-of-concept design and development of an EN13606-based electronic health care record service. Journal of the American Medical Informatics Association : JAMIA\| PubMed ID: 17068357	2007
Definition of information technology architectures for continuous data management and medical device integration in diabetes. Journal of diabetes science and technology\| PubMed ID: 19885276	2008
Comorbidity patterns in patients with chronic diseases in general practice. PloS one\| PubMed ID: 22359665	2012
Comorbidity in patients with chronic obstructive pulmonary disease in family practice: a cross sectional study. BMC family practice\| PubMed ID: 23324308	2013
Heart failure in primary care: co-morbidity and utilization of health care resources. Family practice\| PubMed ID: 23776041	2013
Normalized medical information visualization. Studies in health technology and informatics\| PubMed ID: 25991133	2015
Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches. BMC medical informatics and decision making\| PubMed ID: 28821246	2017

Mario Pascual

Biography

JoVE Journal Publications

Other Publications