October 1, 2008

README: RxNorm 10/01/2008 Full Update Release
===================================================

-----------------------------------------------------------------
This Full release contains data that is consistent with the 
2008AA version of the UMLS.   
-----------------------------------------------------------------

This release contains updates to the following eight sources:

GS - 09/07/2008 (Gold Standard Alchemy)
MDDB - 09/03/2008 (Master Drug Data Base. Medi-Span, a division of Wolters Kluwer Health) 
MMSL - 09/01/2008 (Multum MediSource Lexicon) 
MMX - 09/02/2008  (Micromedex DRUGDEX)
MTHFDA - 09/02/2008 (FDA National Drug Code Directory)
MTHSPL - 09/22/2008 (FDA Structured Product Labels) 
NDDF - 09/05/2008 (First DataBank NDDF Plus Source Vocabulary)
VANDF - 09/08/2008 (Veterans Health Administration National Drug File)

This release does not contain any updates to this source:

SNOMED CT - 07/31/2008 (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.

This release contains database control files and SQL
commands for use in the automation of the loading process of
these files into an Oracle RDBMS.  In addition, scripts are now 
provided for loading the RxNorm files into a MySQL database.
 
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_10012008.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 498 MB of free hard disk space (To accomodate ZIP files and 
	unzipped contents).  


CONTENTS OF THE ZIP FILE
-------------------------

The ZIP formatted file is 55,311,171 bytes and contains the 
following 26 files and 4 directories:

	Readme_Full_10012008.txt	3,642		bytes

rrf directory:

	RXNCONSO.RRF			84,003,505	bytes
	RXNDOC.RRF			150,000		bytes
	RXNREL.RRF			86,670,683	bytes
	RXNSAB.RRF			5,855		bytes		
        RXNSAT.RRF			244,717,396	bytes 
	RXNSTY.RRF			11,986,680	bytes
	RXNATOMARCHIVE.RRF		25,470,578	bytes
	RXNCUICHANGES.RRF		187,179		bytes

scripts directory:

	oracle sub-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
	rxn_index.sql			660		bytes
	populate_oracle_rxn_db.bat	1,089		bytes

	mysql sub-directory:

	Indexes_mysql_rxn.sql		662		bytes	
	Load_scripts_mysql_rxn_unix.sql	3,516		bytes
	Load_scripts_mysql_rxn_win.sql	3,516		bytes
	Populate_mysql_rxn.bat		777		bytes
	populate_mysql_rxn.sh		1,609		bytes
	Table_scripts_mysql_rxn.sql	4,035		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