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
. 2015 Mar;7(3):238-42.
doi: 10.3978/j.issn.2072-1439.2015.02.14.

Accessing critical care big data: a step by step approach

Zhongheng Zhang  1
Affiliations

Accessing critical care big data: a step by step approach

Zhongheng Zhang. J Thorac Dis. 2015 Mar.
No abstract available

PubMed Disclaimer

Figures

Figure 1
Figure 1
A general introduction to the multiparameter intelligent monitoring in intensive care-2 (MIMIC-2) clinical database.
Figure 2
Figure 2
Setup of a virtual machine. MIMIC-2, multiparameter intelligent monitoring in intensive care-2.
Figure 3
Figure 3
Launching the Ubuntu operating system with password.
Figure 4
Figure 4
The black screen icon on top left of the VM desktop.
Figure 5
Figure 5
After opening the terminal, this window will pop up where we can type command.
Figure 6
Figure 6
Open the pgAdmin III as illustrated in this figure.
Figure 7
Figure 7
New server registration. The Host should be blank. The Username should be “mimic2”. The “Maintenance DB” should be “MIMIC2”. MIMIC-2, multiparameter intelligent monitoring in intensive care-2.
Figure 8
Figure 8
Structure of the MIMIC local server. Expand the schema and you will find there are 38 relational tables in the database, which exactly matches what we can see in the query builder explorer. MIMIC-2, multiparameter intelligent monitoring in intensive care-2.
Figure 9
Figure 9
The query language is input at the upper panel and the lower panel displays the result of the query. Make sure that the SQL is exactly correct.
Figure 10
Figure 10
Export data to file. Specify the directory you want to save your data.
See this image and copyright information in PMC

References

    1. Zhang Z.Big data and clinical research: perspective from a clinician. J Thorac Dis 2014;6:1659-64. - PMC - PubMed
    1. Zhang Z.Big data and clinical research. J Clin Pathol Res 2014;34:492-7.