Loading MIMIC II data using windows, matlab and postgre SQL
% How to load mimic II data in windows with matlab and postgreSQL
%
% 1. install postgreSQL for windows,
% 2. create database with name MIMIC2;
% 3. run schema schema_mimic2v26.sql, which is available at https://physionet.org/works/MIMICIIClinicalDatabase/files/
% 4. make sure the 'Definitions' folder is available under the "currentPath" given in the matlab code.
% 5. make sure the folders for each patient are available. file in steps 4 and 5 can be obtained from,
% https://physionet.org/works/MIMICIIClinicalDatabase/files/
% 6. change the userName and password for your database and currentPath in the matlab code.
% 7. instal jdbc driver of postgre for matlab (e.g. add a line "C:\DB_Drivers\postgresql-9.2-1002.jdbc4.jar" in c:\Program
% Files\MATLAB\R2012a\toolbox\local\classpath.txt), where the drive can be downloaded from the postgre website.
% 8. run the matlab script improt_mimic_data.m
% 9. run indices_mimic2v26.sql, which is available at https://physionet.org/works/MIMICIIClinicalDatabase/files/
Cite As
Shuang Wang (2024). Loading MIMIC II data using windows, matlab and postgre SQL (https://www.mathworks.com/matlabcentral/fileexchange/40539-loading-mimic-ii-data-using-windows-matlab-and-postgre-sql), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.