RESUMO

Nowadays, organizations are very interested to gather data for strategic decision-making. Data are disposable in operational sources, which are distributed, heterogeneous, and autonomous. These data are gathered through ETL processes, which occur traditionally in a pre-defined time, that is, once a day, once a week, once a month or in a specific period of time. On the other hand, there are special applications for which data needs to be obtained in a faster way and sometimes even immediately after the data are generated in the operation data sources, such as health systems and digital agriculture. Thus, the conventional ETL process and the disposable techniques are incapable of making the operational data delivered in real-time, providing low latency, high availability, and scalability. As our proposal, we present an innovative architecture, named Data Magnet, to cope with real-time ETL processes. The experimental tests performed in the digital agriculture domain using real and synthetic data showed that our proposal was able to deal in real-time with the ETL process. The Data Magnet provided great performance, showing an almost constant elapsed time for growing data volumes. Besides, Data Magnet provided significant performance gains over the traditional trigger technique.

RESUMO

Este trabalho apresenta um serviço capaz de criar dinamicamente esquemas de dados relacionais para armazenar o Registro Eletrônico em Saúde (RES) utilizando arquétipos. Baseado na arquitetura da openEHR, nós especificamos um conjunto de regras que mapeiam os atributos de dados, terminologias e restrições, e em seguida, cria as tabelas, campos e restrições de integridade referenciais do esquema de dados. Para validar o serviço aqui proposto, nós utilizamos arquétipos disponíveis no repositório da openEHR para extrair os seus elementos, e assim, gerar esquemas dedados relacionais para armazenar o RES. Como principais contribuições, destaca-se que, esquemas de dados são criados a partir de um padrão em saúde que uniformiza os atributos, terminologias e restrições. Além disso, a especificação do RES feita por um especialista do domínio por meio de arquétipos é utilizada no desenvolvimento de aplicações de saúde.

This paper presents a relational data schemas creation service to store Electronic Health Record (EHR) using archetypes. Based on the openEHR architecture, we specify a set of rules which map data attributes, terminologies and constraints. Afterward, tables, fields and referential integrity restrictions of data schemas are dynamically generated. In order to validate the proposed service, we use archetypes from the openEHR repository to create the relational data schemas. As main contributions, we high light that the data schemas are created based on a health standard and EHR specifications, made by a health professional, are used to develop health applications.

Assuntos

RESUMO

Studies on the validation of minimum data sets from international information standards have drawn the attention of the academic community to the identification of necessary requirements for the development of Electronic Health Records (EHRs). The primary motivation of such studies is the development of systems using archetypes. The aim of this study was to validate the minimum data set that should be used when constructing an archetyped EHR for prenatal care applications in telehealth. In order to achieve this, a data validation tool was built and used by nine expert obstetricians. The statistical analysis employed was the percentage of agreement and the content validity index. The study was conducted in three steps: 1) Literature review, 2)Instrument development, and 3) Validation of the minimum data set. Of the 179 evaluated pieces of data, 157 of them were validated to be included in the archetyped record of the first prenatal consultation, while 56 of them were allocated for the subsequent consultation record. The benefit of this research is the standardization (data validation for an archetyped system) of prenatal care, with the perspective of employing, both nationally and internationally, an archtyped telehealth system.

Assuntos