September 2, 2008

README: RxNorm 09/02/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 nine sources:

GS - 08/11/2008 (Gold Standard Alchemy)
MDDB - 08/06/2008 (Master Drug Data Base. Medi-Span, a division of Wolters Kluwer Health) 
MMSL - 08/01/2008 (Multum MediSource Lexicon) 
MMX - 08/04/2008  (Micromedex DRUGDEX)
MTHFDA - 08/04/2008 (FDA National Drug Code Directory)
MTHSPL - 08/26/2008 (FDA Structured Product Labels) 
NDDF - 08/08/2008 (First DataBank NDDF Plus Source Vocabulary)
SNOMED CT - 07/31/2008 (SNOMED Clinical Terms (drug information). SNOMED International)
VANDF - 08/11/2008 (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.

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_09022008.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 497 MB of free hard disk space (To accomodate ZIP files and 
	unzipped contents).  


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

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

	Readme_Full_09022008.txt	3,583		bytes

rrf directory:

	RXNCONSO.RRF			83,929,156	bytes
	RXNDOC.RRF			150,000		bytes
	RXNREL.RRF			86,573,038	bytes
	RXNSAB.RRF			5,842		bytes		
        RXNSAT.RRF			244,387,156	bytes 
	RXNSTY.RRF			11,965,979	bytes
	RXNATOMARCHIVE.RRF		24,985,244	bytes
	RXNCUICHANGES.RRF		392,253		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,532		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