Evidence map›Paper›PMID 28821246›Full record

ArticleBMC medical informatics and decision making2017

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

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

Abstract readComparative Study
PubMed Full text at PMC Publisher
In one paragraph

Article in BMC medical informatics and decision making, 2017. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 4 papers.

0numbers the graph read from it
0cells of the map it votes in
4citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

4 citing papers in PubMed.

  1. ACE: the Advanced Cohort Engine for searching longitudinal patient records.Journal of the American Medical Informatics Association : JAMIA · 2021
    Article
  2. Article
  3. Article
  4. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

7 authors.

Ricardo Sánchez-de-MadariagaTelemedicine and Information Society Department, Health Institute "Carlos III" (ISCIII), c/Sinesio Delgado, 4 -, 28029, Madrid, Spain. ricardo.sanchez@isciii.es.ORCID http://orcid.org/0000-0002-6151-3673
Adolfo MuñozTelemedicine and Information Society Department, Health Institute "Carlos III" (ISCIII), c/Sinesio Delgado, 4 -, 28029, Madrid, Spain.
Raimundo Lozano-RubíMedical Informatics, Hospital Clínic, Unit of Medical Informatics, University of Barcelona, Barcelona, Spain.
Pablo Serrano-BalazoteDoce de Octubre University Hospital, Madrid, Spain.
Antonio L CastroTelemedicine and Information Society Department, Health Institute "Carlos III" (ISCIII), c/Sinesio Delgado, 4 -, 28029, Madrid, Spain.
Oscar MorenoTelemedicine and Information Society Department, Health Institute "Carlos III" (ISCIII), c/Sinesio Delgado, 4 -, 28029, Madrid, Spain.
Mario PascualTelemedicine and Information Society Department, Health Institute "Carlos III" (ISCIII), c/Sinesio Delgado, 4 -, 28029, Madrid, Spain.

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

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

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

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

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

Indexed as

AlgorithmsDatabase Management SystemsDatabases, FactualElectronic Health RecordsInformation Storage and RetrievalReference StandardsAlgorithmic complexityClinical practiceDocument-based taskElectronic health record extractISO/EN 13606 standardNormalized medical informationNoSQL databasePrimary useRelational databaseSecondary research use

Identifiers

PMID28821246
PMCPMC5563027

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.