February 1, 2008 README: RxNorm 02/01/2008 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 eight sources: GS - 01/08/2008 (Gold Standard Alchemy) MDDB - 01/03/2008 (Master Drug Data Base. Medi-Span, a division of Wolters Kluwer Health) MMSL - 01/01/2008 (Multum MediSource Lexicon) MMX - 01/02/2008 (Micromedex DRUGDEX) MTHFDA - 01/04/2008 (FDA National Drug Code Directory) MTHSPL - 01/23/2008 (FDA Structured Product Labels) NDDF - 01/04/2008 (First DataBank NDDF Plus Source Vocabulary) VANDF - 12/18/2007 (Veterans Health Administration National Drug File) This release does not contain updates to this source: SNOMED CT - 07/31/2007 (SNOMED Clinical Terms (drug information). SNOMED International) 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_02012008.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 483 MB of free hard disk space (To accomodate ZIP files and unzipped contents). CONTENTS OF THE ZIP FILE ------------------------- The ZIP formatted file is 53,582,281 bytes and contains the following 19 files and 2 directories: Readme_Full_02012008.txt 3,258 bytes rrf directory: RXNCONSO.RRF 80,943,240 bytes RXNDOC.RRF 150,698 bytes RXNREL.RRF 83,894,612 bytes RXNSAB.RRF 5,818 bytes RXNSAT.RRF 240,824,052 bytes RXNSTY.RRF 11,905,076 bytes RXNATOMARCHIVE.RRF 21,590,023 bytes RXNCUICHANGES.RRF 321,392 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 674 bytes RXNSAT.ctl 376 bytes RXNSTY.ctl 267 bytes RxNormDDL.sql 3,125 bytes populate_oracle_rxn_db.bat 1,089 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