Skip to main page content
U.S. flag

An official website of the United States government

Dot gov

The .gov means it’s official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you’re on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

Access keys NCBI Homepage MyNCBI Homepage Main Content Main Navigation
. 2022 Jun 16:10:917994.
doi: 10.3389/fped.2022.917994. eCollection 2022.

Establishment of a Simple Pediatric Lower Respiratory Tract Infections Database Based on the Structured Electronic Medical Records

Affiliations

Establishment of a Simple Pediatric Lower Respiratory Tract Infections Database Based on the Structured Electronic Medical Records

Jilei Lin et al. Front Pediatr. .

Abstract

Objective: This study aimed to establish a pediatric lower respiratory tract infections (PLRTIs) database based on the structured electronic medical records (SEMRs), to provide a brief overview and the usage process of the SEMRs and the database.

Methods: All the medical information is recorded by a clinical information system developed by Eureka Systems Company. A plugin of the software was used to set the properties of items of the SEMR. Children with lower respiratory tract infections (LRTIs) who were admitted to the department of respiratory medicine of our hospital from May 2020 were included. PostgreSQL 13.1 software was used to construct the PLRTIs database.

Results: Seven kinds of SEMRs were established, and the admission record was the most important and complex among them. It was mainly composed of 10 parts, i.e., basic information, history of present illness, past history (without respiratory disease), past history of respiratory diseases, personal history, family history, physical examination, the score of LRTIs, auxiliary examination, and diagnosis. With the three-level doctor ward round, the recorded information of the SEMR would be checked repeatedly, thus guaranteeing the correctness of the information. The data of the SEMR and laboratory tests could be extracted directly from the hospital information system (HIS) by PostgreSQL 13.1 software with the specific structured query language (SQL) code. After manually checking the original records, the datasets were imported into PostgreSQL 13.1 software, and a simple PLRTIs database was constructed. According to the inclusion criteria of this study, a total of 1,184 children with LRTIs were included in this database from 1 May 2020 to 30 April 2021.

Conclusion: A series of SEMRs for PLRTIs were designed and used during the hospitalization. A simple PLRTIs database was established based on the SEMR. The SEMRs will provide complete and high-quality data on LRTIs in children.

Keywords: children; database; hospitalization; lower respiratory tract infections; structured electronic medical records.

PubMed Disclaimer

Conflict of interest statement

The authors declare that the research was conducted in the absence of any commercial or financial relationships that could be construed as a potential conflict of interest.

Figures

Figure 1
Figure 1
The outline of the structured electronic medical record (SEMR) of admission record.
Figure 2
Figure 2
The flow chart of the process of usage of the structured electronic medical record.
Figure 3
Figure 3
Flow diagram of the selected cases.
Figure 4
Figure 4
The changes in the number and proportions of children with lower respiratory tract infections (LRTIs) per month in this database.

References

    1. Wang X, Li Y, Deloria-Knoll M, Madhi SA, Cohen C, Ali A, et al. . Global burden of acute lower respiratory infection associated with human metapneumovirus in children under 5 years in 2018: a systematic review and modelling study. Lancet Glob Health. (2021) 9:e33–43. - PMC - PubMed
    1. McAllister DA, Liu L, Shi T, Chu Y, Reed C, Burrows J, et al. . Global, regional, and national estimates of pneumonia morbidity and mortality in children younger than 5 years between 2000 and 2015: a systematic analysis. Lancet Glob Health. (2019) 7:e47–57. 10.1016/S2214-109X(18)30408-X - DOI - PMC - PubMed
    1. Khurshid S, Reeder C, Harrington LX, Singh P, Sarma G, Friedman SF, et al. . Cohort design and natural language processing to reduce bias in electronic health records research. NPJ Digit Med. (2022) 5:47. 10.1038/s41746-022-00590-0 - DOI - PMC - PubMed
    1. Hankey BF, Ries LA, Edwards BK. The surveillance, epidemiology, and end results program: a national resource. Cancer Epidemiol Biomarkers Prev. (1999) 8:1117–21. 10.2105/AJPH.89.12.1895 - DOI - PubMed
    1. Li Z, Shen T, Han Y. Effect of serum phosphate on the prognosis of septic patients: a retrospective study based on MIMIC-IV database. Front Med (Lausanne). (2022) 9:728887. 10.3389/fmed.2022.728887 - DOI - PMC - PubMed

LinkOut - more resources