December 3, 2007 README: RxNorm 12/03/2007 Full Update Release =================================================== ----------------------------------------------------------------- This Full release contains data that is consistent with the 2007AC version of the UMLS. ----------------------------------------------------------------- This release contains updates to the following seven sources: GS - 11/14/2007 (Gold Standard Alchemy) MDDB - 11/07/2007 (Master Drug Data Base. Medi-Span, a division of Wolters Kluwer Health) MMSL - 11/01/2007 (Multum MediSource Lexicon) MMX - 11/05/2007 (Micromedex DRUGDEX) MTHFDA - 09/12/2007 (FDA National Drug Code Directory) MTHSPL - 11/19/2007 (FDA Structured Product Labels) NDDF - 11/09/2007 (First DataBank NDDF Plus Source Vocabulary) This release does not contain updates to these sources: SNOMED CT - 07/31/2007 (SNOMED Clinical Terms (drug information). SNOMED International) VANDF - 08/21/2007 (Veterans Health Administration National Drug File) 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_12032007.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 481 MB of free hard disk space (To accomodate ZIP files and unzipped contents). CONTENTS OF THE ZIP FILE ------------------------- The ZIP formatted file is 56,905,372 bytes and contains the following 19 files and 2 directories: Readme_Full_12032007.txt 3,260 bytes rrf directory: RXNCONSO.RRF 80,153,572 bytes RXNDOC.RRF 150,534 bytes RXNREL.RRF 82,986,678 bytes RXNSAB.RRF 5,714 bytes RXNSAT.RRF 238,536,556 bytes RXNSTY.RRF 11,734,643 bytes RXNATOMARCHIVE.RRF 21,318,846 bytes RXNCUICHANGES.RRF 162,730 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