Enabling flexible integration of healthcare information using the entity-attribute-value storage model

Abstract

BackgroundFor an optimal care of patients in home healthcare, it is essential to exchange healthcare-related information with other stakeholders. Unfortunately, paper-based documentation procedures as well as the heterogeneity between information systems inhibit a well-regulated communication. Therefore, a digital patient care record is introduced to establish the foundation for integrating healthcare-related information.MethodsFor the digital patient care record, suitable integration techniques are required that store data in a compact way and offer flexibility as well as robustness. For this purpose, a generic storage structure based on the entity-attribute-value (EAV) model is introduced. This storage structure fulfills the stated requirements and incoming information can be stored directly without any loss of data.Evaluation Results and DiscussionsFirst performance tests regarding the query response time are given in this paper. The tests measured the connection time, the query execution time, and the time for traversing the result set. The time for executing the query is lowest. The time for traversing the results strongly depends on the number of documents. A concept comparison to other integration techniques is also presented.ConclusionsThis approach offers flexibility concerning different standard types and the evolution in healthcare knowledge and processes. It also allows for highly sparse data to be stored in a compact way. The underlying database structure is presented, the import process for extracting incoming reports is described and the export process for generating new outgoing standardized reports is briefly illustrated.

Une plateforme multimodale d’aide à la décision. Application à la prise en charge du cancer du sein dans le cadre du projet DESIREE

“…D'un point de vue logique, les modèles de données, qu'ils soient relationnels ou objet, peuvent être traduits dans le modèle EAV. Il est considéré comme suffisamment flexible pour modéliser des données biomédicales (Nadkarni et al, 1999 ;Löper et al, 2013 ;Khan et al, 2014). Nous avons donc structuré l'ontologie au travers du prisme du modèle EAV et nous avons choisi de représenter explicitement sous forme de classes/concepts les trois éléments du modèle EAV, les entités, les attributs et les valeurs.…”

Big data management challenges in health research—a literature review

“…With a few exceptions [29,44,45], the database performance (i.e. query speed, accuracy and throughput) and data usability (i.e.…”

“…In biomedical data capture and archiving practice, both RDBMS and NoSQL DBMS have been used to build database tools [28,34,38,[60][61][62]. In the RDBMS environment, a particular data structure, EAV, has been a popular strategy to 'boost' database flexibility [24,28,29,45,61]. However, researchers and users soon noticed system performance and data usability problems [29,[63][64][65].…”

Enabling Large-Scale Biomedical Analysis in the Cloud

“…By deploying applications with these tools, small laboratories could maintain and process the large-scale datasets within affordable costs, which is increasingly thorny even for large institutes. For example, BioVLab infrastructure [ 28 , 36 ] built on the cloud is developed for genome analysis by utilizing the virtual collaborative lab , a suite of tools that allow scientists to orchestrate a sequence of data analysis tasks using remote computing resources and data storage facilities on demand from local devices. Furthermore, the Crossbow [ 21 ] genotyping program applies the MapReduce workflow on Hadoop to launch many copies of the short-read aligner Bowtie [ 20 ] in parallel.…”