September 4, 2007 README: RxNorm 09/04/2007 Full Update Release =================================================== ----------------------------------------------------------------- This Full release contains data that is consistent with the 2007AB version of the UMLS. ----------------------------------------------------------------- This release contains updates to the following eight sources: GS - 08/12/2007 (Gold Standard Alchemy) MDDB - 08/08/2007 (Master Drug Data Base. Medi-Span, a division of Wolters Kluwer Health) MMSL - 08/01/2007 (Multum MediSource Lexicon) MMX - 08/06/2007 (Micromedex DRUGDEX) MTHFDA - 08/10/2007 (FDA National Drug Code Directory) MTHSPL - 08/20/2007 (FDA Structured Product Labels) NDDF - 08/10/2007 (First DataBank NDDF Plus Source Vocabulary) VANDF - 07/24/2007 (Veterans Health Administration National Drug File) This release does not contain updates to this source: SNOMED CT - 01/31/2007 (SNOMED Clinical Terms (drug information). SNOMED International) New in this release are the addition of a modified format for SCD and SBD forms and duplicate source atoms. For full details, please refer to the RxNorm documentation at http://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html. In addition, this release contains database control files and SQL commands for use in the automation of the loading process of these files into a RDBMS (Oracle in this case). RxNorm release data files are available by download from the UMLS Knowledge Source Server (UMLSKS) at: http://umlsks.nlm.nih.gov Use the "RxNorm Files" link, under the "Downloads" category on the UMLSKS home page. This link will take you to a page for downloading the latest files: RxNorm_full_09042007.zip This RxNorm update is available only through the UMLSKS server. Once downloaded, it must be unzipped in order to access the files. HARDWARE AND SOFTWARE RECOMMENDATIONS ------------------------------------- - Supported operating systems: Windows: XP, 2000, NT Linux Solaris: Solaris 8 and 9 Macintosh OS 9 or OS 10 - Hardware Requirements - A MINIMUM 477 MB of free hard disk space (To accomodate ZIP files and unzipped contents). CONTENTS OF THE ZIP FILE ------------------------- The ZIP formatted file is 56,331,400 bytes and contains the following 19 files and 2 directories: Readme_Full_09042007.txt 3,369 bytes rrf directory: RXNCONSO.RRF 79,148,652 bytes RXNDOC.RRF 149,102 bytes RXNREL.RRF 87,873,451 bytes RXNSAB.RRF 5,694 bytes RXNSAT.RRF 231,609,514 bytes RXNSTY.RRF 11,710,269 bytes RXNATOMARCHIVE.RRF 20,821,709 bytes RXNCUICHANGES.RRF 140,162 bytes scripts directory: RXNATOMARCHIVE.ctl 564 bytes RXNCONSO.ctl 512 bytes RXNCUICHANGES.ctl 346 bytes RXNDOC.ctl 248 bytes RXNREL.ctl 472 bytes RXNSAB.ctl 673 bytes RXNSAT.ctl 376 bytes RXNSTY.ctl 267 bytes RxNormDDL.sql 3,125 bytes populate_oracle_rxn_db.bat 1,088 bytes Additional NOTES: ----------------- - Most RxNorm users will need applications and data management systems such as an RDBMS for storage and retrieval. - The RxNorm release files contain UTF-8 Unicode encoded data. - Refer to the RxNorm release documentation at http://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html for information on the contents of the RxNorm Release Files