Update of UMLS
Prerequisites:
- Created SOURCES schema.
- Working directory UMLS.
-
Run create_source_tables.sql
-
Download Full UMLS Release Files (for example umls-YYYYAA-full.zip) from http://www.nlm.nih.gov/research/umls/licensedcontent/umlsknowledgesources.html
-
Unpack files MRCONSO.RRF MRHIER.RRF MRMAP.RRF MRSMAP.RRF MRSAT.RRF MRREL.RRF MRSTY.RRF
-
Run in devv5 (with fresh vocabulary date): SELECT sources.load_input_tables('UMLS',TO_DATE('20180507','YYYYMMDD'),'2018AA');