Update of CIEL
Annotation: We got vocabulary from mysql dumpfile. But this dumpfile cannot be directly imported to Oracle, we used local MySQL DB to convert dump to csv files and manually transform them into SQL Loader file.
Prerequisites:
- Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
- RxNorm and SNOMED must be loaded first.
- Working directory CIEL.
- Run create_source_tables.sql
- Unzip CIEL_CTL.zip
- Load *.ctl using SQL Loader
- Run load_stage.sql (with updated pVocabularyDate = latest update of vocabulary)
- Run generic_update.sql (from working directory)