search

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases
https://mimic.mit.edu
MIT License
2.43k stars 1.5k forks source link

update load mimic-iv-note into a local postgresql tutorial #1517

Closed yongfanbeta closed 1 year ago

yongfanbeta commented 1 year ago

https://github.com/MIT-LCP/mimic-code/discussions/1490

alistairewj commented 1 year ago

Hmm is there an advantage in using a second database mimiciv_note? For me it seems easier to just use a single database (mimiciv) for all the data.

yongfanbeta commented 1 year ago

@alistairewj the main reason is that mimiciv and mimic-iv-notes are now stored separately on PhysioNet, if we use a single datebase like mimiciii, you need to update two database on physionet simultaneously, otherwise, when one datebase is change, we need to load all data again including the data don't change.

alistairewj commented 1 year ago

Each dataset is stored on a different schema (mimiciv_hosp, mimiciv_note, mimiciv_ed). You definitely don't need to reload data in one schema when creating/loading the other.

yongfanbeta commented 1 year ago

oh! I get it. so we only need to change the mimiciv_note data_dir in readme file.

alistairewj commented 1 year ago

Yes probably! Feel free to open a new PR if there are modifications you think would be useful given our discussion.